วีดีโอ

Thank you very much

Thank you

Most welcome!

Most welcome

Thank you so much 😀

Thank you

Thank you

Thank you for your suggestion but table works only if you enter data manually. If you paste data at the end of the table from somewhere else the it will not convert into table, you have to rearrange the same but formula will work in all conditions.

@@ExcellenceInExcel there are many ways which can be utilised to reduce the manual effort of appending data manually. One such could be using Filter

Other that i can think of could be power query

There could be many more depending upon the use case.

Please try step by step

Thank you

Hi formula will be same, you just need to select range column wise.

Thank you, due to some personal reasons videos nhi bna paa rha tha,

Kisi cell me name ka Dropdown bnao or formulae me usi celll ko select kr lo

Thank you

Thanks

Thank you so much 😀

Thank you

All the best

Yes but Sumtimes the interviewer ask to do the same with countif formula

i just expressed my experience.

Thanks 😊

Check my channel, I Have already made a video, sumifs between two dates

Use sumproduct formula

2 months ka data bhi le skte ho aap, index Match me kaise bhi data le skte h

same formula mein dusre month ke liye kya formula pass karna padega agar 2 se jyada ka data lena hai to..

Hi, file link has been shared in video discription

You're most welcome

Thank you

Thank you

Thanks

Thank You for your feedback, will try to explain in more simple manner in my next video

@@ExcellenceInExcel I liked your reply bro.. waiting for your more videos about ms office and more early..

Thank you

You can use offset formula to get last 3rd value

​@@ExcellenceInExcelLast 3 non black cell value with date show Excel formula

Thank you

Thank You

Thanks

Yes you can use same formula for that

for that you have to take range in index formula from may to nov, rest formula will remain the same

Good 👍

Thanks

thanks

Hi, file link has been shared in description

Thanks

Thanks for this solution 👌

Hi please share excel file

copy the entire data, paste it in Notepad and save the file in default format '.txt'. Now, open excel, click on file and open the same '.txt' file by selecting file type to "All" or "Text (tab delimated)" in browsing window. Now, just click on "NEXT" option multiple times and you are done with data separation into separate column.

Ha but wo automate nhi hoga, jb new data aayega to fir se text to column krna pdega

Most welcome 😊

Thank you

Please share your question in excel file

Yes watch my sumif formula video

Setting me ja k video quality 1080p kro

Ye Advanced Excel Videos hai, pehle aap basic excel sikho uske baad samajh me aayengi.

agar column lock nhi krenge to answer wrong aayega, formula drag krne k liye column lock krna jaruri hota h

Formula provide kar dijiye please bro

=INDEX($E$2:$G$20,MATCH($J5&$K5&$L5,$C$2:$C$20&$B$2:$B$20&$D$2:$D$20,0),MATCH(M$4,$E$1:$G$1,0))

V lookup ma 2nd value kesy find hoti ha please

Helper column add krke unique id banana pdegi aapko