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 आए
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.
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
