IgnBan
03-05-2008, 06:20 AM
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! :thumb
Can somebody help? Attached sample workbook
Thanks! :thumb