N
Narnimar
I have a large data sheet of order pending list in which I look for a text in
$B$2175 and determine the area of target cells. In this sheet they can be
found in between the resulted row from
ADDRESS(ROW(INDIRECT("B"&MATCH($B$2175,B:B,0))),1) and
ADDRESS(MATCH($B$2175,A:A,0),1)
The formula to return my needed text is if result of
MID(INDIRECT("A"&MATCH($B$2175,A:A,0)-(MATCH($B$2175,A:A,0)-MATCH($B$2175,B:B,0)+3,2,3)
= “PO-“ This will extract and return items based on “PO-“ in the column but
I need to use draghandle and extract only required value. How can I
incorporate a drag feature instead of +3 given in this formula so that even
the target row exists in other rows than 3rd row in the same column?
$B$2175 and determine the area of target cells. In this sheet they can be
found in between the resulted row from
ADDRESS(ROW(INDIRECT("B"&MATCH($B$2175,B:B,0))),1) and
ADDRESS(MATCH($B$2175,A:A,0),1)
The formula to return my needed text is if result of
MID(INDIRECT("A"&MATCH($B$2175,A:A,0)-(MATCH($B$2175,A:A,0)-MATCH($B$2175,B:B,0)+3,2,3)
= “PO-“ This will extract and return items based on “PO-“ in the column but
I need to use draghandle and extract only required value. How can I
incorporate a drag feature instead of +3 given in this formula so that even
the target row exists in other rows than 3rd row in the same column?