Sir, Looking for one more information. I want the total sum of all the unique values. For example: if i want the total sales values of all the 19 unique person then how to find. Please guide 🙏🙏
thnak you manoj ji for this video...par ye bataiye ke agar ye jo uniqe data create hua hai isko agar uski excel ke kisi dusre sheet me create karna hoga to kaise karenge ?
Match ka value har ek cell mein 1 hi aa raha hai jiske wajah se sabhi cell ka row number 1 hi reh jaa raha hai aur sabhi cell mein range ke 1 row ka value hi repeat ho raha hai. Give me some solution.
Mention Sheet name with "!" before range. EX: in Sheet2 in Cell B2 > " =IFERROR(INDEX(Report!$C$6:$C$168,MATCH(0,COUNTIF($B$1:B1,Report!$C$6:$C$168),0)),"") " Ok...
Sir,
Looking for one more information.
I want the total sum of all the unique values.
For example: if i want the total sales values of all the 19 unique person then how to find.
Please guide 🙏🙏
Excelente vídeo amigo
Nice very knowledgeable 😊
Sir....thank you so much....nailed it.... finally got it have been looking for so long..
Thanks
Be in touch
excelgurumanoj@gmail.com
Thank you so much very helpful
Thank you 🙏
thnak you manoj ji for this video...par ye bataiye ke agar ye jo uniqe data create hua hai isko agar uski excel ke kisi dusre sheet me create karna hoga to kaise karenge ?
Copy and paste as value kigiye
excellent
Bom dia meu amigo tudo bem com você 😊👍
😂good
Kl use karunga sahi hai ye
Match ka value har ek cell mein 1 hi aa raha hai jiske wajah se sabhi cell ka row number 1 hi reh jaa raha hai aur sabhi cell mein range ke 1 row ka value hi repeat ho raha hai.
Give me some solution.
contact me
excelgurumanoj@gmail.com
Hi, the same formula doesn''t works when I try to grab list of unique values from another sheet. Do you have any turnaround for that?
Mention Sheet name with "!" before range. EX: in Sheet2 in Cell B2 > " =IFERROR(INDEX(Report!$C$6:$C$168,MATCH(0,COUNTIF($B$1:B1,Report!$C$6:$C$168),0)),"") " Ok...
Old date me formula kaise add kare date purana same huna chaahiye kesai formula add kare sir
Contact me
excelgurumanoj@gmail.com
डुप्लीकेट रिमूव करो लेकिन डाटा adjust na ho vh blank ho jaye
th-cam.com/video/zXnvO10SULM/w-d-xo.html
range aapne F1 se kyu li thoda ye samjha do
contact me
excelgurumanoj@gmail.com
Thoda kam bola kro sit
agar column me data filter lagao to ye work nahi karta.
Contact me
excelgurumanoj@gmail.com
3242
It just return 0