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
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 आए
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
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](http://i.ytimg.com/vi/gAY9is-ahQY/mqdefault.jpg)
![How To Apply VLOOKUP and XLOOKUP Formula on Large Data in Excel [Hindi] #excel](/img/tr.png)
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😢
Useful function. Thanks for sharing.
Watching you is always knowledgeable ❤👍. Please share the link of full video 🙏.
Full Video
ruclips.net/video/1CJ6JzbiCHQ/видео.html
🎉
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
Bahut badiya sir
Nice
good
amezing video
Thank you sir
Good
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😂😂
Very nice
thanks
You could have used the filter function too
Top function❤❤❤
Great
Amezing video
Jirdar.................
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
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
nice
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
table ka name next column me aye uske liye konsa function sir
Example pls
Use EXPAND function and put your table name into it.
kisi seet ko exl.seet me ro ko seeriyal par lagane ke liy kaya karenge
aare puchhna kya chahte ho? proper spelling likho
Kya hm ek hi sheet ke se add kr sakte hai apne mastersheet me
Yes
Aur product par percentage kaise laga kar nikale
=product*percentage/100
How to use it from different sheet
Simple select range from different sheet
Upload full video
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
Expiry date kaise nikale
Use edate function
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
gr8
Sir ye sab trik aati kha se hai🎉🎉❤
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
its not working in my excel sheet. what we do
Update your excel software
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
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
Jordaar
This formula is not appearing in my excel
Available in office 365 version
जब भी हम कोई 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 आए
All names are nepalese
I didn't got it. Can somebody help me with it?
This formula available in office 365 Software
❤
what is vstack please explain
This is formula of excel which will help to combined multiple table into one table
Not working in my MS excel
Which excel version you are using
sir vstack function 2021 me show nahi kar raha hain...
Office 365
Ka hai lg aur Sony nahi samaj me aya
System hai
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
Control+ shift+ semicolon is not for date
Sir mere me vstack ka formula show nahi kar raha hai = baad
Available in office 365
Not work in excel
Available in updated version of excel
App Name
Abhijeetji Technical 4m
Application Name Keyhai
@@kkm.brand2204 go to play store
And type abhijeetji technical 4m Yahi app ka name hai
2010 mai vstack nahi milta hai
Available in office 365
Sir vstack formula nahi aa raha
Available in office 365
😮
🎉
Nepali's video 😅
Mujhe to kuch smjh hi nhi aaya kahna kya chahte ho😢😢
Temi Nepali ho bro
No
Aap ka Excel mai toh sab Nepali ka naam hai
😂
Thanks
Hamare pas to Vstack ka formula aa hi nahi raha hai
Available in office 365
❤❤❤
Ya kon sa Excel ma he 2016 ma to nahi he
Available in office 365
AISA KOI FORMULA HI NAHI H
this formula available in office 365
Bhai sab 365 use nhi karte hai aur na MNC 365 purchase karti hai to kuch without 365 karo
Not working in my MS excel
Aap ka excel ka version kya hai
Ye function office 365 me work hoga
Ri detail diya kro aadhe de kuch samjh nhi aata plzz😢
You have to learn from basic that’s why not able to understand
pivot table lg dege aur easey ho jayega
Pivot not combined sheets
Vlookup formula k se Lagayette hai
Tqqqqqqq so much 👍👍
Nhi bhau
Where to write lg or sony.
In Name box
Sir in Google sheet it is possible?
Yea
I dont have vstack now what im going to do
Open office 365 in web which is totally free login there and use formula
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.
Very nice. Wat Excel version R U using for VSTACK ???
Office 365
@@AbhijeetjiTechnical4M Thanks Thanks
Office 13 ver me working nhi karega
No
I always watch your video
👌👌👌
Nice
Office version?
Yes office 365
@@AbhijeetjiTechnical4M 2021 don't have vstack function.
Very nice sir
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