Count Unique value & count only duplicate value

		Microsoft Office Forums > Microsoft Excel > Excel
Count Unique value & count only duplicate value

FAQ

Thread Tools

Display Modes

05-18-2024, 04:09 AM

stricky

Windows 10 Count Unique value & count only duplicate value

Office 2019

Novice

Join Date: Jun 2023

Location: Bangladesh

Posts: 25

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

TEST COUNT.png (68.0 KB, 23 views)

Attached Files

TEST COUNT.xlsx (32.4 KB, 6 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count formula to count based on multiple criteria and return unique rows	Sphinxakop	Excel	0	02-01-2023 12:18 PM
Count Unique Instances of Multiple Strings Using Wildcards	robnun	Word VBA	14	12-05-2020 08:50 AM
Count Duplicate Values without a specific Unique Value	Brittni	Excel	1	02-01-2017 06:22 PM
Count unique values that match 2 or more criteria	caeiro01	Excel	1	10-25-2015 02:34 AM
Display unique values and count the number of child items	vthomeschoolmom	Excel	2	07-25-2013 06:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:46 AM.