Forum Discussion
Solved
Values Repeating with INDEX
I am working on a very large file for my office and have run into a roadblock. We need to pull unique invoice numbers from a large export that is copied into the workbook based on the corresponding d...
Use the same formula you used for column A, but change the array to 'ORIG EXP'!D7:D1000.
=FILTER('ORIG EXP'!D7:D1000,('ORIG EXP'!A7:A1000>=MAIN!K3)*('ORIG EXP'!A7:A1000<=MAIN!K4),"NO RESULTS")
Use the same formula you used for column A, but change the array to 'ORIG EXP'!D7:D1000.
=FILTER('ORIG EXP'!D7:D1000,('ORIG EXP'!A7:A1000>=MAIN!K3)*('ORIG EXP'!A7:A1000<=MAIN!K4),"NO RESULTS")
Rsartori76 that worked! Thank you for the simple fix.
