need help to formulate an excel formula to share the required output

[Ravi Verma]

Hi EXcel Champs ,
Please help me to formulate an excel formula to show the unique data as per attached file ..
kinldy help

 

[p45cal]

Power Query solution at cell E2. Update the data in the left table, then refresh the result table by right-clicking it and choosing Refresh.

 

[shrivallabha]

Formula based solution in column M, N and O. In principle, logic required is around generating a repeat number 7 times and then subtracting sequentially to show the dates in the week.

Note: This is fairly old approach. There may be nifty O365 functions which can do this in a shorter way.

 

[bosco_yip]

Another old function approach.

[M3]: =INDEX(B$3:B$13,INT((ROW(A1)-1)/7)+1)

[N3]: =IF(M3="","",ROW(A1)+1) --> custom formula as "d-mmm"

[O3]: =IF(M3="","",IF(M3<>M2,VLOOKUP(M3,B$3:C$13,2,0),0))