365 Is it possible to use a formula to get the result of E2:F5 Only ONE formula (1+2)
Originally used two formulas to get the perfect result, I want to use one formula to get two results, so that the task can be completed and done?
1. Cell E2 formula =SORT(UNIQUE(B2:B23))
2. Cell F2 formula =COUNTA(UNIQUE(FILTER(A:A,B:B=E2)))
Can someone please help me ? It would be much appreciated. Thanks in advance
Bookmarks