Unique Count in Excel‼️ #excel

preview_player
Показать описание
In this video, you will learn how to extract unique entries from a list and count how many times each occurs in Excel!

🗂️ Don't forget to save this post!

#excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials
Рекомендации по теме
Комментарии
Автор

Replace "F3" by "F3#" in the last function to avoid having to drag the formula down

BarMinesNancy
Автор

Why not the # sign in front of the F3 so that it automatically expand according to the results?

sarabella
Автор

Huh I didn’t know about the Unique formula.
I always made a copy and removed duplicates or used powerquery
Could you do POWER QUERY videos?
Most people who watch these probably know excel well enough

andradam
Автор

Pretty sure the unique function doesn’t exist in older excel versions

fuzzybanana
Автор

Stop using =countif, functions. Do a pivot table instead 😝😝🤪

auslander