Spreadsheet: 773075d1647608131-index-and-match-to-return-specific-rows-of-data-only-example-workbook
Sheet: Sheet1

Employee Number | Date | Blank Column | Reference | Currency | Indicator | Percentage 1 | Percentage 2
Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref
Employee 1 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00
Employee 2 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  | Return Employee Number, date and percentage 2 (in non-consecutive columns) - where the value of percentage 2 is different from 15
Employee 3 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00
Employee 4 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00
Employee 5 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee |  |  |  | Date |  |  |  |  | Percentage
Employee 6 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 13 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 11
Employee 7 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 14 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 11
Employee 8 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 15 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 25
Employee 9 | 28/02/2022 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 16 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 11
Employee 10 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 17 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 11
Employee 11 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 19 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 17
Employee 12 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 23 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 11
Employee 13 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11.00
Employee 14 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11.00
Employee 15 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 25.00
Employee 16 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11.00 |  |  | Return Employee Number, date (+1 day) and percentage 2 (in non-consecutive columns) - where the date is equal to 28th February 2022
Employee 17 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11.00
Employee 18 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00
Employee 18 | 2023-12-31 00:00:00 |  | FL6 | USD | X | 11.00 |  |  |  |  | Employee |  |  |  | Date |  |  |  |  | Percentage
Employee 19 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 17.00 |  |  |  | Employee 9 |  |  |  | 2022-03-01 00:00:00 |  |  |  |  | 15
Employee 20 | 28/02/2022 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 20 |  |  |  | 2022-03-01 00:00:00 |  |  |  |  | 15
Employee 21 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00 |  |  |  | Employee 22 |  |  |  | 2022-03-01 00:00:00 |  |  |  |  | 15
Employee 22 | 28/02/2022 |  | FL5 | USD | X |  | 15.00
Employee 23 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 11.00
Employee 24 | 2023-12-31 00:00:00 |  | FL5 | USD | X |  | 15.00
Employee 24 | 2023-12-31 00:00:00 |  | FL6 | USD | X | 17.00 |  |  |  | Return Employee Number, date and percentage 2 (in non-consecutive columns) - where the Reference is FL6
 |  |  |  |  |  |  |  |  |  |  | Employee |  |  |  | Date |  |  |  |  | Percentage
 |  |  |  |  |  |  |  |  |  |  | Employee 18 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  | Employee 24 |  |  |  | 2023-12-31 00:00:00 |  |  |  |  | 17