Formula to calculate how many unique items

Good Morning all...

I've attached a copy of the sheet I am using.

What it is is that I'm trying to calculate at the top how many runs there are...

My formula is taking every single entry as a run... when infact a run is defined by 1 set of gritters going out on that day at that time...

For example...

If 43 gritters go out on runs... all at 20:00 hours on the 3rd of Nov 2012... that would count as 1 Run...

Is there anyway to do this?

Any help would be appreciated, thank you very much.

So you want to count unique time in B column?? If so, here is the formula

Formula:

Please Login or Register  to view this content.

It's date... and time to be honest.

For example if all 43 go out at 21:00 on the 3/11/12 that would count as 1 run.

You can try this formula.

Formula:

Please Login or Register  to view this content.

Entered with ctrl+Shift+Enter

Originally Posted by dilipandey

ok.. and how you are obtaining 43 and 21 ?
is it the maximum number and maximum time on any given date? thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

43 is the number of routes available... so on any given night at any given time. 1-43 runs could go out... but they would all equal 1 run. If they went out at the same time and same date.

If I could get something that calculated on my right most column the times... and compared that to the date = how many runs. That would be perfect.

Thanks btw for all your help. And I will try that forumla Sindhus.

bumpppppppp