You don't have any tables with that name. The image that you posted shows the table names in your workbook. I assume that it is the underlined one below.
| davids4500.xlsm | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | |||
| 1 | Column A | Column B | NAME | Column D | Column E | Supplier Orders | Arrivedate One | Column H | ||
| 2 | AFR065 | 204872 | Air Freshener Truck Don't Look Back (Ocean) | 15/01/2024 | 12 | 15/01/2024 | ||||
| 3 | AFR157 | 255927 | Air Freshener Beautiful Girl - Strawberry | 15/01/2024 | 192 | 15/01/2024 | 30/05/2024 | |||
| 4 | AFR157 | 255927 | Air Freshener Beautiful Girl - Strawberry | 30/05/2024 | 96 | 15/01/2024 | 30/05/2024 | |||
| 5 | AFR172 | 256671 | Air Freshener Make Difference Today | 15/01/2024 | 192 | 15/01/2024 | ||||
| 6 | AFR191 | 257962 | Air Freshener Stay Close | 15/01/2024 | 192 | 15/01/2024 | 30/05/2024 | |||
| 7 | AFR191 | 257962 | Air Freshener Stay Close | 30/05/2024 | 48 | 15/01/2024 | 30/05/2024 | |||
| 8 | AFR192 | 257963 | Air Freshener Sometimes | 15/01/2024 | 192 | 15/01/2024 | ||||
| 9 | AFR205 | 258599 | Air Freshener Pink Heart - Strawberry | 15/01/2024 | 192 | 15/01/2024 | ||||
| 10 | AFR209 | 258603 | Air Freshener Be Happy Van Orange | 30/05/2024 | 240 | 30/05/2024 | ||||
ChreosStockarriving | ||||||||||
| davids4500.xlsm | ||||
|---|---|---|---|---|
| R | S | |||
| 2 | Air Freshener | 15/01/2024 | ||
Keycategories | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| S2 | S2 | =INDEX(FILTER(ChreosstockarrivingDavid__2[Arrivedate One],(ISNUMBER(SEARCH(R2,ChreosstockarrivingDavid__2[NAME])))*(ChreosstockarrivingDavid__2[Supplier Orders]>0),""),1) |
You are incredible...Thank you so much. This is so good!
)Understood....You're welcome. Thanks for the follow-up.
(The result would have come a lot faster though if you had been clearer with details and had carefully addressed questions being asked of you.
