identifying when the same value appears more than once in a column

[bmunoz64]

Good morning forum,

Trying to sort out my formula headaches...
[*]In column A (rows 2 through 124), I have a list of accounts[*]In column C (rows 2 through 124), I have the list of individuals that credited these accounts[*]In Column D (rows 2 throough 124), I am looking for a formula that will bring up the name of the individuals that credited the same account

Thanks for all the help!

Bruno

[Dave Diller]

Autofilter, then sort? If you sort by Ascending in Column C, it'll list all of the names of the account creaters and in Column A it'll have a list of the account numbers.

Is that kind of what you want?

(Note: in 03, go to 'Data --> Filter --> Autofilter'. In 07, I'd have to double check since I don't have 07 here at work)

[zbor]

Is this OK?

(didn't understand are you looking by C column or A... This is example for c column if you looking for A everything is the same except you write everywhere A)

Book1.xls