Nov 24 2018 06:52 AM
{=IFERROR(INDEX('COST PRICE ESTIMATE SHEET'!A$16:A$872,SMALL(IF('COST PRICE ESTIMATE SHEET'!$J$16:$J$872<>0,ROW('COST PRICE ESTIMATE SHEET'!A$16:A$872)-ROW('COST PRICE ESTIMATE SHEET'!A$16)+1),ROWS('COST PRICE ESTIMATE SHEET'!A$16:'COST PRICE ESTIMATE SHEET'!A16))),"")}
Above is what I have used before and its worked but since doing some alterations i cannot get it to go? I have entered alt control and ENTER but no joy, any ideas?
Nov 24 2018 07:30 AM
That's array formula, did you enter entire formula =IFERROR(...,"") with Ctrl+Shift+Enter ?
Nov 24 2018 07:40 AM
Hi Yes how the file works, only if I add a quantity out of the list of 872 lines will it appear in the quote, originally a Pal did this formula and I have been copying / paste for the last 12 months and its worked fine but now its just not picking up?
Nov 24 2018 08:04 AM
Sorry, but I didn't catch what exactly doesn't work. Formula itself is correct, it copies values from column A starting from row 16 if only for such rows values in J are not zeros. May you attach the file or at least screenshot which illustrates what doesn't work?