Thanks for this explanation. I have a little different requirement. Just as you have 2 columns of data. I have only one column with duplicate records. I dont need highlighting the cells but i want the result same as shown in cell E3 for duplicate records. please reply asap
i have two spared sheets one is called stock with price and another is called calculator in a stock sheet there is 3 columns category and sub category and price that shows in calculator sheet in list form i am not able to get a specific price of category and subcategory wise ex fruit is category and apple is sub category and 100 is price in calculator sheet fruit and apple are showing but how can i get the price of it please help me............ looking to hear from you..
totally disagreed..... is se asan treeqa hai 2 colum ko slect karin ... conditional formatting > highlights celles rules > duplicate values ki option per click kar k ok kar dain to duplicates cells ajay gy .....
Thanks sirji
Thank you sir
Very helpful thnx sir
👍👍👍👍👍 Thank You, Sir.🙏🙏🙏🙏🙏
Gajab
Sir apka video bhut hi acha lga ek chiz smjh nhi aai ki jo match data hai usko filter krke alg sheet par kese save kre
Nice ❤
Very nice video. Thanks.
THANKS , IT'S VERY HELPFULL
Thank u sir i like it,,
Very helpful
THANK U SIR JI....
very good
Thanks for this explanation. I have a little different requirement. Just as you have 2 columns of data. I have only one column with duplicate records. I dont need highlighting the cells but i want the result same as shown in cell E3 for duplicate records. please reply asap
1no.
It wont work on large data
One thing if i want to count match between two columns as well as within the column so how if that going to be done .. thanks in Adv
sir excel mai same entry ka total ek hi cell mai kaise kare please help
Hilide kya cell kese copy karonge?
Sir ager kissi list may only same salary waly names ko show karna hy tho kaisy karain please
Sir yadi do sheet me same naam ko match krke avshesh naam kaise alag karenge
How to count duplicate numbers in on column
i have two spared sheets one is called stock with price
and another is called calculator
in a stock sheet there is 3 columns category and sub category and price
that shows in calculator sheet in list form
i am not able to get a specific price of category and subcategory wise
ex fruit is category and apple is sub category and 100 is price
in calculator sheet fruit and apple are showing but how can i get the price of it
please help me............
looking to hear from you..
Multiple column kese match karenge
Sir agr duplicate value ho aor ham aik cell mein data enter karen aor tamam mein same data chala jaye please
Sir duplicate naam ko copy karne ka Tarika hai vo or pata chal jae
Sir match duplicates Ko ak saath delet kaise kare
Muzhe yee duplicate Data alag karna hai
Kese hoga
Plz help
Plz uska ek video bnau
Newmeri digit ho to isme kya karna h
F4 key work nhi kr rhi h
Sir if in reconciliation two column same value is there how to find duplicte
Sir, haw can make a droplist without duplicats
Use remove duplicate then make a dropdown list of unique value.
Duplicate naam h pr uski QTY alg h to naam ek br aaye or jo QTY h uska SUM ho jye aise kaise kre
Sumif ya sumifs ka use karen
totally disagreed..... is se asan treeqa hai 2 colum ko slect karin ... conditional formatting > highlights celles rules > duplicate values ki option per click kar k ok kar dain to duplicates cells ajay gy .....
Fake video. I have tried but this is not working
Thank you sir