Відео

Fils download nhi hi rha h

Video Re-uploaded Friends 👍

Dear Friends video mein kuch technical problem ho gayi hai, I will re-upload this video soon

Amazing

Red में highlight कैसे होता है

Vba course ek series wise upload kijiye please

Very useful 👍How to do the same from different workbook

sir alt+down arrow se data validation list kaise banayee. please explain me. unique value kisi list kaise banaye.

Tiino cell colour nahii ho rahe hai.. Aeisa ku sir

Sir mene bht acche se bar bar check kar liya.. Conditional formatting sirf ek hii cell par apply ho raha hai.. Jo selection me rakh raha hu uska upar wala cell color ho raha hai

How vlook is used to produce mark sheet of students, which choose six subject out of 10 Such as out of language Marathi Hindi and Sanskrit some students take Marathi while some take Hindi and remaining text Sanskrit

Char(10) is new for me. Thanks a ton.

Super

Sir ek baat bataiye apne jo sumproduct se question kara tha.. Star laga kar.. Usko double negative se kar raha hu to.. #value ye error aa raha hai.. Ku aeisa ku sir

great boss

Samjha nahi paa rahe ho

Are Han sir... Me bhool gaya tha... Sumproduct se nahii hoga.. Ku k sumproduct intersection se value thodi lakar deta hai.. Kya mene sahii bola sir?

Sir ye question sumproduct se ho sakta hai na?...

Very Very Helpfull video sir 😃

😂😂😂😂

Sir please share your mobile number

Amazing Tricks 👏👏

Thank you sir ji 🙏🙏

amazing explain

Sir mera macro jaha mene ye shortcut banaya hai vahi show kr raha hai me aesa chahta hu ki jiska me button click kru to vo mujhe direct uski sheet pr le jaye

Better and efficient way to nest Match function or xmatch

Wonderful 👏🏻

EXCELLENT

Sir, I have a question ⁉️ One of the condition for SUMPRODUCT to function properly is, that the arrays selected within it should be of compatible dimensions i.e. all the arrays selected within it should have equal no. of rows and columns, else it would show error. However, in the 2nd last example, where you showed its use for 2-way lookup, the arrays selected were not having equal no. of rows and columns e.g. the name column had 13 rows and one column but the month row had one row and 12 columns. Still it worked properly. How was it possible?😮 Please reply ASAP 🙏🙏🙏🙏

Sir ....I think we can find out with vlookup + match function also?

Easy presentation ❤🎉 Thanks a lot.

Maja aa gya sir supper

Sir, very nice. Sir, जैसे सीरियल नंबर अपडेट हो रहा है उसी तरह टेबिल भी अपडेट हो एसा अगला वीडियो बनाए।

Sir, your video's very nice. But zoom, low hone se formula saaf nhi dikhta hai. Thanks

Sir, very nice. Button ko lock karna bhi batane ka kasht kare.

Sir, very nice. Next make video single sheet to multiple sheets.thanks

Really, mind blowing sir

Sir mera ek sawaal or hai.. Practice file jo discription me dete ho.. Usko excel sheet me kese lekar aye.. Ek video bana dijiye is par bhii plzzzz

Finally ab 3 din baad.. Ab jake clear hua hai.. Me bht confuse tha bht video dekh lii.. Lekin kisi video me point nahii samjha me... Jo apne is video me bata diya.. Star or double negetive ko lekar.. Ab clear ho gaya.. K agar hum star use kar rahe hai.. To double negetive na lagao.. Or jab double negetive use kar rahe hi to range ko koma me rakhna hoga.. Kya mene sahi kaha sir

Amazing tips, thanks for this video Shivam. I want your help in Vlookup in case of mergerd cells, suppose my data is in one sheet in normal form and in the other sheet where lookup value is in merged cells and in the second sheet data might be in non uniform way like in col A first 4 cells are merget but next lookup value in 2 merged cells and so on. Please make a video on this.

Hi Shivam, I regularly watch your videos and really like your detailed explanations. I have a query: suppose in one sheet, I have data with merged cells, and in the second sheet, the data is in normal form (without merged cells). When I apply VLOOKUP in sheet 1 using data from sheet 2, it doesn't work. Could you please make a video to solve this? One more thing, in sheet 1, the data might not be merged uniformly; for example, in column A, cells 1-3 are merged, then cells 4-8 are merged, and then only 2 cells are merged. Thanks

शानदार, अति उत्तम

Acha tha video

Are you not showing everything please

Without helper column finding duplicate value with vlookup ua-cam.com/video/J7UQxZ3CpyA/v-deo.html

Last video blur araha h

zabardast sir g, mera excell version bi purana tha is liye merge nhi hota tha. apny ab bohat khoubsurat samjha diya. thank you sir

Great work bro...first video mili h jisne clear kiya hai

VERY INFORMATIVE VIDEO SIR ❤❤

Beautiful sir g isi vedio ka wait tha jo apny sikha dia. thanks a lot Sir.