Thank you. I did have a SUMIFS formula, so my end result formula was massive, but I finally go it to work!
@guerrill
7 ай бұрын
you are a genius, brother. Thanks
@santoshkoyada
Жыл бұрын
Thanks for the detailed explaination. It was really helpful
@aliabrishamchi
3 ай бұрын
That was very helpful, thanks!
@rameshworpudasaini1491
5 ай бұрын
perfectly works for me.. Thanks!
@chrisc.8862
2 ай бұрын
Thanks, Is there a way to make the chart show only months with values ie in this case only show Jan - Mar, on the chart but without changing the source data, so in the next month when data is provided for April, the chart shows this line without changing the data source?
@antoniobacic5674
Жыл бұрын
very good, but the cost of this method is a loss of analysis possibility: excel won't find MIN, MAX, or AVG for example from the data, and that is an issue when there are hundreds of cells, with lots of empty values (for example zero sales on holidays or weekends interrupting different sales numbers for other dates, and tons of different "products" with the same profile, making it time-consuming to manually eliminate empty cells every time it gets updated).
@dalebraden
2 жыл бұрын
What's the point if the months still show? not a clean graph
@h2e
Жыл бұрын
This video is specifically for getting rid of values. If you want to see how to automatically adjust ranges, refer to this video: kzitem.info/news/bejne/uaSqx2ZtbYqAaoo
@joojsmnsx95046
Жыл бұрын
Not works for Google sheets :/ only excel
@stevenward4250
4 ай бұрын
dude thank you!!!
@inerasmodellfornyttokalkyl1201
Жыл бұрын
Fantastic, thank you. Solved my problem :D
@SweetishMatoa
Жыл бұрын
This is very helpful, thank you!
@partyboyww
2 ай бұрын
Nice video but i can't get it to work, i have this formula in X35: =IFERROR(H35+U35; "") (H35 is my start amount, and U35 is my PnL, and if it's empty it will be blank) How do i apply it to this formula i keep getting errors, can somebody pls help me? :)
@andreywillians1443
Жыл бұрын
excellent dude, thx, but not works in google sheets (i need), only in excel :/
@Andrejs_Dzelme
5 ай бұрын
I don't know why this way didn't work for my Excell, but I tried to put just "#n/a" in a cell and everything worked. No any "=IF()" needed.
@h2e
5 ай бұрын
It may be an issue with how you setup your if statement. But you don't need the if statement, it's just to avoid having to hardcode the na value each time
@fernandoromero5235
2 жыл бұрын
Excellent!
@H377-l3h
Жыл бұрын
Thanks dude
@serjames2893
2 жыл бұрын
Finally a solution that actually works !! @microsoft 🤦♂🤦♂
@shubhanginiawasthi1696
Жыл бұрын
awwwwsomee :)
@foxhound-0
Жыл бұрын
Bad in teaching. you are teaching yourself like memorizing for your deeds not helpful at all so fast the command you are typing fast
@MartinDurik
2 жыл бұрын
It could be explained in 30 seconds. Waste of time.
@johannesmp3
Жыл бұрын
What would be helpful is if you could explain how it could be done in 30 seconds. Maybe even a link to one instead of unhelpful remark
@Andrejs_Dzelme
5 ай бұрын
Exactly. Almost all the best tutorials don't exceed 30 seconds.
Пікірлер: 25