Count Unique value & count only duplicate value

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 02:30 AM.