not null cell within a range
Posted by kevin burrell on August 20, 2001 8:30 AM
i have a Cell range with one cell in that range always containing a value, note only 1 cell will contain a value( varying cells within this range can contain this value so cell is not absolute), i want to capture this value wherever it appears in this range and store that value to an absulute cell range.
Could any one help me,
nb. This value is not an integer so the countif functions cannot be used.