Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
only a certain text from a target col
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Target.Value | Excel Worksheet Functions | |||
Target cell reference moves when target is cut and pasted | Excel Discussion (Misc queries) | |||
target.value | Excel Discussion (Misc queries) | |||
Target | Excel Worksheet Functions | |||
How to convert a hyperlink to its target full-text URL | Excel Discussion (Misc queries) |