+ Post New Thread
Results 1 to 11 of 11
Office Software Thread, more excel help needed please in Technical; I have a spreadsheet of addresses, and some address' have the same postcode as others. I am trying to pull ...
  1. #1

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200

    more excel help needed please

    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?

  2. #2

    Andrew_C's Avatar
    Join Date
    Sep 2005
    Location
    Winchester
    Posts
    3,087
    Thank Post
    64
    Thanked 404 Times in 307 Posts
    Rep Power
    165
    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.

  3. #3

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    the postcodes are in a cell on their own

  4. #4

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    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.

  5. #5


    Join Date
    Feb 2007
    Location
    Northamptonshire
    Posts
    4,701
    Thank Post
    352
    Thanked 805 Times in 720 Posts
    Rep Power
    348
    F2


  6. Thanks to kmount from:

    RabbieBurns (21st August 2008)

  7. #6
    ShorehamGeek's Avatar
    Join Date
    Feb 2006
    Location
    Shoreham
    Posts
    87
    Thank Post
    19
    Thanked 21 Times in 18 Posts
    Rep Power
    25
    Try pressing F2 when you've highlighted the cell you want to edit. (just too slow!)

  8. Thanks to ShorehamGeek from:

    RabbieBurns (21st August 2008)

  9. #7

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    thanks both of you!!!

    cant believe ive got this far without knowing that

  10. #8

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    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 ?

  11. #9

    RabbieBurns's Avatar
    Join Date
    Apr 2008
    Location
    Sydney
    Posts
    5,532
    Thank Post
    1,341
    Thanked 470 Times in 307 Posts
    Blog Entries
    6
    Rep Power
    200
    edit: my A and B comparing doesnt seem to be working either

  12. #10
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    Quote Originally Posted by RabbieBurns View Post
    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.
    Last edited by leco; 4th September 2008 at 05:29 PM.

  13. #11

    Join Date
    Sep 2008
    Location
    Newcastle upon Tyne
    Posts
    17
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Duplicate values

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



SHARE:
+ Post New Thread

Similar Threads

  1. Excel Question / Formula Needed
    By timbo343 in forum How do you do....it?
    Replies: 22
    Last Post: 4th August 2008, 10:06 PM
  2. Excel
    By Edu-IT in forum How do you do....it?
    Replies: 13
    Last Post: 7th March 2008, 09:57 AM
  3. help with excel macro needed
    By oyoung in forum Windows
    Replies: 0
    Last Post: 30th March 2007, 11:27 AM
  4. advice needed on weather a new server is needed
    By projector1 in forum Hardware
    Replies: 3
    Last Post: 24th February 2006, 10:20 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •