more excel help needed please

[RabbieBurns]

I have a spreadsheet of addresses, and some address' have the same postcode as others.

 

I am trying to pull out all the rows that have the same postcode as another row.

 

Is this possible, how would I go about it?

[Andrew_C]

Are all the postcodes the last 7 or 8 characters in the field? If so, you could use a similar technique to your earlier question. Can't quite remember what the answer was then. Could use "Right" as well, but I'm sure you'll get a more definite answer soon.

[RabbieBurns]

the postcodes are in a cell on their own

[RabbieBurns]

Its sorted I just went through and did it all manually

 

One other thing though, when using the keyboard to navigate through cells how can you type to append text and not overwrite the contents without using the mouse to double click on the cell? Been bugging me for years.

[kmount]

F2

 

[ShorehamGeek]

Try pressing F2 when you've highlighted the cell you want to edit. (just too slow!)

[RabbieBurns]

thanks both of you!!!

 

cant believe ive got this far without knowing that

[RabbieBurns]

Me again with more excel woes ...

 

Trying to compare 2 sets of columns, basically A B C D i want to check that A=B and C=D and then in column E to show YES or NO (1 or 0 or whatever)

 

I can get A and B comparing but not sure how to combine it into 1 column ?

[RabbieBurns]

edit: my A and B comparing doesnt seem to be working either

[leco]

Me again with more excel woes ...

 

Trying to compare 2 sets of columns, basically A B C D i want to check that A=B and C=D and then in column E to show YES or NO (1 or 0 or whatever)

 

I can get A and B comparing but not sure how to combine it into 1 column ?

Try this

=IF((A2=B2)*AND(C2=D2),1,0)

 

Edit: Sorry should have said, put this in E1, then copy down if or where necessary. It works like an If...then...else statement.

 

If condition (A2=B2)*AND(C2=D2) is TRUE then return 1 if the condition is FALSE then return 0

You could substitute the 1 and 0 for Yes and No.

 

Hope this helps.

Edited September 4, 2008 by leco

[tw15ns]

In 2007 search help for duplicate values and then follow the "Filter for unique values or remove duplicate values link"