How to add and delete cells automatic in excel for quotation marks
@UpAification15 сағат бұрын
What tool you are using when you highlight colorful marking as arrow or rectangle?
@matthewthia17 сағат бұрын
hi! really informative video, but does this still work if the entry form is in a separate excel workbook from the sheet storing the records?
@lazerkaboomКүн бұрын
This is awesome. So far I can only get it to work on the desktop version, web version is a no go.
@stephenrichards53862 күн бұрын
Hi Jopa. I've used your template in Libre Office. It works fine but I don't need the dashboard. I'm use to data analysis
@shikhatiwari7252 күн бұрын
In days of expiration I want to Exclude Saturday as well. How can I do this
@highgarden46492 күн бұрын
Thank you so much, very helpful and something I needed.
@AliRaza-wp8tr3 күн бұрын
Thanx
@0999aman3 күн бұрын
Thanks Bro. GoodTips
@AaronTrumble-l9h4 күн бұрын
thankyou, this is wonderful. however today when opening the file I get#name error. Any ideas why? it was working perfectly
@lexiepardo99844 күн бұрын
For some reason on my worksheet, after the sumifs function, it wont calculate a number. it just says 0
@ankitanand84384 күн бұрын
Second sheet random boxes are coming counted for me but not the first one shown..
@kateravan19334 күн бұрын
When I tried changing the date for FEB it didn’t automatically change all. Also when I select and delete data for new month it didn’t delete data in some cell
@rosacenteno31944 күн бұрын
Could you please add column for the stock returns and pull out bad orders. THANK YOU
@mb471194 күн бұрын
Thank you so much this is the template I need for my inventory
@syedtahirbukhari83775 күн бұрын
I subscribed to you can you make a budget on a restaurant and mostly I'm watching on your channel
@stephenrichards53865 күн бұрын
Have you a download, please
@OfficialRyanx5 күн бұрын
Would this be able to be replaced with colours and animals instead? E.g. Redlion7?
@OfficialRyanx5 күн бұрын
So rather than letters, numbers and symbols have colour, animal, digit?
@JESUSISSAVIOR2105 күн бұрын
Thank you
@PAST_PRESENT_FUTURE_5 күн бұрын
THANK YOU
@garrylawrence31647 күн бұрын
Very helpful and beginner-friendly! I'm 19 and I was able to finish this in a day's time.
@matts.85637 күн бұрын
What’s up with your mic bro?
@ahmedmokhtar1907 күн бұрын
Would you please make video about debit and credit in excel and current account statement using excel thanks
@mavicmdigap7 күн бұрын
Hi, can you make a video on how to match multiple receipt with one payment, suppose the data for both is in the same sheet. Thanks
@mbarakomar58058 күн бұрын
Thanx, i was looking for this example for long time. Finally i got it 💯👌
@Dave-gg6vl8 күн бұрын
Thank you helped me a lot and I was able to adapt it to what I needed
@manissery19568 күн бұрын
Can't we use text function directly in the formula i.o. helper column~?
@rajubhanoth71128 күн бұрын
NICE SIR THANK YOU
@benjaminaydin24619 күн бұрын
when I go to right click the note to change the background color there no option to "format Comment" Any tips?
@AnonxRaepzZx9 күн бұрын
Man I followed this all exactly and it did not work. Idk if I have a diff version of excel but it wasn't working for me.
@mohamedcoker86649 күн бұрын
Thanks a lot you have done great for me 😊
@joanantonio59159 күн бұрын
now i know how to make my monthly budget excll❤
@joanantonio59159 күн бұрын
thank you mr jopa for your excellent tutorial very big help for me i labya😘
@russellneal52649 күн бұрын
Wish i had found this video about 2 hours ago. Thanks for posting
@dhaffirm110 күн бұрын
So helpful, thank you!
@gustavbonsu40810 күн бұрын
Hi Jopa, does the total balance left for the month let’s say In January, does it automatically forward onto the total balance of February or is it still part of your income left over…hope am making sense of my explanation
@No.IdeaPodcast10 күн бұрын
Bro this tutorial literally helped me so much have had to double back on it multiple times, thank you!😂
@JohnGillH10 күн бұрын
That’s pretty cool
@MichaelLoja-b3y11 күн бұрын
Good tutorial
@sunjedaakterurmy647011 күн бұрын
Really helpful, thank you very much :)
@Jadeyy-pt3hk11 күн бұрын
How to get the method 2?
@asikenabdullah11 күн бұрын
ctr + Minus very helpful to delete blank row . Thank you very much
@davidsimon96105 күн бұрын
Genius
@joelmiller853612 күн бұрын
I love that Tnx for sharing💙
@HiteshDubsmasterNanda4U12 күн бұрын
NOT WORKING
@kirajones483213 күн бұрын
It still won't work for me 😢
@reenurenjith152913 күн бұрын
hi, thank you so much. pls update on how to write a function to count adjacent cells with same colors. if two adjacent cells(eg: C1,D1) are having same color green, need to increment count by one. if two adjacent cells are of different color green and yellow, the count doesn't increment. pls help on the same.
@harshagodavarthi156814 күн бұрын
😮 It’s cool
@tjcib15 күн бұрын
Thank you. I was doing this but kept getting an arrow. I was missing the &
@deeward141815 күн бұрын
Direct and Helpful. Thank you
@amagohom15 күн бұрын
Nice!! what excel year is this? mine doesn't have the second option!
Пікірлер
How to add and delete cells automatic in excel for quotation marks
What tool you are using when you highlight colorful marking as arrow or rectangle?
hi! really informative video, but does this still work if the entry form is in a separate excel workbook from the sheet storing the records?
This is awesome. So far I can only get it to work on the desktop version, web version is a no go.
Hi Jopa. I've used your template in Libre Office. It works fine but I don't need the dashboard. I'm use to data analysis
In days of expiration I want to Exclude Saturday as well. How can I do this
Thank you so much, very helpful and something I needed.
Thanx
Thanks Bro. GoodTips
thankyou, this is wonderful. however today when opening the file I get#name error. Any ideas why? it was working perfectly
For some reason on my worksheet, after the sumifs function, it wont calculate a number. it just says 0
Second sheet random boxes are coming counted for me but not the first one shown..
When I tried changing the date for FEB it didn’t automatically change all. Also when I select and delete data for new month it didn’t delete data in some cell
Could you please add column for the stock returns and pull out bad orders. THANK YOU
Thank you so much this is the template I need for my inventory
I subscribed to you can you make a budget on a restaurant and mostly I'm watching on your channel
Have you a download, please
Would this be able to be replaced with colours and animals instead? E.g. Redlion7?
So rather than letters, numbers and symbols have colour, animal, digit?
Thank you
THANK YOU
Very helpful and beginner-friendly! I'm 19 and I was able to finish this in a day's time.
What’s up with your mic bro?
Would you please make video about debit and credit in excel and current account statement using excel thanks
Hi, can you make a video on how to match multiple receipt with one payment, suppose the data for both is in the same sheet. Thanks
Thanx, i was looking for this example for long time. Finally i got it 💯👌
Thank you helped me a lot and I was able to adapt it to what I needed
Can't we use text function directly in the formula i.o. helper column~?
NICE SIR THANK YOU
when I go to right click the note to change the background color there no option to "format Comment" Any tips?
Man I followed this all exactly and it did not work. Idk if I have a diff version of excel but it wasn't working for me.
Thanks a lot you have done great for me 😊
now i know how to make my monthly budget excll❤
thank you mr jopa for your excellent tutorial very big help for me i labya😘
Wish i had found this video about 2 hours ago. Thanks for posting
So helpful, thank you!
Hi Jopa, does the total balance left for the month let’s say In January, does it automatically forward onto the total balance of February or is it still part of your income left over…hope am making sense of my explanation
Bro this tutorial literally helped me so much have had to double back on it multiple times, thank you!😂
That’s pretty cool
Good tutorial
Really helpful, thank you very much :)
How to get the method 2?
ctr + Minus very helpful to delete blank row . Thank you very much
Genius
I love that Tnx for sharing💙
NOT WORKING
It still won't work for me 😢
hi, thank you so much. pls update on how to write a function to count adjacent cells with same colors. if two adjacent cells(eg: C1,D1) are having same color green, need to increment count by one. if two adjacent cells are of different color green and yellow, the count doesn't increment. pls help on the same.
😮 It’s cool
Thank you. I was doing this but kept getting an arrow. I was missing the &
Direct and Helpful. Thank you
Nice!! what excel year is this? mine doesn't have the second option!