selected extraction of cell ref in a series of cells in a row/colu

R

romelsb

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.....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a series of cells 2
Search for specific text within last non blank cell in a range 2
display first or second match instead of #REF in INDEX ROW formula 9
Data Validation: Store cell address instead of value in the cell? 1
Sum a row of multiple vlookups 1
How to define a drop down row filter in cell C2 for cells C3:C27 ? 1
Duplicate the contents of a row when text is entered in a cell 10
How to export unlocked cells to a row in a text file. 0

Top