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.
I would be very greatful if you give me a solution to count meals separately Breakfast, lunch, diner from one date to another for example Check in date 05-09-2024 LUNCH & Check out date 09-09-2024 DINER Formula should count meals like a person had 4nos breakfast (e.g. 6B,7B,8B,9B), 4nos Lunches & 5nos Diners Only meals count required
@@AbhijeetjiTechnical4M जैसे मैं date लिखता हू 1 may fir iske niche 2 may, fir in दोनों को select करके mouse se नीचे तक drag कर deta हू मान लो मैंने 10 tarikh तक drag kar diya ( 1 se 10 tarikh tak date dal gai) Ab isi line me mujhe kahi bhi bich me date change karni h मान लो जहां 4 may ki date likhi hui thi वहाँ 6 likh du, to automatic 6 jan बन jayega, jabki मैं चाहता हूं कि 6 likhte hi 6 jan ki जगह 6may आए
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
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
@@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.
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
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
@@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
Fantastic 👌I m using it several times and I m happy
what job do you do , currently
@@India-RAAJ-ki-shaan give me your insta bro i have some query about job😢
Pahle mera dost bhi aadhe video hi upload karta thha fir usko hijde uthha le gaye ❤😊😮😢.
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.
😂😂
😂😂😂😂😂tooo funny story
Tumko akela dekh mandli mein unko accha nhi laga tbhi tumhare dost ko bhi uttha laaye taaki dono dost khushi khushi acche se taaliya peeto😂😂
table ka name next column me aye uske liye konsa function sir
Example pls
Use EXPAND function and put your table name into it.
Kaunsa version me hai ye Vstack function
Office 365
@@AbhijeetjiTechnical4M kya office 365 free me install and activation kar sakte hai
@@abhijitdey1819 no paid version hai
Nice
I would be very greatful if you give me a solution to count meals separately Breakfast, lunch, diner from one date to another
for example
Check in date
05-09-2024 LUNCH &
Check out date 09-09-2024 DINER
Formula should count meals like a person had 4nos breakfast (e.g. 6B,7B,8B,9B), 4nos Lunches & 5nos Diners
Only meals count required
After join our courses you can solve your course and personal doubt and this access will be lifetime
App name - abhijeetji technical 4m
good
Good
Very nice
Jinke pass office 365 nahi hai vo power quiry ka use kr dakte hain
Yes tumhe power query ka addin install karna padega
You tube per dher sari video hain how to install power query addin
Upload full video
its not working in my excel sheet. what we do
Update your excel software
sir vstack function 2021 me show nahi kar raha hain...
Office 365
Top function❤❤❤
I didn't got it. Can somebody help me with it?
This formula available in office 365 Software
Not working in my MS excel
Which excel version you are using
Text me Extra space ko kai se remove kre
Use trim formula
@@AbhijeetjiTechnical4M =TRIM() Formula use ki hai nhi ho rha hai bakwash formula hai
Date waise kyu aai, exactly copy kyu nhi hui?
You are doing mistake watch carefully
Jirdar.................
जब भी हम कोई date डालते हैं तो jan ही क्यों आता है कोई और month क्यों नहीं आता ❓❓
Jaise example
@@AbhijeetjiTechnical4M जैसे मैं date लिखता हू 1 may fir iske niche 2 may, fir in दोनों को select करके mouse se नीचे तक drag कर deta हू मान लो मैंने 10 tarikh तक drag kar diya ( 1 se 10 tarikh tak date dal gai)
Ab isi line me mujhe kahi bhi bich me date change karni h मान लो जहां 4 may ki date likhi hui thi वहाँ 6 likh du, to automatic 6 jan बन jayega, jabki मैं चाहता हूं कि 6 likhte hi 6 jan ki जगह 6may आए
Ka hai lg aur Sony nahi samaj me aya
System hai
Sir vstack formula nahi aa raha
Available in office 365
Not work in excel
Available in updated version of excel
🎉
Temi Nepali ho bro
No
Aap ka Excel mai toh sab Nepali ka naam hai
Watching you is always knowledgeable ❤👍. Please share the link of full video 🙏.
Full Video
th-cam.com/video/1CJ6JzbiCHQ/w-d-xo.html
🎉
Useful function. Thanks for sharing.
Sur its working, can u please guide more on this
Amazing..sir can u plz teach how to separate month or quarter wise data
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
This formula is not appearing in my excel
Available in office 365 version
Not working in my MS excel
Aap ka excel ka version kya hai
Ye function office 365 me work hoga
Nepali's video 😅
All names are nepalese
Ya kon sa Excel ma he 2016 ma to nahi he
Available in office 365
sir mera 2021 version hai but mere isme ye formula nhi aa rha hai ab kya karu
Office 365 mein hai ye formula but you can practice on google sheet which is totally free
Bahut badiya sir
Aur product par percentage kaise laga kar nikale
=product*percentage/100
amezing video
Hamare pas to Vstack ka formula aa hi nahi raha hai
Available in office 365
Bhai sab 365 use nhi karte hai aur na MNC 365 purchase karti hai to kuch without 365 karo
what is vstack please explain
This is formula of excel which will help to combined multiple table into one table
Expiry date kaise nikale
Use edate function
AISA KOI FORMULA HI NAHI H
this formula available in office 365
Nahi ho raha hai
You are doing some mistake watch carefully
Vstack formula available in office 365 excel version
App Name
Abhijeetji Technical 4m
Application Name Keyhai
@@kkm.brand2204 go to play store
And type abhijeetji technical 4m Yahi app ka name hai
Mujhe to kuch smjh hi nhi aaya kahna kya chahte ho😢😢
You could have used the filter function too
Tqqqqqqq so much 👍👍
Where to write lg or sony.
In Name box
Sir ye sab trik aati kha se hai🎉🎉❤
Control+ shift+ semicolon is not for date
Thank you sir
Nhi bhau
😮
😂
Vlookup formula k se Lagayette hai
❤
❤❤❤
2010 mai vstack nahi milta hai
Available in office 365
Jordaar
Sir Excel me pura word small me type Kiya ho aur iska first font capital karne ke liye shortcut konsa hai??
Use proper formula if u want to make shortcuts use macro with proper formula
Sir mere me vstack ka formula show nahi kar raha hai = baad
Available in office 365
Ri detail diya kro aadhe de kuch samjh nhi aata plzz😢
You have to learn from basic that’s why not able to understand
thanks
Sir in Google sheet it is possible?
Yea
gr8
pivot table lg dege aur easey ho jayega
Pivot not combined sheets
After Getting data in master sheet, how you will find which one belong to LG and Which one belong to Sony 😂
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
@@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.
How to use it from different sheet
Simple select range from different sheet
I dont have vstack now what im going to do
Open office 365 in web which is totally free login there and use formula
Very nice. Wat Excel version R U using for VSTACK ???
Office 365
@@AbhijeetjiTechnical4M Thanks Thanks
kisi seet ko exl.seet me ro ko seeriyal par lagane ke liy kaya karenge
aare puchhna kya chahte ho? proper spelling likho
I always watch your video
Spreasheet me vstack formula nhi ho to kya use kre ?
use power to combined multiple sheets data into one
@@AbhijeetjiTechnical4M could you pls elaborate same
Thanks
Kya hm ek hi sheet ke se add kr sakte hai apne mastersheet me
Yes
Office 13 ver me working nhi karega
No
Nice
Can we make it vise versa mastersheet to different tabs
Example
Yeah you can write the vise versa...but using advance filter and macro record...and view code
Very nice sir
Great
👌👌👌
nice
Office version?
Yes office 365
@@AbhijeetjiTechnical4M 2021 don't have vstack function.
Amezing video
amazing video
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
Ye function office 2019 mai hai...??
Office 365
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
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
@@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
@@richidollarr4578 download app and message there through chat
Bhai video pura upload Kiya karo nahi to kuch bhi mat karo
Full video already available on my channel
Visit and watch v Stack formula