Sir, the excel file you have used in the video and the link you have attached in the description, both are different, please check them again... I like your teaching style sir..
if the cell value is 12311212224 then we can count unique value using this formula - COUNT(VALUE(UNIQUE(MID("cell reference",SEQUENCE(LEN("cell reference"),1,1,1),1)))) we can count duplicate value using this formula =LEN("cell reference")-COUNT(VALUE(UNIQUE(MID("cell reference",SEQUENCE(LEN("cell reference"),1,1,1),1))))
Sir I want a Data Analyst Job. I did my graduation in Data Analytics and also did 4 months internship. Sir when I will see the post of Data Analytics. I saw there that they need 2 to 3 year of experience. How to get the job of Data Analytics. Sir Please guide me.
ruclips.net/video/aU3NeJVjark/видео.html above mention video link, you perform function in the same worksheet, so pls explain if data in external workbook.
Sir, the excel file you have used in the video and the link you have attached in the description, both are different, please check them again... I like your teaching style sir..
Sir ,i watched your videos. i got job as Data Analyst, I'm pretty much working on excel
Completed the entire series in a month. Aise hi SQL & Power Bi Dax cracker series ki bhi request hai guru ji. thanks for everything
I have seen entire data analyst cracker playlist, its very useful sir thank you .😍
Last example was excellent thanks sir 👍...
Hello sir
Today I am doing Mis Executive Job Because of you thaks for everything
Kindly start to make a vba series
Bro kon kon sa skill sikha aur job kaha se mila?
@@Abhijit9703advanced excel pe kaam karo aur different job portal pe apply karo
Thanks
Sir, please make a video on how to auto hide and unhide rows by button in google sheet by google app script......
Sir MIS and data analytics me fresher bhi apply kar sakte hai jo Excel Sikh chuke hai
Sir proquest series phir se continue kro....
nice session ❤❤
Hi sir,
I want to know how to find the count of unique values within a single cell
(or)
To find the count of duplicate values within a single cell ?
if the cell value is 12311212224 then
we can count unique value using this formula -
COUNT(VALUE(UNIQUE(MID("cell reference",SEQUENCE(LEN("cell reference"),1,1,1),1))))
we can count duplicate value using this formula
=LEN("cell reference")-COUNT(VALUE(UNIQUE(MID("cell reference",SEQUENCE(LEN("cell reference"),1,1,1),1))))
=INDEX(C132:E140,MATCH(F132&G131,C132:C140&D132:D140,0),3)
If pressing F9 shows that all values are correct, but the formula still returns #VALUE!,
Sir , ye bhi bataye aap ki jo practice fole hai discription mein wo wo mhtml mei download hobrahi hai excel mein kaise convert hogi
Sir, oppo , vivo country nahi h company h ( last wale question m )
Super very nice
Sir the file you attached in the description is different from the file you have used in the video please update the same.
Oho..will check and update it within a day or 2
Sir I want a Data Analyst Job. I did my graduation in Data Analytics and also did 4 months internship. Sir when I will see the post of Data Analytics. I saw there that they need 2 to 3 year of experience. How to get the job of Data Analytics. Sir Please guide me.
Kindly connect with team innozant for more details
Jis prakar se automatic serial no generate karte hai Google sheets me kya us prakar automatic date generate kar sakte hai ?
Plss provide formula
Yes we can do that
Sir value added 🎉💯😢😊
Really in India employers are nuts.Most of these can easily be done with excel function no need of formulas
SIR MERI EK PROBLEM H DOLVE KR SKTE H KYA ECEL RELATED
Dada, mix text data theke ki vbe a to z text korbo.
Requesting to Microsoft stop pivot table
Super sir First comment ❤
fil is different plz check once
sir apko interview sheet kaise bheje
@innozantofficial telegram I'd par
@@Innozant ok
Sir symbol konsa ha sahi se dikh nhi aarha ha
please share emoji here sir
🙏SIR🙏
❤😊
I'm first❤
ruclips.net/video/aU3NeJVjark/видео.html
above mention video link, you perform function in the same worksheet, so pls explain if data in external workbook.