Become a Registered Member (free) to remove the ads that appear in thread area.
If this is your first visit, be sure to check out the Board FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
If you have three different dates in each row, the following seems to work OK: - =TEXT(MAX(H3:J3), "dd/mm/yyyy") &" "&ADDRESS(ROW(),MATCH(MAX(H3:J3),H3:J3,0)+COLUMN(),4) Autofill down for each of the rows you have data in.
Thank you all VERY much!
Forum Rules
Like this thread? Share it with others