Hi, this is my first time posting on this forum. I've found many answers to my excel problems in the past, which i'm very thankful for!
I have a particular query for which i could not find an answer. See below table (3 columns on the left are the expected final values collected, on the other columns are the cells to search from):
The purpose is to find the latest date on farther right column with a non-blank cell in a row and return this date. Then it will get the 2 next cells after this date and also return the values.
The format of the columns is fixed, and its repeated (date-revision-reference ; date-revision-reference ; etc.). ; the dates will be incrementing on the columns from left to right (as shown in the example)
Appreciate help for the above query (if possible without VBA solutions, since i'm not very familiar with those)
Thank you!
I have a particular query for which i could not find an answer. See below table (3 columns on the left are the expected final values collected, on the other columns are the cells to search from):
Value Returned | Value Returned | Value Returned | |||||||||||||||||||
Latest Date | Latest Revision | Latest Reference | Date | Revision | Reference | Date | Revision | Reference | Date | Revision | Reference | Date | Revision | Reference | Date | Revision | Reference | Date | Revision | Reference | |
25-Mar-21 | 2 | DOC H | 18-Mar-21 | 0 | DOC A | 21-Mar-21 | 1 | DOC B | 25-Mar-21 | 2 | DOC H | ||||||||||
04-Apr-21 | 2 | DOC W | 18-Mar-21 | 0 | DOC Y | 21-Mar-21 | 1 | DOC Z | 04-Apr-21 | 2 | DOC W |
The purpose is to find the latest date on farther right column with a non-blank cell in a row and return this date. Then it will get the 2 next cells after this date and also return the values.
The format of the columns is fixed, and its repeated (date-revision-reference ; date-revision-reference ; etc.). ; the dates will be incrementing on the columns from left to right (as shown in the example)
Appreciate help for the above query (if possible without VBA solutions, since i'm not very familiar with those)
Thank you!