Subscribe for more videos !!

I changed it a bit to adjust to my query but worked perfectly nice job.

Great Video, you have helped me solved what seemed to be impossible at first

@myexcelacademy69

Жыл бұрын

Glad I could help!

Life saver dude.. Thanks a lot

I've been looking for this solution! Thank You!

@myexcelacademy69

5 ай бұрын

Glad I could help😊

Thx for the tutorial.

Thank you for this help... How did you added drop down function at 06:05

Nice brother

How do we use ROW if the table is on another sheet?

Very useful! Thank you

@myexcelacademy69

Жыл бұрын

Glad to hear that!

Thanks sir, understood-shivsharan

jazakaallah

Hello sir. It was an excellent video. I have one doubt. What if I need vloopup on two separate sheet? I mean I need vlookup three values to an another sheet which has same values. The data is almost 70000 entries. Thanks!

@myexcelacademy69

7 ай бұрын

I will try to make a video on that

excellent, thank you so much

Short list ki beena bhi is formula nhi lg skta hai kyaa

Thenks Sir

@myexcelacademy69

3 жыл бұрын

Welcome dear

Thank you very much sir.You really helped me but unfortunately I still have a small problem . ,Why you wrote () row minus 1 ? you also higlithed "row' clicked F9. ,Ii couldn't see how it returned to row..... hank you very much

@myexcelacademy69

2 жыл бұрын

Hi Charles, we use row () to get us the row number, and since the formula is in Row 2 , when using the row function it will give us 2 , but we need 1 for the first Vlookup entry, so we minus 1 to get 1. Hope this is clear. Enjoy...Join my course on Udemy to learn more Advanced stuff..

@Lilymarie-mn8sd

8 ай бұрын

@@myexcelacademy69 hello sir, please can you explain on this why you minus 1 when the row you've used is in row 3?

How pick at put down

Wow

Hy i have a question

Super

Without drop down list ke formula kese aply kre

It was very informative but i need to know how can i get all the sales value of chris summed up in 1 row?

@myexcelacademy69

7 ай бұрын

Just add one row on top and use the SUM function

Can you teach online excel formulas please

@myexcelacademy69

11 ай бұрын

www.udemy.com/course/mba-in-excel-master-business-analytics-in-excel/?couponCode=85D50BE60F145DFBFB12

How to skip to next column when sales column value contain 0

@alikodur1439

3 жыл бұрын

I mean Chris 10, Chris 0, Chris 30, then i want to get result as - Chris 10, 30, etc

filter function can easily do same thing

@myexcelacademy69

3 ай бұрын

Yes, but not everybody has office 365

First