Forum

Hi, If your Excel version is Excel365 and you have DROP, MAP, LAMBDA, HSTACK (in addition to these, REDUCE and VSTACK for auto spill in the range) ...

Hi, I can't see the attached document. If i'm not misinterpreting A1 to AE1 dates from Jan 1 to Jan 31 (31 dates) However, for February 20...

@Velouria, many thanks... @austris bahanovskis, glad to have helped and thanks for your feedback

Hi, Assuming your data is in the range A1:C7 Name and City / Formula - E2 =REDUCE(A1:C1,UNIQUE(A2:A7),LAMBDA(x,y,VSTACK(x,LET(f,FILTER(A2:C7,A2:A...

Another option =DROP(A1#,-1)=DROP(A1#,1)