Thread: Count Unique value & count only duplicate value
View Single Post
 
Old 05-18-2024, 04:09 AM
stricky stricky is offline Windows 10 Office 2019
Novice
  
Join Date: Jun 2023
Location: Bangladesh
Posts: 25
stricky is on a distinguished road
Default Count Unique value & count only duplicate value
First of all, I know about the unique function available on MS 365/ MS office 2021. But my company wont upgrade to those versions. so I'm stuck with 2019.


I need to Count Unique value & count only duplicate value of a excel sheet. I have explained it in attached excel sheet.


So please help me if anyone can.
Attached Images
File Type: png TEST COUNT.png (68.0 KB, 23 views)
Attached Files
File Type: xlsx TEST COUNT.xlsx (32.4 KB, 6 views)
Reply With Quote