Save 3 Hours Daily on Excel | Vstack Formula

Save 3 Hours Daily on Excel | Vstack Formula | Excel Tips & Tricks

Рет қаралды 774,626

Abhijeetji Technical 4M

Жыл бұрын

Save 3 Hours Daily on Excel | Vstack Formula | Excel Tips & Tricks

Пікірлер: 119

@nitishpradhan7375 10 ай бұрын

Fantastic 👌I m using it several times and I m happy

@greencrafteria9405 2 ай бұрын

Useful function. Thanks for sharing.

@aditya_ahir7084 Ай бұрын

Pahle mera dost bhi aadhe video hi upload karta thha fir usko hijde uthha le gaye ❤😊😮😢.

@gajubhaishah1926 22 күн бұрын

great,this I was searching since almost 30 yrs .I tried 20 program expert but unfortunately nobody could give me solution. This is solution I was looking for. Sir, l shall like to keep a touch of your presentations.Thank you.

@Arman-sp9rz 9 күн бұрын

😂😂

@gouranshprabhat4210 7 ай бұрын

Watching you is always knowledgeable ❤👍. Please share the link of full video 🙏.

@AbhijeetjiTechnical4M 7 ай бұрын

Full Video kzfaq.info/get/bejne/Z6l6aa2rx8-neIU.html

@vickybhojwani4562 2 ай бұрын

Sur its working, can u please guide more on this

@RA-kd3ne 5 ай бұрын

Bahut badiya sir

@saurabhkumar-fq5xv 5 ай бұрын

Thank you sir

@darshitchavda8264 11 ай бұрын

amezing video

@aroojgill9028 7 күн бұрын

Amazing..sir can u plz teach how to separate month or quarter wise data

@AbhijeetjiTechnical4M 6 күн бұрын

Insert new column just beside date and use text formula to extract month formula will be =text(a1,”mmm”) After that use filter formula in another sheet to filter month wise data If u want to learn everything in depth you can join our course in very affordable price where you will learn everything in depth also you will get chat and call support where you can solve your course and personal doubt App name - abhijeetji technical 4m

@sharemarketlearningvlog1893 Жыл бұрын

I always watch your video

@GuruBlogs1 6 ай бұрын

Thanks

@ranamajumder2368 Ай бұрын

Very nice

@myimaanofficial Ай бұрын

You could have used the filter function too

@sharemarketlearningvlog1893 Жыл бұрын

Very nice sir

@parsuramnaik500 Ай бұрын

thanks

@JITENDRAKUMAR-bm7ss 11 ай бұрын

Amezing video

@bijaytanty8434 10 ай бұрын

Great

@anadabanerjee7411 Ай бұрын

Top function❤❤❤

@akhileshsinghyadav4690 7 ай бұрын

Nice

@dhananjaypandit4879 2 ай бұрын

Upload full video

@rltewari Жыл бұрын

nice

@AnkitSingh-ud4ix 13 сағат бұрын

Sir ye sab trik aati kha se hai🎉🎉❤

@mehagha1021 Ай бұрын

Jordaar

@satender7625 4 күн бұрын

❤

@abcomputer6177 8 күн бұрын

❤❤❤

@mehagha1021 Ай бұрын

Jirdar.................

@deepakshrivastav-wl1rn 10 ай бұрын

Vlookup formula k se Lagayette hai

@jamesperry3837 Ай бұрын

Very nice. Wat Excel version R U using for VSTACK ???

@AbhijeetjiTechnical4M Ай бұрын

Office 365

@jamesperry3837 Ай бұрын

@@AbhijeetjiTechnical4M Thanks Thanks

@abroazhar 8 ай бұрын

gr8

@shubhambhatia9569 11 ай бұрын

amazing video

@nileshgiri2723 11 ай бұрын

Bakwas video hai Asha adhura jankari de raha hai Tera know she kuch kam ka nahi Tu computer ko hath. Bhi may lag teri aukad nahi

@meghananair3708 11 ай бұрын

👌👌👌

@All_About0 4 ай бұрын

Bhai sab 365 use nhi karte hai aur na MNC 365 purchase karti hai to kuch without 365 karo

@mafruharahman7759 9 ай бұрын

Not working in my MS excel

@RA-kd3ne 5 ай бұрын

Aap ka excel ka version kya hai Ye function office 365 me work hoga

@Jugalkishorkalita 5 күн бұрын

😮

@ghanshyamyadav8050 10 ай бұрын

🎉

@gauravgiri3670 5 ай бұрын

Kya hm ek hi sheet ke se add kr sakte hai apne mastersheet me

@AbhijeetjiTechnical4M 5 ай бұрын

Yes

@majidansari717 9 ай бұрын

Can we make it vise versa mastersheet to different tabs

@AbhijeetjiTechnical4M 9 ай бұрын

Example

@user-AkshayKharwar9058 8 ай бұрын

Yeah you can write the vise versa...but using advance filter and macro record...and view code

@ShubhamKumar-hy6ze Ай бұрын

pivot table lg dege aur easey ho jayega

@AbhijeetjiTechnical4M Ай бұрын

Pivot not combined sheets

@chiragprajapati4853 6 ай бұрын

Sir Excel me pura word small me type Kiya ho aur iska first font capital karne ke liye shortcut konsa hai??

@AbhijeetjiTechnical4M 6 ай бұрын

Use proper formula if u want to make shortcuts use macro with proper formula

@user-cd9dq2yv9k 6 ай бұрын

kisi seet ko exl.seet me ro ko seeriyal par lagane ke liy kaya karenge

@aarishqureshi5328 Ай бұрын

aare puchhna kya chahte ho? proper spelling likho

@rajeshdealer Жыл бұрын

Where to write lg or sony.

@AbhijeetjiTechnical4M Жыл бұрын

In Name box

@LIMITED_CALCULATION 7 ай бұрын

table ka name next column me aye uske liye konsa function sir

@AbhijeetjiTechnical4M 7 ай бұрын

Example pls

@myimaanofficial Ай бұрын

Use EXPAND function and put your table name into it.

@khusbusoni3800 Ай бұрын

Spreasheet me vstack formula nhi ho to kya use kre ?

@AbhijeetjiTechnical4M Ай бұрын

use power to combined multiple sheets data into one

@khusbusoni3800 Ай бұрын

@@AbhijeetjiTechnical4M could you pls elaborate same

@Shivansh20200 13 сағат бұрын

its not working in my excel sheet. what we do

@AbhijeetjiTechnical4M 12 сағат бұрын

Update your excel software

@sachinsuryavanshi2269 2 ай бұрын

Jinke pass office 365 nahi hai vo power quiry ka use kr dakte hain

@AbhijeetjiTechnical4M 2 ай бұрын

Yes tumhe power query ka addin install karna padega You tube per dher sari video hain how to install power query addin

@Radhasony4726khan 10 ай бұрын

Control+ shift+ semicolon is not for date

@darshitchavda8264 11 ай бұрын

sir vstack function 2021 me show nahi kar raha hain...

@AbhijeetjiTechnical4M 11 ай бұрын

Office 365

@Kanishka-xm8dx 3 ай бұрын

Nhi bhau

@aarishqureshi5328 Ай бұрын

what is vstack please explain

@AbhijeetjiTechnical4M Ай бұрын

This is formula of excel which will help to combined multiple table into one table

@KKLuha97 2 ай бұрын

Hamare pas to Vstack ka formula aa hi nahi raha hai

@AbhijeetjiTechnical4M 2 ай бұрын

Available in office 365

@nikhilshahu830 2 ай бұрын

Text me Extra space ko kai se remove kre

@AbhijeetjiTechnical4M 2 ай бұрын

Use trim formula

@nikhilshahu830 2 ай бұрын

@@AbhijeetjiTechnical4M =TRIM() Formula use ki hai nhi ho rha hai bakwash formula hai

@Satyajeet_Sahu 3 ай бұрын

Sir mere me vstack ka formula show nahi kar raha hai = baad

@AbhijeetjiTechnical4M 3 ай бұрын

Available in office 365

@ananyagupta3772 4 ай бұрын

Not work in excel

@AbhijeetjiTechnical4M 4 ай бұрын

Available in updated version of excel

@Osunny1234 9 ай бұрын

Office version?

@AbhijeetjiTechnical4M 9 ай бұрын

Yes office 365

@Osunny1234 9 ай бұрын

@@AbhijeetjiTechnical4M 2021 don't have vstack function.

@richidollarr4578 5 ай бұрын

Can i know the link for full video please And can you please make a video on this below situation How to calculate total grams or kg sold from multiple sheets by end of the year The master sheet should automatically count total kg or grams sold , of different products Thank you i am trying to look for this answer since long time but could not find no where , i just like the way you explain in details

@AbhijeetjiTechnical4M 5 ай бұрын

Do one thing insert new column in every sheet just beside your product and mentioned unit as hardcore text (like kg ,grms) and use Sumifs formula Still facing issue and if u want personal assistance trough any desk or google meet join our course In this course you can solve personal doubt course doubt for lifetime If intrested download my app from play store App name -abhijeetji technical 4m Course name -Basic to Advance Excel with Array Mastery

@richidollarr4578 5 ай бұрын

@@AbhijeetjiTechnical4M I live in Russia , there are alot of sanctions these days , I am not sure if (anydesk) will be working , but still I will try to download from somewhere . Regarding app , yh I will download it now Thank you

@AbhijeetjiTechnical4M 5 ай бұрын

@@richidollarr4578 download app and message there through chat

@AJAY7509 7 ай бұрын

I dont have vstack now what im going to do

@AbhijeetjiTechnical4M 7 ай бұрын

Open office 365 in web which is totally free login there and use formula

@mdrashidhussain7168 10 ай бұрын

Office 13 ver me working nhi karega

@AbhijeetjiTechnical4M 10 ай бұрын

@yaduverma 5 ай бұрын

2010 mai vstack nahi milta hai

@AbhijeetjiTechnical4M 5 ай бұрын

Available in office 365

@LOFICREATION1998 5 ай бұрын

Sir vstack formula nahi aa raha

@AbhijeetjiTechnical4M 5 ай бұрын

Available in office 365

@user-hq5su3kv6g 4 ай бұрын

Ri detail diya kro aadhe de kuch samjh nhi aata plzz😢

@AbhijeetjiTechnical4M 4 ай бұрын

You have to learn from basic that’s why not able to understand

@kkm.brand2204 Ай бұрын

App Name

@AbhijeetjiTechnical4M Ай бұрын

Abhijeetji Technical 4m

@kkm.brand2204 Ай бұрын

Application Name Keyhai

@AbhijeetjiTechnical4M Ай бұрын

@@kkm.brand2204 go to play store And type abhijeetji technical 4m Yahi app ka name hai

@poipatvillage8506 10 ай бұрын

After Getting data in master sheet, how you will find which one belong to LG and Which one belong to Sony 😂

@AbhijeetjiTechnical4M 10 ай бұрын

In each sheets should be added one xtra column which name is remarks column and product name Here I am showing that how to deal in that situation I think you are beginner

@poipatvillage8506 10 ай бұрын

@@AbhijeetjiTechnical4M I'm not beginner, my concern is that, after seen your video beginner Wii be confused and I'm doing same thing using Power Query.