IF(ISERROR(INDEX(items,LARGE(IF(ticks="x",ROW(ticks),-1),ROW()-1))),"",INDEX(items,LARGE(IF(ticks="x",ROW(ticks),-1),ROW()-1)))
Sheet 1 column A is tick range and column b is an items list
name column A "ticks" and column b "items"
sheet 2 "Selected items"in A1 and put in the the array formula A2.
so now x in column A in sheet 1 whats in column b will appear in sheet2
column b
i need to send data that is in column C on sheet 1 as well as column B
and as each item is sent it appears in sheet2 the last item is first on the sheet it possible to have it as it is entered (first one first etc).
Thank you
ive
Sheet 1 column A is tick range and column b is an items list
name column A "ticks" and column b "items"
sheet 2 "Selected items"in A1 and put in the the array formula A2.
so now x in column A in sheet 1 whats in column b will appear in sheet2
column b
i need to send data that is in column C on sheet 1 as well as column B
and as each item is sent it appears in sheet2 the last item is first on the sheet it possible to have it as it is entered (first one first etc).
Thank you
ive