Index compare

[Berna11]

Good evening I have to extract some names based on the given condition that I set in the Personal A1 sheet and based on the letter R present Turni sheet.

In column B, sheet Person, the formula returns an incorrect result, the correct one is in column C if dated 12/01/2019 and with R
In column D the names that on 12/01/2019 are empty the correct result is in column F
Thanks

[Bo_Ry]

Please try at
B3
=IFERROR(INDEX('Turni '!$A:$A,AGGREGATE(15,6,ROW('Turni '!$A$3:$A$14)/(INDEX('Turni '!$B$3:$N$14,,MATCH($A$1,'Turni '!$B$1:$N$1))="R"),ROWS(B$3:B3))),"")

D3
=IFERROR(INDEX('Turni '!$A:$A,AGGREGATE(15,6,ROW('Turni '!$A$3:$A$14)/(INDEX('Turni '!$B$3:$N$14,,MATCH($A$1,'Turni '!$B$1:$N$1))=""),ROWS(D$3:D3))),"")

[Richard Buttrey]

Why complicate things?

Can I suggest that you should regularise the way you keep your Turni Data, and create a two domensional table with columns for

Date
Name
Letter or Blank



Then either populate all the rows of this three column table and analyse with a Pivot table, or just AutoFilter the data to display Letters or blanks

Incidentally avoid merged cells. They just create too many problemd in any serious application.

[Berna11]

Hi @Bo_Ry
thanks ok

@Richard
no, with the Pivot I had a fight ...