Hello guys,
I've learnt lost of stuff here, but this kind of problem is still way of my league
I just simple need to count different date, that means :how many different days is in this area? I've uploaded sample sheet for better understanding, thank you for any help !1. kolo 13.8.2011 13.8.2011 13.8.2011 13.8.2011 13.8.2011 13.8.2011 13.8.2011 14.8.2011 14.8.2011 15.8.2011
Last edited by miso.dca; 11-18-2011 at 08:39 AM.
Try this:
=OFFSET(INDIRECT("A"&MATCH(F1,$A$1:$A$418,0)),10,)-OFFSET(INDIRECT("A"&MATCH(F1,$A$1:$A$418,0)),1,)+1
I really dont understand how you did it, but it worksso thank you very much !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks