Concatenate cells if, values of another column are the same as above

[McBee1989]

Hi,
I am having a bit of trouble with a nested IF statement...

Basically, I want column G to concatenate with the rows above it, IF, the values in column A are the same above. The number of values in column A varies from 2 - 9 so the formula I currently have doesn't work (pasted below).

=IF(A3<>A2,G3,IF(A3=A2,G3&"|"&G2))

So that work's if the values in column A only appear twice. However, if the value in column A appears 6, 7, 8 etc times, it doesn't work. Obviously I dont want it to concatenate if the value in column A changes to a new number.

Any help is appreciated.

Thanks

 

[Special-K99]

You dont need the second IF

IF(A3<>A2 then G3 otherwise
A3 MUST equal A2 so no need to test it again with IF(A3=A2...

It should simply be

=IF(A3<>A2,G3,G3&"|"&G2)

or even

G3&IF(A3<>A2,"","|"&G2)

Obviously this doesnt solve your main problem but is an improvement on your existing formula