Forum

jay_excel
@jay_excel
Active Member
Joined: Jul 23, 2017
Topics: 4 / Replies: 7
Reply
RE: Merging two different cells containing IF formula and change in cell values based on multiple time frames

Hi Team, Few of the cells in the worksheet were skipped and didn't included the formulas. Made the required amendment and hereby attaching the revi...

8 years ago
Reply
RE: Need a formula to sum the values based on their respective dates on every due date basis

Hi Mynda, Moving ahead, I've arrived at two more complex situations, based on: 1) merging two different IF formulas in one cell, which should sa...

8 years ago
Reply
RE: Need a formula to sum the values based on their respective dates on every due date basis

Hi Mynda, Please accept my sincere apologies as I took more than some time to understand the complications by myself. Finally, cleared all the clut...

8 years ago
Reply
RE: Need a formula to sum the values based on their respective dates on every due date basis

Hi Mynda, Got a bit confused here. Trouble in placing the given formula. Please find the attached file with description of what's required. A...

8 years ago
Reply
RE: Need a formula to sum the values based on their respective dates on every due date basis

Hi, As per your analogy, allow me to add one more point in your question framed statement. So, if your due date in cell A2 is 15th August ...

8 years ago
Reply
RE: Error in highlighting the last Thursday's of every month in Conditional Formatting

This has been helpful. Appreciated the resolution. Ok, will use only forum from next time. Sorry for trouble. Cheers 🙂

8 years ago
Reply
RE: Need a formula to sum the values based on their respective dates on every due date basis

Hi Mynda, So, I need to sum the values R2:R32 until and unless 15th August appears. Once 15th August appears as current date, then sum R33:R63...

8 years ago