Learning With MO

Пікірлер

@rwfrench66GenX 5 күн бұрын

Thanks for the video. Technically, you could’ve added the column next to Date in your Xlookup table, did one Xlookup formula and then hid the column you didn’t want the customers to see.

@haasjarib Ай бұрын

Thanks Buddy! It helped me a lot

@warrenanderson412 Ай бұрын

Well ladies..here is what you are looking for ..a tall young good looking black male who makes over $100K. This is that attitude make like this have. They are the table... not baby momma's out of shape with tons of makeup , weaves, drunk/ high, and cursing. And before anyone says anything.. I am in that category myself ( other than then being in my 30's).

@brendareed5050 Ай бұрын

Are there column rules to keep in mind when setting up the column?

@daveys Ай бұрын

I found Gnome boxes to be a pain. Moved to QEMU/VMM. Windows 10 works great on there and no issues since install. I also have a Linux VM.

@UltraZelda64 Ай бұрын

Safely within the confines of a virtual machine with no direct access to any of the hardware is the only common sense way to even consider running Windows.

@mojonespro Ай бұрын

Watch part 2. You will see that no drivers were needed. After install and account setup it ran well.

@galaktycznymlotchwaly2916 Ай бұрын

With Windows 10 the problems start from where the video ended. To make it even usable you have to install various drivers. Most of them barely work or work badly. It's much easier to use VirtualBox or VMware.

@muhammadasad729 2 ай бұрын

You should do ASMR or voice corn.

@shoppersdream 3 ай бұрын

Nice, thanks!

@usmaniqbal1836 6 ай бұрын

Sr, please also share data file for practice

@montebont 6 ай бұрын

Waste of time. This is yet another (I stopped counting at about 300) example of bad data structuring and a solution looking for a problem that should not exist in the first place. If you want to use Excel as a database I suggest you first learn how databases and normalization work...

@mojonespro 6 ай бұрын

Please clarify and or provide an efficient solution. The very nature of data is to be queried.

@hernandez5586 6 ай бұрын

Most company don’t use databases as they should and strictly use spreadsheets. You’re either a kid or an adult that’s never had a job in data.

@hernandez5586 6 ай бұрын

@@mojonesprokeep up the good work

@phandongexcel 6 ай бұрын

I like this video ❤❤❤

@viveksahu6824 7 ай бұрын

Nice video....I was using an older version of Excel and did the same thing using vlookup function.

@mojonespro 6 ай бұрын

Nice work!

@EvanSarris 7 ай бұрын

I’m curious as to why you went through the trouble of going to the FORMULA RIBBON, clicking on the INSERT FORMULA icon then typing in the XLOOKUP FORMULA when you could have just put the cursor into the cell where you want the formula and type =XLOO… which brings up your function choices with XLOOKUP coming up as the first choice. Then hit the tab key and your formula appears. This is not a put down but rather a sincere inquiry. Thanks

@mojonespro 7 ай бұрын

Good question. As an educator, I find it useful to utilize the function arguments dialog when teaching functions with multiple arguments. I don't want to assume that all of my students are accustomed to writing out the function in a cell. The function argument box provides more detail and guidance.

@meniporat3527 7 ай бұрын

Here's a trick to fetch all the values (even from non-adjacent columns) in one XLOOKUP statement. No need to bring the Date column in a separate statement: =XLOOKUP(H6,A6:A23,CHOOSECOLS(B6:F23,{1,2,3,5})) This formula will return data from the following columns: Name, Level, Price, Date

@mojonespro 7 ай бұрын

What Excel tool or feature would you like to see?

Ең жақсы KZbin

Пікірлер