ShirLowMingHan
New Member
- Joined
- Jun 17, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hey guys! I am looking a way out to get the number of unique customer that have bought product in year 2011. And the table contains full date from 2011 to 2013. I have been using =SUM(COUNTIFS(Table1[Date],">="&DATE(2011,1,1),Table1[Date],"<="&DATE(2011,12,31))) to get the number of rows that date between 2011 and =COUNTA(UNIQUE(Table1[Customer Name])) to get the number of unique customer. But when I tried to combine the I failed to get the correct outcome... Appreciate your help, also if there is any method that is easier than mine please do let me know!