LEN and TRIM functions - I'll use these for lots of work thanks!
@HowToAnalyst2 жыл бұрын
Glad to hear Kevin!
@carlynicolay16872 жыл бұрын
I desperately need this video! I have experienced all of these errors
@HowToAnalyst2 жыл бұрын
Hope it’s helpful Carly
@luizakulchetscki29703 ай бұрын
I can't thank you enough. I was nearly in tears. Thank you!
@HowToAnalyst3 ай бұрын
So glad to help, what are you working on?
@luizakulchetscki29703 ай бұрын
@@HowToAnalyst I was trying to conduct an Anderson-Darling test on some data as part of my master's thesis. Halfway through my data the #N/A error sign would show up. It was the F4 feature that was missing, to lock in the range.
@anujitmaity072210 ай бұрын
1:50 huge thanks
@HowToAnalyst10 ай бұрын
You're welcome, glad it helped!
@nateblack9723 ай бұрын
TRIM worked 🎉 thanks
@HowToAnalyst3 ай бұрын
Good to hear
@pratheepanbalendran988911 ай бұрын
It's very useful video
@HowToAnalyst11 ай бұрын
Glad it helped!
@user-di4rx3qc9w3 ай бұрын
on my system while xlookup working properly on his system at same file. # value error is showing on my system
@fabricemercier29557 ай бұрын
Thanks!!!!!!!
@thangaveluraj2 жыл бұрын
Useful but very basic and trivial
@HowToAnalyst2 жыл бұрын
Thank you for sharing - what was the problem?
@benfithian6592 жыл бұрын
Sir, you have great hair
@KyleSorenti2 жыл бұрын
Did you know that the “V” in ‘Vlookup’ stands for “Vertical”? #funfact