| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
selected extraction of cell ref in a series of cells in a row/colu
I have a varying quantity of cells in a table from 4x4 upto 45x45.
Some cells contains values while some are blank. I need to extract the following in one cell. 1. cell refs in blank e.g. result "A1,E3,F5,A35,K40,,,,,AS45" - in any ordered arrangement. Also, I need to extract the following in another cell. 2. cell refs with integer values (+/0/-) e.g. result "A2,E4,F6,,,,,AS44" - in any ordered arrangement. Please advise for a trial formulation on the above 2 cells..... -- "Bright minds are blessed to those who share them.."-rsb. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
