Excel Formula Question

jamesblue

Lil306 wrote: »

Think this may work

=IF(COUNTIF(B:B,B2)>1,"More than 1 date","Only 1 day")

Basically, it checks the cell range B:B (dates entered being in column b) and looks to see how many times the entry from cell B2 appears in that range, the formula than says if that date appears >1 time, then "more than 1 day worked", otherwise if it appears only once then "only 1 day worked"

Does that help, formula can then be replicated down the sheet?

EDIT - Attached picture, probably easier to explain looking at it than typing it.

Thanks for you help but just worked out a better way, it is using the frequency function, see the following

=SUM(IF(FREQUENCY(A1:A10,A1:A10)>0,1))

It works a treat.


Thanks for all your help, that was a real brain teaser.

Lil306

NP, always like helping

P.S Use the [code] tag, it's better for hiding those damn angel faces lol

jamesblue

Lil306 wrote: »

NP, always like helping

P.S Use the [code] tag, it's better for hiding those damn angel faces lol

Yeah thanks, i never released until i posted it.

Thanks again