Help With Formula

  steviegee 09:51 13 Jan 11

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


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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac