Repeated date index

[S P P]

Repeated date index

 

[p45cal]

TLI

 

[S P P]

Can you help me with the formula I put in the example?

 

[Monty]

Hello Spp
Can you please help with more details like problem statement and columns And output you are looking for?

 

[vletm]

S P P​

You offered a formula which
... You wrote that maybe not work
and Your expected results.
You seems to missing Your used rule.
You could get Your expected results with Your given sample even by
writing to cell I3 =C3 and copy down & right.

 

[pecoflyer]

Perhaps

=FILTER($B$3:$D$10;$B$3:$B$10=B3)

( format as required)

 

[S P P]

Get it like this

=SEERRO(ÍNDICE(Tabela1;MENOR(SE(CONT.SE(H3;Tabela1);LIN(Tabela1)-MÍNIMO(LIN(Tabela1))+1);LIN(A1));COL(B1));"")

Ctrl+Shift+Enter

 

[S P P]

Example how it turned out