in spreadsheet recurring entries

AI Training: For Busy Decision Makers & Professionals Book now

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

resolvedResolved · Medium Priority · Version 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:

Select only cell that contain text to lock format

For selecting cells that only contain Text in Excel

By selecting cells that only contain text, you can delete, fill or protect cells of this type.

Use short cut to Go to box (F5) or Edit, Go to
In the dialog box, click special button & select Constants and only check text or any other desired type.

Click OK.

And text cells will all be highlighted for you to apply format. Please note only works on one sheet at a time.

View all Excel hints and tips


Server loaded in 0.11 secs.