See the attached workbook.
A sheet is worth a thousand words in this case, mostly because I have no idea how to concisely describe the problem.
See the attached workbook.
A sheet is worth a thousand words in this case, mostly because I have no idea how to concisely describe the problem.
Still using Excel 2019?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you are using Excel 365 in the meantime:
Please empty all expected results (in column D and E) and try in C2 and copy down:Formula:Please Login or Register to view this content.
For 2019 version,
Try this in C2, then copy down and across.
Please Login or Register to view this content.
Single formula at C2 for completeresult.
Formula:Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks