Help With Formula

  steviegee 09:51 13 Jan 2011
Locked

I have a spreadsheet with a lot of data. In column C I have various data and in column D I want a formula to put how many times it appears e.g in C2, C3 and C4 it may have 'fred' in each cell so in D2 I need 1 entered in D3 I want 2 entered and in D4 I want 3 entered, in C5 and C6 it may have 'dave' in it so in D5 I need 1 and D6 I need 2 and so on so I can fire it down the 5000 rows it may have. I hope this is clear enough!

  VoG II 09:57 13 Jan 2011

Try in D2 copied down

=COUNTIF(C$2:C2,C2)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

See mcbess's iconic style animated for Mercedes-Benz

iPhone X news: Release date, price, new features & specs

Black Friday 2017 : date, sites participants & bonnes affaires