Комментарии:
Very good my friend.
ОтветитьExquisitely taught sir ji..superb❤
ОтветитьGreat job sir very useful information 👍
ОтветитьHow to do distinct count with count if s I. E multiple criteria and get distinct count using count ifs please explain
ОтветитьVery useful & informative video 👍
ОтветитьCountif lgakr text and number ek sath utha sakte???
ОтветитьSir मेरे पास एक एक्सेल की वर्क शीट्स में काफी शीट है लेकिन दूसरी शीट की range se countif function se value 0 bata raha hai iska kya soluation ya कोई दूसरा फंक्शन use कर सकते है
= Countif(' sheet1'!a1: a40,"सब्जी")
To value 0 aa raha hai
जबकी orignal me 12 baar hai।
"<>*" yeh NOT TEXT aise COUNTIF se karne par agar koyi BLANK CELL rehga wo bhi count mein aa jayega... Isliye cells with number dhoondne ke liye COUNT lagana behtar hoga
Ответитьsir app suru se excel shikhna ha uska link provided kar do please
Ответитьbahuttt badhya concept tha sir
ОтветитьSir mera ek sawal hein
Mujhe Saturday and Sunday count karna hein par, condition e hien ki, hamare pass sirf Star date hein , end date nahiiiii, par dono ka count ek sath karna hein
Aap madat kar sakte hein
Sir mere pass ak data hei. O data mei bohot company ka details hei.mujhe use ak company mei kitne log kam korte hein , unka salary nikalna hei to keise konu without search filter ak formula botaiye. Please 🙏🏻
ОтветитьBhai mujhe ek range m jitne unique h unka count chahiye unke samne
ОтветитьI have a question pls
ОтветитьHe only knows how to bring results. Don't know how to explain in detail. He's trying to be over smart.
ОтветитьHow to freeze I can't understand
ОтветитьWith you I feel I understand Hindi also 🙏
ОтветитьHi sir, less than and equal to , what criteria will i use?
Less than 4 and equal to?
Hi sir, i have one question why did you not use * after real madrid sample?
As you use for “the”,”s” etc.
अगर 10 बाय 30 सेल में टाइम लिखा है तो उन सभी सेल्स मैं एक साथ 10 मिनट कैसे ऐड करें एक्सएल 16
ОтветитьHi sir apka Excel ka class lete hai kya apka location konsa hai
ОтветитьI decided that i bring complete transformation in my life through more studies, practice n will keep on practicing more advance excel n technical knowledge.
It's promise to me.
Great Rajiv Jee, i appreciate ur teaching.
Thanks.
big thank you, i was really looking for this same formula, finally this video helped me. please share your contact number.
ОтветитьWow Sir ji * is for text and nontext is <> .. thanks
ОтветитьWow Sir ji, Count A se Count ko minus karna maine kabhi socha hi nahi.. dhire dhire acha se samhe aara ha hai . Thanks a lot
ОтветитьSir how to count no of cell where time is present!!!! Such as 7:30am, 8:40pm!!!!
ОтветитьAmaizing sir, salute you.
ОтветитьHello Sir,
How can be update occurance in access similar you have explained in excel like 1, 2, 3
Ok if I have the dates from 1st to 30th October but here I want the latest call unique without duplicate with the help of countif formula
ОтветитьHi sir please clear this issue once.. for example if I'm calling my friend multiple times in a month or in a day for this I just want the unique for my latest call if day and time is also not there I want only unique with the help of countif formula without duplicate
ОтветитьTHIS MAN DESERVES MORE SUBSRCIBER
ОтветитьÀ
ОтветитьVery nice sir 👌
My problems solved, thanks sir
Sir, I have more than five words in cell I need to find out two words of the cell by countif formula does it possible
ОтветитьMuje dashboard ek sheet pe amend ho aur dosre sheet par update ho thanks sir
ОтветитьThanks sir, aap ka Tarika bahut behatar hai
ОтветитьNice explanation Sir..Thanks for the helpful video 🙏🙏🙏
ОтветитьGreat job it helps me alot
Ответитьnice vedio . but sir please give the saprate excel link for download purpose
Ответитьsir.... Conditional formating se duplicate value high light hogi.. count to fir karna padega sir..
ОтветитьHow to use countifs in countifs & sumifs in one Excel sheet to another Excel sheet
ОтветитьDear Sir, we want occurrence based on category
Ответитьhow to select the range if the cells are not in sequence
ОтветитьHow to count the cells from a range of where the cells having more than (for example) 6 digits in one cell....pls help
Ответитьevery time i need help related to excel i just come here and every time i get solution thank you sir
ОтветитьSir ya btna ki count kro kitna bacha k name ka 2nd letter A h is ka kya formula bnga sir btna please
ОтветитьSir agar kisi list me koi naam repeated hai aur hame pata karna hai wo naam koun koun se row number me hai to formulae kya lagega
ОтветитьSir jo last option hai not equal to 1900, "<>" iska matlab sirf 'Not' hota hai na to 'equal to' lagana jaruri nahi hai?.
Ответить