@innozent Please Explain this Formula (formula used to count value of filtered Data) =SUMPRODUCT(SUBTOTAL(3,OFFSET(AD5:AD2563,ROW(AD5:AD2563)-MIN(ROW(AD5:AD2563)),,1,)),N(AD5:AD2563>0))
Sir I have a question I have a data of employees which has various departments like HRM, ITS. LD3, SNTI I want To find minimum salary of ITS departments with the help of SUMPRODUCT I was trying but no working Because I want min but when I quese -- false statement convert into zero and I return 0
Excuse me sir i understand this video 🎉 i am very confuse this practical in Excel Data . How to sort mixed one column Personal name & company name list. i want to separate another column transfer company name list only sir. i am requesting sir please make on video
سر آپ کا چینل سپر ڈپر ہے مجھے ایکسل پر ایک پرابلم ہے ڈیٹا بھت ذ یا دہ ہوتا ہے ایک ایک انوائس میں 8 اور کبھی 9 آئٹم ہو تے ہیں اس میں جی ایس ٹی بھی ہو تا ہے ڈیٹا سیپ کا ہوتا ہے ہر آئٹم پر انوائس نمبر لکھنا ہو تا ہے ایسا کچھ بتائیں کی آٹو میٹک نیکسٹ لا ئن پر انوائس نمبر ا جا ئے
Sir if you are seeing my comment so I wanna tell you tha Microsoft mein new formula aaye h I think you know that so sir please make a video on this topic ❤
Ram ram sir ... aapke videos dekh ke maine excel sikhi aaj mujhe data analyst post k liye selection ho gya hai sir bhut bhut dhanyawaad
Congratulations.Have a wonderful career ahead
Hlo bro, kya apply karte waqt certificate dena mendatory hota h kya?
Very nice shortcut of excel thank you sir aapka bahutdinbad Excel ka video dekha
great video sir
really informative video sir. Thanks sir
Sir, you are looking so good with this jacket.
😊thanks
@innozent Please Explain this Formula (formula used to count value of filtered Data) =SUMPRODUCT(SUBTOTAL(3,OFFSET(AD5:AD2563,ROW(AD5:AD2563)-MIN(ROW(AD5:AD2563)),,1,)),N(AD5:AD2563>0))
Sir, make videos on stock related which can automatically update data
Bahut hi badhiya
sir excel Ke upper ek pura video Baniya naa hame Bohot Madad Hoga
🎉today get something new thanks
Namaste bhaiya....
Tally ka playlists laiye....
Plz....
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤
🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤
Value added content 🎉😊
Sir, tell me how to join your class please
Sir I have a question
I have a data of employees which has various departments like HRM, ITS. LD3, SNTI
I want To find minimum salary of ITS departments with the help of SUMPRODUCT
I was trying but no working
Because I want min but when I quese -- false statement convert into zero and I return 0
Sir
Fill ke liye Alt H F I S से बेहतर Alt E I S try करता हु मै ... एक key कम use होती है 😊
Nice video ❤❤
Excuse me sir i understand this video 🎉 i am very confuse this practical in Excel Data . How to sort mixed one column Personal name & company name list. i want to separate another column transfer company name list only sir. i am requesting sir please make on video
Series best shortcut key Alt + Eis
Sir ek column Mai 10 likha Hai or uske sath 2nd columns mai 10, 20,30,10,
Asse Hai agr mujko bus Isme se 10 delete Karna Hai to kase karegye
Value added kar raha hu
❤
🙏
Makearray ka use batao
Sure
Sir video se acha learn karte but apki video constantly upload nahi hota hai
Will make videos on regular basis
Great sir
سر آپ کا چینل سپر ڈپر ہے مجھے ایکسل پر ایک پرابلم ہے ڈیٹا بھت ذ یا دہ ہوتا ہے ایک ایک انوائس میں 8 اور کبھی 9 آئٹم ہو تے ہیں اس میں جی ایس ٹی بھی ہو تا ہے ڈیٹا سیپ کا ہوتا ہے ہر آئٹم پر انوائس نمبر لکھنا ہو تا ہے ایسا کچھ بتائیں کی آٹو میٹک نیکسٹ لا ئن پر انوائس نمبر ا جا ئے
Sir if you are seeing my comment so I wanna tell you tha Microsoft mein new formula aaye h I think you know that so sir please make a video on this topic ❤
Yes .will update videos soon
Sir mein first hu 😊
❤