How to use Dynamic Arrays in Excel and other Advanced Formulas

Рет қаралды 14,661

Simon Sez IT

Күн бұрын

Пікірлер

@KK-ch8yt 10 ай бұрын

Its like heaven of excel teaching

@albertoalamamoran6082 8 ай бұрын

A simply and straightforward marvelous Excel trainning explained and carried on by You Mrs.Ashby, all my support to your great channel and team of work. Stay well and a great HUG from trujillo- Perú.

@SimonSezIT 8 ай бұрын

Thanks for the kind comments 🙂 Learn Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

@Locomaid 10 ай бұрын

You have demystified so many things for me. Thank you!!!

@SimonSezIT 10 ай бұрын

Oh wow! That's nice of you to say that :-)

@domkboakyetv5972 10 ай бұрын

really enjoying the lesson. Thank you

@SimonSezIT 10 ай бұрын

You're very welcome!

@douglascristinelli4555 10 ай бұрын

Thanks God for simon sez It free titorial

@SimonSezIT 10 ай бұрын

That's very nice of you, thanks!

@makar55555 10 ай бұрын

Much appreciation for your efforts 🌹🌷💐

@SimonSezIT 10 ай бұрын

It's my pleasure - thanks for your feedback.

@claudemouaya5639 10 ай бұрын

From Congo thank you so much

@SimonSezIT 10 ай бұрын

Hello to you and everyone from the Congo :-)

@alexrosen8762 9 ай бұрын

Great tutorial 👌

@anniesuem 9 ай бұрын

Thank you Deb Ashby!

@SimonSezIT 9 ай бұрын

You are so welcome :-)

@marijanapesut6035 9 ай бұрын

Хвала!

@SimonSezIT 9 ай бұрын

Many thanks for the support :-)

@willlamers6929 8 ай бұрын

At timestamp 19:07 all of the cell references are relative. At timestamp 19:18, the reference to the lookup table in cell H11 has changed to A10:E17. The original formula in H4 should have been =VLOOKUP(B4&C4,$A$3:$E$11,4,0). The change makes the lookup table absolute, while the lookup cells stay relative.

@meevwhy3704 10 ай бұрын

Thank you!

@SimonSezIT 10 ай бұрын

You're welcome! Thanks for watching our training ;-)

@sv6956 9 ай бұрын

Hey, I have a question. What is the meaning of serial code in doing calculations while looking for duplicates if lookup value and lookup array is in the table itself

@KK-ch8yt 10 ай бұрын

Awesome....

@SimonSezIT 10 ай бұрын

Thanks 🤗

@bernabeespinoza6586 7 ай бұрын

mil gracias

@sanimunir 8 ай бұрын

Plz check the download file. I tried multiple times to download via my email, but failed. My email address is correct but it does not work.

@karinanurlankyzy114 9 ай бұрын

I dont understand why when you used the asterix to find HYNH product it showed light bulb and not shower seal? that one also has HYNH in its serial name.