Excel help required.
Author
Discussion

megy

Original Poster:

2,429 posts

245 months

Friday 17th August 2007
quotequote all
I had great success asking for an Excel spreadsheet formula a few weeks ago, I need another and cannot work out how to do it so I thought I would see if I get the same success again.

I have a list of numbers of which some may be duplicated, is there an easy formula I can insert into a corresponding column to look at the number above and mark a 'Y' in the column if that number is the same(say J345 is the same as J346), the numbers will be sorted for ease.

Thanks in advance for any help.

Vee

3,109 posts

265 months

Friday 17th August 2007
quotequote all
Say your data is in column A1:A200 with some duplicates
In B1 type =countif($A$1:$A$200,A1) and then copy this down to B200
This will say how many times the value in the adjacent cell appears in the list in column A


TonyHetherington

32,091 posts

281 months

Friday 17th August 2007
quotequote all
Isn't that a complicated way of doing it?

Can't you just use an IF statement?

i.e. in column B2, IF A2 = A3 = Y (if I understood your question right?)

TonyHetherington

32,091 posts

281 months

Friday 17th August 2007
quotequote all
in B2....

=IF(A2=A1,"Y" , " " )

where column A is your list of numbers

edit; arse PH tries to format the "&quotwink's and things. Take out all the spaces I'm just about to put in the formula

Edited by TonyHetherington on Friday 17th August 09:13