Hey I am tracking when people post their food to a spreadsheet. But I am only looking to include unique dates.
As new posts are being added daily I went with an arrayformula to save the manual juggling.
The only problem is the countuniqueifs formula does not seem to work in an arrayformula.
My current formula is
=ARRAYFORMULA(countuniqueifs('Food Posts'!B2:B,'Food Posts'!A2:A,A2:A,'Food Posts'!B2:B,">="&B2:B,'Food Posts'!B2:B,"<="&B2:B+7))
And it works for the first row but nothing below defeating the purpose of the array.
The formula looks up the food posts by user and the date of posting and then pulls that into a separate sheet that creates a weekly count.
Any recommendations
As new posts are being added daily I went with an arrayformula to save the manual juggling.
The only problem is the countuniqueifs formula does not seem to work in an arrayformula.
My current formula is
=ARRAYFORMULA(countuniqueifs('Food Posts'!B2:B,'Food Posts'!A2:A,A2:A,'Food Posts'!B2:B,">="&B2:B,'Food Posts'!B2:B,"<="&B2:B+7))
And it works for the first row but nothing below defeating the purpose of the array.
The formula looks up the food posts by user and the date of posting and then pulls that into a separate sheet that creates a weekly count.
Any recommendations