Bhai agr mene ek text likha wa or mai chahta hu wo mere accordingly change ho jaye uska vba code kese likhege mjhe jha tk idea h replace formula lagana padega is pr video bna do
Sir ji, isme agr sbhi cell fill ho or apne so sirf ek hi cell me ek hi bar state ka name chahiye to uska formula btaiye. Plz... {Aapne jo btaya uska ulta formula btaiye}
waaoo, super video. i really want this formula. One more problem. we have large data of receipts. each day we have around 30 receipts i. e. 30 receipts in one day and 900 receipts in a month. But we want only those receipts between two dates like 10 april to 16 april. With filter option we can easily find out that date but we need to use formula. Bcoz i am working on a mini program, but hang at this point who to filter data between two dates. I am using office 10
Nice n informatie video...Can you please upload or send video on how to find out percentile formula for school result in excel.. as in built formula doesnt working ... Hope of your reply... Thanking...
In this excel there is three column if there is missing data in any cell that how can i cut the row which containing blank cell and paste it into other sheet in single click.
Outstanding Ashish Sir. I have earlier requested for making a video or Excel file on class intervals on data given here as 01-01-2016 to 30-06-2016 01-07-2016 to 31-12-2016
thanks bhai apne problem solve kar di, isi baat par aapko ek like
Welcome
This trick make me easy to work..............save lots of time ...................thanks again
Bet needful thi mere liye bht din se youtude ye trick search kr rha tha ab mili
Its best for me
Welcome Gopal
Thank you...Thank you....Thank you....Mere pass 40000 thousand rows ka data hai....mera kitna time save ho gaya ...Just awesome😘😘😘😘
Thanks for quick found
Ur welcome
Excellent your teaching method is so good
Wa..bahot hi maja aya ye formula se
Thanks for the Comment Vikas Bhai
Hi tech to each sir I am really thankful to video
Welcome Rohit
Ashish Sir,
कभी कभी आते हो मगर genuine problem का solution लाते हो | ; )
Thanks for the Comment Puneet Bhai
Thanks a lot, You made my work very easy.
Glad to hear that
Sir ji kya baat hai topic bahut majedar tha
Thanks for the Comment Mithlesh Bhai
Thank U So Much Bro Help Ke Liye ❤
Thanks a lot sir... Super... This trick save lots of time for me... Thanks again
Welcome Bhai
Great, I was aware about the 1st way, but thanks a lot for 2nd method. 👍
It's very helpful....great job Ashish
Thanks for the comment Narendra.
Amazing man.. My friend was struggling with this for long time 👌👌👍
Welcome
Super for gst R2A data making.. Thanks for making wonderful.. Video
Thanks for the comment Vijay Ji.
Thanks yar bhai....Very important topic for me
Thanks for the Comment Hemant Bhai
Go To Special trick is awesome
Superb trick
Thanks for the comment Sachin solanki
Well done Ashish bro it is workable
Thanks for the Comment Vipin Bro
Dear ashish, kya ye trick or method pivot lagane k baad bhi kaam karta hai..??
Really it helped a lot 🥰🥰
Nice 👏👏
Best video....
Thanks for the comment Pabitra.
Great, Keep it up, Nayi video banate raho excel pe.
Bhai agr mene ek text likha wa or mai chahta hu wo mere accordingly change ho jaye uska vba code kese likhege mjhe jha tk idea h replace formula lagana padega is pr video bna do
Thanks sir 1st one easy
Excellent.. specially formula...
Thanks for the Comment Ubaid bhai jaan
Because of this. I was stuk in my office
So thank you so much🤝👍
Wow. Finally got the solution
Thanks if very helpful to me
Gajab hai Ashish bhai
Thanks for the comment Rohit.
thanks for sharing this trick.. 👍
Welcome Bhai
Awesome video
Great sir
Welcome
Very good solution
Thanks for the Comment Awadhesh
Sir very nice video
Thanks for the comment.
Agar down to up blank cell me karna ho to kya karenge plz suggest
THANKS FOR THIS TRICK
Welcome Mohit
nice video bhai
Thanks
Sir ji, isme agr sbhi cell fill ho or apne so sirf ek hi cell me ek hi bar state ka name chahiye to uska formula btaiye. Plz... {Aapne jo btaya uska ulta formula btaiye}
waaoo, super video. i really want this formula. One more problem. we have large data of receipts. each day we have around 30 receipts i. e. 30 receipts in one day and 900 receipts in a month. But we want only those receipts between two dates like 10 april to 16 april. With filter option we can easily find out that date but we need to use formula. Bcoz i am working on a mini program, but hang at this point who to filter data between two dates. I am using office 10
Thank you sir👍👍🙏🙏😎😎😎😎
Nice n informatie video...Can you please upload or send video on how to find out percentile formula for school result in excel.. as in built formula doesnt working ... Hope of your reply... Thanking...
Formula se Value banane ke liye ek shortcut hai..... ctrl+alt+V value wala pop open ho jayega......
I am using Alt E S V for the same bro
Awesome trick bro... Me also ashish
Oh....n thanks
Thanks Sir g nice video
Thanks for the comment.
Nice...
Thanks for the Comment Devendra
And thanks sir.
Thanks Poonam
Superb
2 nd method is more useful because of its universal application in open office
Thanks bruh.
great dude
Thanks for the Comment Ivoomi
Nice Video
Nice tricks
Great
Wow amazing sir G sir this can apply if I have to fill in coloumn but what if I have huge data and have to fill in rows thans sir
If we talk about the trick select row instead of column and for formula add a row and use the formula change the address only.
sir there are so many rows and by selecting all the rows and then applying select blanks only and the formula =cell to the left it doesnot work
In this excel there is three column if there is missing data in any cell that how can i cut the row which containing blank cell and paste it into other sheet in single click.
Outstanding Ashish Sir. I have earlier requested for making a video or Excel file on class intervals on data given here as 01-01-2016 to 30-06-2016
01-07-2016 to 31-12-2016
Sir excel.me jab Koi value me type karu to automatic 100 plus Ho Jana chahiye
Sir gud trick
Thanks
It is helpful
Thanks for the Comment Demon
Thank you.
Thanks for the Comment Hammad khan
Really helpful
Useful
Thabkyou sir
Can you solve this from below cell
amazing
This is great👏 but I got another doubt what if that cell isn't blank & filled with data how can we use that?? Which formula we need?
Same query from my side
I want merje the data with respect to above one??
MIS ke scope ke bare me btye
Thanks
Thank you sir
Nice
Thank you g
Sir aap vba ka or video upload kriye na
How to remove that same cell values
Thanx
Welcome
I need shortcut form for put password to any file
अब इसको just reverse कर सकते है क्या
Go To Special option not there in Excel
Mujhe ek aur help karoge?
Sirf =c8 formula araha hai sabhi cells me
Ashish ji kabhi to file share kar diya kijiye
I want
Good can you sent me file please
shaikmohsin052@gmail.com
Can you please update video to find the special characters from the given number. Like 9898#867#685786 I want to get only # from the given number.
Are yaar itani simple chiz Kyo itna tricky banakar Dikha rahe ho just filter the column and use = n just drag it bas ho jayega
Thanks for Dismotivating me Rohit Ji.
Bhai tu hi Gyani HAI baki or bhi Bhai HAI..
I have a?
What?
@@TeachToEach A1-B2
A1-B3
A1-B4
A1-B5.......HOW? Substraction
Its very easy Sahih...Look
Need to Fix A1... IT means put $ sign ....... Write =$A$1-B3 ....then drag it to your limit ... I hope you get the answer.
@@TeachToEach thank u so much.....thank u....u r a genious youtuber....dua karta hu ki aap 1M tak jao.....
@@TeachToEach baki excel youtuber ko unsubscribe karke aapka video hi follow karunga....thank u.....e trick mera thakan dur kar diya
Send me file
Bhai file dedo for practice Emil: onlyforjatin95@gmail.com
Bro it is Ctr + Enter
Not Ctr + Return 😂😂😂😂
Slip of the tongue 😆
Send me
Very nice sir g
Nice trick
Thanks Satessh
Superb.
Welcome