| | | | | | | | | | | | | |

| **Property** | Prop1 | --> Dropdown1 | | | | | | | | | | |

| **Month** | April | --> Dropdown2 | | | | | | | | | | |

| | | | | | | | | | | | | |

**OUTPUT** | | | **DATA SOURCE** | | | | | | | | | | |

No | Property | Month | Name | Income | | | No if it is under the selected criterias | **CONCATENATE** | Property | Month | Name | Income | |

1 | =IFERROR(OFFSET($G$6,MATCH($A7,$H$7:$H$18,0),MATCH(B$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A7,$H$7:$H$18,0),MATCH(C$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A7,$H$7:$H$18,0),MATCH(D$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A7,$H$7:$H$18,0),MATCH(E$6,$H$6:$M$6,0)),"") | | | =IF($C$2&$C$3=$I7,MAX($H$6:H6)+1,"") | =J7&K7 | Prop1 | April | A | 55 | |

2 | =IFERROR(OFFSET($G$6,MATCH($A8,$H$7:$H$18,0),MATCH(B$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A8,$H$7:$H$18,0),MATCH(C$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A8,$H$7:$H$18,0),MATCH(D$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A8,$H$7:$H$18,0),MATCH(E$6,$H$6:$M$6,0)),"") | | | =IF($C$2&$C$3=$I8,MAX($H$6:H7)+1,"") | =J8&K8 | Prop2 | April | B | 85 | |

3 | =IFERROR(OFFSET($G$6,MATCH($A9,$H$7:$H$18,0),MATCH(B$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A9,$H$7:$H$18,0),MATCH(C$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A9,$H$7:$H$18,0),MATCH(D$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A9,$H$7:$H$18,0),MATCH(E$6,$H$6:$M$6,0)),"") | | | =IF($C$2&$C$3=$I9,MAX($H$6:H8)+1,"") | =J9&K9 | Prop3 | April | C | 69 | |

4 | =IFERROR(OFFSET($G$6,MATCH($A10,$H$7:$H$18,0),MATCH(B$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A10,$H$7:$H$18,0),MATCH(C$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A10,$H$7:$H$18,0),MATCH(D$6,$H$6:$M$6,0)),"") | =IFERROR(OFFSET($G$6,MATCH($A10,$H$7:$H$18,0),MATCH(E$6,$H$6:$M$6,0)),"") | | | =IF($C$2&$C$3=$I10,MAX($H$6:H9)+1,"") | =J10&K10 | Prop1 | May | D | 58 | |

| | | | | | | =IF($C$2&$C$3=$I11,MAX($H$6:H10)+1,"") | =J11&K11 | Prop2 | May | E | 63 | |

| | | | | | | =IF($C$2&$C$3=$I12,MAX($H$6:H11)+1,"") | =J12&K12 | Prop3 | May | F | 94 | |

| | | | | | | =IF($C$2&$C$3=$I13,MAX($H$6:H12)+1,"") | =J13&K13 | Prop1 | April | G | 92 | |

| | | | | | | =IF($C$2&$C$3=$I14,MAX($H$6:H13)+1,"") | =J14&K14 | Prop2 | April | H | 60 | |

| | | | | | | =IF($C$2&$C$3=$I15,MAX($H$6:H14)+1,"") | =J15&K15 | Prop3 | April | I | 88 | |

| | | | | | | | =J16&K16 | Prop1 | May | J | 73 | |

| | | | | | | | =J17&K17 | Prop2 | May | K | 64 | |

| | | | | | | | =J18&K18 | Prop3 | May | L | 56 | |

| | | | | | | | | | | | | |