This is a question posed from one of my clients. Can anyone help please>
What I want to know is if there is a column of dates (or numbers) if there
a way of easily finding out if there is, for example a date missing, even
if the dates aren't in date order. As it is easy to see if there are a
few, but if there are pages of dates and we want to make sure each date is
accounted for its not so easy.
Last edited by Lynneth; 08-24-2010 at 03:38 AM. Reason: Did not explain question very well
Does the range contain duplicate dates?
Entia non sunt multiplicanda sine necessitate
Not that I am aware of
=IF(MAX(A1:A10) - MIN(A1:A10) + 1 = COUNT(A1:A10), "ok", "missing dates")
Does that identify which dates are missing?
What my client is looking for is a way to identify the missing dates, as shown below. I hope this explains it better. Thank you for your help - I really appreciate it
Name Date
Bill 25/05/2010
Don 26/05/2010
Stan 27/05/2010
Rob 28/05/2010
Net 29/05/2010
Matt 30/05/2010
Jane 31/05/2010
John 01/06/2010
Lynne 02/06/2010
Pete 03/06/2010
Paul 05/06/2010
Iack 06/06/2010
Helen 07/06/2010
Robin 08/06/2010
Will 09/06/2010
Mick 10/06/2010
Jim 11/06/2010
Mercy 13/06/2010
Pip 14/06/2010
Ken 15/06/2010
Emma 16/06/2010
That's a different problem.
Sort them by date and add a formula that subtracts adjacent values.
I had already done that, but wondered if there was another way if the dates were not consecutive
Thank you very much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks