Help With Formula

  steviegee 09:51 13 Jan 11
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 11

Try in D2 copied down

=COUNTIF(C$2:C2,C2)

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

The updated 'Corel Painter inside Photoshop' plugin ParticleShop offers new brushes

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…