Join my COMMUNITY "XL Dataverse by Amit" to Participate in The BIG BANG Excel Challenge that starts on the Community on 30th Sep 2024! Click on the link below on your Mobile ( iOS, Android) to join XL Dataverse now 👇 teams.live.com/l/community/FEAux23kX8AAJkTXAM
This video is a must-watch for Excel users! 5 top functions in Excel explained beautifully. This will surely boost your efficiency manifold. Highly recommended.
The problem of concatenate while comparing with Textjoin() function can be overcome by using trim() function as under:- =TRIM(CONCATENATE(A2," ",B2," ",C2)) However, Textjoin() function can be convinient to use.
Yes space problem can be solved with trim but you need to select all items one by one further in case of any number, TRIM will not work so you need to consider these factors. Hence Textjoin is still a better functions if available with user
![Advance Filter on Large Data in Excel | Filter vs VLOOKUP | [Hindi] #excel](/img/n.gif)
Join my COMMUNITY "XL Dataverse by Amit" to Participate in The BIG BANG Excel Challenge that starts on the Community on 30th Sep 2024!
Click on the link below on your Mobile ( iOS, Android) to join XL Dataverse now 👇
teams.live.com/l/community/FEAux23kX8AAJkTXAM
This video is a must-watch for Excel users! 5 top functions in Excel explained beautifully. This will surely boost your efficiency manifold. Highly recommended.
Incredibly useful video! This will surely multiply my spreadsheet skills and change my professional life. It’s a great resource. Thank you, Sir.
Vlookup function also works for right to left condition only require to apply one more function choose under vlookup for output
The problem of concatenate while comparing with Textjoin() function can be overcome by using trim() function as under:-
=TRIM(CONCATENATE(A2," ",B2," ",C2))
However, Textjoin() function can be convinient to use.
Yes space problem can be solved with trim but you need to select all items one by one further in case of any number, TRIM will not work so you need to consider these factors. Hence Textjoin is still a better functions if available with user
Plz new update laao
Jaise msme ki report kaise ready kre uske ke lia konsa formula better hoga
8:02 hello sir, agar ye count if s me 2nd criteria full fill nahi hota, to kya ye formula tabhhi kaam karega?
The purpose of this formulas is to match both conditions, so if any one of these is not met , there will be no result
@fintaxprime Okay, sir,