1

I have two columns A:A (dates) and B:B (items)

..... I need to find a formula to calculate how many of each unique item are in column B : B in the last 365 days. In the example the right value in the formula is 2

CharlieRB
  • 22,754
Guglielmo Lauro
  • 11

1 Answers1

1
=count(unique(filter(B:B; A:A > today() - 365)))

The most interesting part is filter(B:B; A:A > today() - 365), which finds all items in 'B' column where there are 'A' column values greater than 365 days ago. Then leave only unique values and count them.

Chupaka
  • 161
  • 2
    While this may answer the question, for sake of improving the answer for other who may read it, it would be preferable to include some explanation how it works, why to use it, etc. Referencing a source is also beneficial too. – CharlieRB May 19 '15 at 13:51