Find Dates on Merge Columns with other data

user19998204 0
Viewed 53

We have this tool that extracts raw data, the problem I have is that the date only appears on the heading (merge columns).

Dates from column AH are manually inputted since I am having trouble how to find the date since it was merge and if I extract a monthly raw data the date are always per heading. Sometimes 2 same dates will appear on the heading and some only consist 2 users or less.

September 1
User1
User2
User3 
September 2
User1
User2
User3
September 2
User4
User5

enter image description here

google-sheets
1 Answers

Edited

It seems like you just need to get the most recent date in column A whenever you have a cell that begins with the string User.

In that case, I think this would work. It's not a spill array, so you'd have to drag it down, but it would capture the latest date in column A for any user rows.

=if(left(A2,4)="User",Max(A$1:A1),if(isdate(A2),A2,""))
pgSystemTester0
Related