I?m trying to build an offset formula to count the unique/not repetitive numbers from Sheet1 column? B? to Sheet2 column ?B2?. What I want to do is I Sheet1 find today?s date in column ?A? this case March 05, 2008 and from that row then start counting the Units from that day in column ?B?(not counting the repetitive ), and show the total number of units in Sheet 2 cell "B2"
Can somebody help? Attached sample workbook
Thanks!
Use this array formula
=COUNT(1/FREQUENCY(IF(Sheet1!A2:A100=TODAY(),IF(Sheet1!B2:B100<>"",Sheet1!B2:B100)), IF(Sheet1!A2:A100=TODAY(),IF(Sheet1!B2:B100<>"",Sheet1!B2:B100))))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Xld, thanks for the help, I got little trouble adapting it, but got it working. Works great!
Thanks gain!
Posting Permissions
Reply With Quote
