@@RebekahOster I got a query for excel formula. i spent few hours with Bing AI getting help but could not succeed help. How can i share this file or tell you that query i need to solve.,
i have dates in 3 columns, paid upto then from and to. I want claculate sum in column arrear, whereas date of next month in column "from" following paid upto column and 1 month less date than column "to" date.
Thank you for watching!! The problem is, your spreadsheet won't ever be just like my spreadsheet! I've never found practice files useful for me, so I generally don't create them.
This tutorial helped me a lot to clear my misunderstanding. Whenever using conditional formatting through formula. Thank you.
I’m so glad it helped! 🎉
@@RebekahOster I got a query for excel formula. i spent few hours with Bing AI getting help but could not succeed help. How can i share this file or tell you that query i need to solve.,
i have dates in 3 columns, paid upto then from and to. I want claculate sum in column arrear, whereas date of next month in column "from" following paid upto column and 1 month less date than column "to" date.
=IFERROR(SUM(OFFSET($E4, 0, MATCH(TEXT($B4, "mmm-yy"), $E$2:$U$2, 0) - 1, 1, MATCH(TEXT($C4, "mmm-yy"), $E$2:$U$2, 0) - MATCH(TEXT($B4, "mmm-yy"), $E$2:$U$2, 0) + 1)), "Date Not Found")
Gracias, muy buena aclaración. Saludos cordiales!!!!!😊👍
Thank you for watching!! I have a free masterclass here: www.excelpowerup.com/training
👏👏👏
If you could make available to down load formulas in some sort of format will be helpful to follow for anyone interested
Thank you for watching!! The problem is, your spreadsheet won't ever be just like my spreadsheet! I've never found practice files useful for me, so I generally don't create them.
I got the first spot.
W video
In minute 9.52, I think you mean F4, rather than Ctrl+F 😂😂😂
Yes I meant F4! Good catch :)