Steve,
What about the duplicate entries....
If a value is repeated thrice i want that to be counted as once.
i dont know if im clear
A1 = India
A2 = India
A3 = Australia
A4 = America
in B1 i want a formula where in it should count unique entries which means i actually have 3 entries (India is repeated twice)
Hey Richard, Thank you Sir. That helped me.
but id like to addon ....
A1 = Rajiv
A2 = Rajiv
A3 = Richard
A4 = Steve
A5 = Rajiv
===========
B1 = India
B2 = India
B3 = UK
B4 = Australia
B5 = Australia
Now i want to know If Cell C1 = Rajiv then how many unique entries for rajiv the result should be 2.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.