#Shorts | Extract Unique List Using Formula in Excel | Extract unique items in Excel

preview_player
Показать описание
#Shorts
If your database contains multiple or duplicate records and you want to extract unique list from that database dynamically using formulas in Excel, This video is for you.



Checkout some other Excel short trick👇

Convert Numbers to Roman and Roman to Numbers👇


Insert all Pivottable Fields in Value at Once👇

Subtotal and Summarize data👇

Show Hidden Data in Excel Chart👇

Auto Indexing In Excel👇

Prevent Extra Spaces during Data Entry in Excel👇

SUM in Blank Excel Cells👇

How to sort a pivot table with a custom list👇
Рекомендации по теме
Комментарии
Автор

Very helpful, I don't need to buy 365.🙃
Thanks Sir!

SindyM
Автор

How about the opposite one? When you're trying to extract the duplicated names?

louellamaedizon
Автор

Sir, can't understand in formula C$1:C1 means?? Please clear me...

mdabusadek
Автор

सर में चाहता हु की जब मैं न्यू एंट्री करू ओर मैन एक कॉलम में यूनिक लिस्ट बना ली फार्मूला लगाके ओर इसके आगे काउंट की लिस्ट बना ली फार्मूला गला के लेकिन जब रिपीट होने व वाले या न्यू एंट्री दयालु तो यूनिक और काउंट वाले में आटोमेटिक चेंज हो उसके लिए फार्मूला बताओ

Sagarkumar-qjhl
Автор

Use remove duplicate that is very easy.

ayubkhan
Автор

Please ithna bada formulas nakko muje😂

suryasikendar
Автор

Useless formula.There are many other simple options available

farooqtahir
Автор

Itna langadh pech kyu kare ham ..😅😅😅ham to direct= karke column poora select karke enter kar denge tab bhi to jo usme update hota rahega 😂😂😂😂

MohdShahzad-plhe
Автор

Countifs giving result zero. But match is giving result 1. I dont understand this. Can you clear. Because if 0 is compare with 0 then how match giving result 1. Please explain

Vicky_Sing
Автор

Areyy bhaiya y to bhutt tough kar diya

trickyaryan
Автор

thank you, if we need find reverse results then ? not unique cells

anirbansen
Автор

Easy option : Select the Column.. Go to Data - Remove Duplicate. Done!

bhushanshetty
Автор

bhai agr colum a list ka table banay kesy banyga jis ma bar show kary ka amrit 5 br ha ya vijay 2 br ha etc

mohibawan
Автор

Thanks sir
Spanish main karte thora time laga lakin kaam aya shukria
INDEX - INDICE
MATCH - COINCIDIR
COUNTIF - CONTAR.SI
IFERROR- SI.ERROR

syedjamshaidhussain
Автор

I already knew this amazing trick, keep it up..

souvikdas
Автор

I see result as 0, the formula used is same as shown. Any help on this please.

shrivani
Автор

I'm from Brazil, thanks. I use Excel 2016 and the single function doesn't exist.

vincentvangogh
Автор

I want count the number of name and not repeat the name, please suggest the formula

RahulSharma-eynq
Автор

Directly use "Remove Duplicates"

civilexplorer
Автор

how to do this function between different sheets

thetlynnnaing