Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

in spreadsheet recurring entries

Forum home » Delegate support and help forum » Microsoft Excel Training and help » In a spreadsheet with recurring entries, How do I count unique e

In a spreadsheet with recurring entries, How do I count unique e

ResolvedVersion 365

In a spreadsheet with recurring entries, How do I count unique e

In a spreadsheet with recurring entries, How do I count unique entries in a column?

RE: In a spreadsheet with recurring entries, How do I count uniq

Hi George,

Thank you for the forum question.

Try:

=COUNT(UNIQUE(A4:A14))


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Excel tip:

Large Icons on toolbar

You can make the buttons on your toolbars bigger by going to Tools / Customize / Options / select Large icons.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.