a.a nice video sir you have not shared the practice sheet here and also not explained month cell formate that as you said it would be shown at the end please share asap
AoA, very nice video indeed. many thanks. agar sales ki amount k sath sath item bhi list ma ho to formula kese lagay ga. for example i want to know ahmed na agar iphone 6 march ma sale kia ha aur tariq an bhi march ma iphone 6 sale kia ha. to how will i know separate sales of each salesman within specific date range?
Sir 1 sheet me different company ka different date wise data hai, us sheet me se hr company ka alg alg date wise data kese nikalen gy? Example : company ka nam hai "abc" 22 march ko uski 10 dfa sale hoti hai aur 23 march ko 15 dfa isi tra poora month sale hoti hai, hmny date wise sum krna hai sirf abc company ka
To bhaai aap usme ek or criteria daal sakte ho criteria range me companies ka column and fir criteria me "ABC Company" aese daaldena aapka ABC ki sales nikalke ajayegi
Sir...agar ye hi cheej ham date wise nikale to kese lagega formula... actually mere pass ek data hai jo ek sheet se dusre sheet me output lana hai..and jo output hai wo tailorwise and date wise hai...muje per day ka tailorwise output lana hai ek sheet se dusre sheet me..... please suggest me...kese ho payega ye
@@shahabislam4912 Ek worksheet me already koi data filled hai...jo ki mere according nahi...i mean jesa me chahta hu wesa nahi hai...ab muje use firse change karna hai and ek se jyada worksheets me data hai...and sare data ki rows and columns bhi har ek worksheet me alag alag position par hai...muje sare data ko firse ek alag sheet par ya usi ke niche tayar karna hai...bht time lag raha hai firse ready karne me....bht sari worksheets hai so... koi esa formula ya video jo meri help kar sake ? please
Very informative video bhai
Alhamdulillah
gzzzzzbbbbb h bhai knowledge aapki
nice video shahab...thk you
Bhai dil khush kar dia😂bc maja agya thanks a lot bhai... Pani tusi cha gaye
thanks a lot ...
I extremely looking this formula. Many thanks.
Exllent
I was able to follow along, even as an English speaker.. TYTY
Nice video sir
a.a
nice video
sir you have not shared the practice sheet here and also not explained month cell formate that as you said it would be shown at the end
please share asap
Awesome explanations sir i have a one doubt aap jo freez kr rhe hai vo key kaise press krni h mtlb... Kitni dafa
1 time f4 se row and column dono freez or 2 dafa f4 se row freez oe 3 dafa f4 se column freeze
Thank you so much sir
Nice
Aapne date change karne ka format nhi bataya sir
where is excel for practice? Please send here link.
❤❤❤
Good
FILE NAHI HEY DESCRIPTION ME SIR
mere pas multiple years hain to main jan ki jaga jan-2020 likhu ? ya phir kia likhu ?
AoA, very nice video indeed. many thanks. agar sales ki amount k sath sath item bhi list ma ho to formula kese lagay ga. for example i want to know ahmed na agar iphone 6 march ma sale kia ha aur tariq an bhi march ma iphone 6 sale kia ha. to how will i know separate sales of each salesman within specific date range?
Although you did it well... But you haven't explained the 3rd criteria well
Different sheet me kaice formula use karuo
Sir there is no file download link found.
2:53 2:56 2:58
Sir 1 sheet me different company ka different date wise data hai, us sheet me se hr company ka alg alg date wise data kese nikalen gy? Example : company ka nam hai "abc" 22 march ko uski 10 dfa sale hoti hai aur 23 march ko 15 dfa isi tra poora month sale hoti hai, hmny date wise sum krna hai sirf abc company ka
To bhaai aap usme ek or criteria daal sakte ho criteria range me companies ka column and fir criteria me "ABC Company" aese daaldena aapka ABC ki sales nikalke ajayegi
Mere me ye formula nhi work kr rha 0 de rha
Very good but formula not applicable on all table why
Check cell freezing
You tried to copy the original RUclips channel step by step but your explanation was too confusing
Sir...agar ye hi cheej ham date wise nikale to kese lagega formula... actually mere pass ek data hai jo ek sheet se dusre sheet me output lana hai..and jo output hai wo tailorwise and date wise hai...muje per day ka tailorwise output lana hai ek sheet se dusre sheet me.....
please suggest me...kese ho payega ye
ruclips.net/video/6priRmCF5-0/видео.html
@@shahabislam4912 Thank you!
@@shahabislam4912 Ek worksheet me already koi data filled hai...jo ki mere according nahi...i mean jesa me chahta hu wesa nahi hai...ab muje use firse change karna hai and ek se jyada worksheets me data hai...and sare data ki rows and columns bhi har ek worksheet me alag alag position par hai...muje sare data ko firse ek alag sheet par ya usi ke niche tayar karna hai...bht time lag raha hai firse ready karne me....bht sari worksheets hai so...
koi esa formula ya video jo meri help kar sake ?
please
500000 monthly sales. Give the excel formula to convert this amount into 30 days. Do not repeat the amount