Forum Discussion

cmav99's avatar
cmav99
Copper Contributor
Apr 28, 2020
Solved

Count unique values from one column based on value in other column

Hi,   I have 2 tabs in my excel sheet. Tab 2 contains this data: ID COLOUR 28 Red 28 Red 28 Red 28 Blue 28 Yellow 28 Grey 28 Grey 28 Green 28 Green 28 Green 28 Green ...
excel
  • Zack Barresse's avatar
    Zack Barresse
    Apr 28, 2020
    Hi there,

    If you are using a Microsoft 365 subscription for Office, you can use this formula:

    =COUNTA(UNIQUE(FILTER('Tab 2'!$B$2:$B$16,'Tab 2'!$A$2:$A$16=A2)))
cmav99's avatar
cmav99
Copper Contributor
Apr 28, 2020

Thanks for the response Zack

Zack Barresse's avatar
Zack Barresse
Iron Contributor
Apr 28, 2020
You are very welcome. Glad to help. 🙂