Hi all
I have an array formula here which looks for a difference between various sets of data and returns values if there is a difference. Could someone help me modify this so rather than having <> to return an absolute difference it will read, if there is a difference between the values of 10 or 50 or 100 return the value
=CONCATENATE(IFERROR(INDIRECT("a"&SMALL(IF($D$2:$D$29<>$J$2:$J$29,ROW($J$2:$J$29),""),ROW(A1))),"")," ",(IFERROR(INDIRECT("B"&SMALL(IF($D$2:$D$29<>$J$2:$J$29,ROW($J$2:$J$29),""),ROW(B1))),"")))
Thanks to anyone to can offer help!
Bookmarks