Forum Discussion
blank row in dates
i want blank row between different dates, and dates are adjusted in column. example if first date is 20-4-2024 second date is again 20-4-2024 but third date is 25-4-2024, third date is different then...
=VSTACK(C2,REDUCE("",SEQUENCE(ROWS(C2:C15)-1,,ROWS(C2:C15)-1,-1),LAMBDA(u,v,VSTACK(IF(INDEX(C2:C15,v)<>INDEX(C2:C15,v+1),VSTACK("",INDEX(C2:C15,v+1)),INDEX(C2:C15,v)),u))))
With Office 365 or Excel for the web you can use this formula.