PDA

View Full Version : Solved: Offset Count off another Sheets todays date



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

Bob Phillips
03-05-2008, 06:27 AM
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))))

IgnBan
03-05-2008, 07:56 AM
Xld, thanks for the help, I got little trouble adapting it, but got it working. Works great!

Thanks gain!