Checkout the video link below for your query, ruclips.net/video/p3H8_XOxF8Y/видео.html Well if you are using Microsoft 365 or Microsoft 2021 excel, you can easily achive this result by using filter and unique function.
Fix Karne ke liye Dollar sign lagate hai, uske liye function key F4 Press karna hota hai. 1 Time Press Karne par pura cell fixe hoga -$A$1 2 Time Press Karne par sirf row fixe hoga -A$1 3 Time Press Karne par sirf Column fixe hoga -$A1
In excel sheet State is mention with product. What is the formula to when I Select the product the State names is come in The excel but no repeat the State name Please sir help me
Excellent...
Thanks 😊
if there is any blank cell in database then it give result 0 and need to remove this 0 from unique list, can you please share solutions??
Checkout the video link below for your query,
ruclips.net/video/p3H8_XOxF8Y/видео.html
Well if you are using Microsoft 365 or Microsoft 2021 excel, you can easily achive this result by using filter and unique function.
Well explained ...Thank you
Thanks for your valuable feedbac😊
THANKS SIR I AM SEARCHING ALTERNATE OF UNIQUE FUCTION OFFICE 365 . SO THAT VERY VERY THANKS.
Nice 🙏👍
Sir fix kase karte ha
Fix Karne ke liye Dollar sign lagate hai, uske liye function key F4 Press karna hota hai.
1 Time Press Karne par pura cell fixe hoga -$A$1
2 Time Press Karne par sirf row fixe hoga -A$1
3 Time Press Karne par sirf Column fixe hoga -$A1
In excel sheet State is mention with product.
What is the formula to when I Select the product the State names is come in The excel but no repeat the State name
Please sir help me
Best way to do this with Pivot Table.
@@ExcelUniverse Please provide formula not in Pivot table Sir
@@RahulSharma-ey4nq let me work for you.
Please Use this to combine from multiple sheets
Can you pls share any sample file
@@ExcelUniverse
Yes Sir Please Give email or Whatsapp contact
Whatsapp at 97081 53000
result is 0
Pls share your file where you applied formula. Whatsapp at 97081 53000