One interp ..
Assuming you want to pull into row 14,
the contents of the first non blank* cell in each col within rows 1 - 13
*contents could be either text or number
Put in A14 and array-enter the formula by pressing CTRL+SHIFT+ENTER:
=IF(COUNTA(A1:A13)=0,"",INDEX(A1:A13,MATCH(TRUE,A1 :A13<"",0)))
Copy A14 across as far as required
If you want to pull only the first non blank cell containing text (ignore
numbers)
Put in A14 and array-enter the formula by pressing CTRL+SHIFT+ENTER:
=IF(COUNTA(A1:A13)=0,"",INDEX(A1:A13,MATCH(TRUE,IS TEXT(A1:A13),0)))
Copy A14 across as far as required
If you want to pull only the first non blank cell containing numbers (ignore
text)
Put in A14 and array-enter the formula by pressing CTRL+SHIFT+ENTER:
=IF(COUNT(A1:A13)=0,"",INDEX(A1:A13,MATCH(TRUE,ISN UMBER(A1:A13),0)))
Copy A14 across as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Therese" wrote:
Hi
I have columns with words in different cells, f.ex. one word in A1, one in
B2 and one in C12.
Is there some sort of a "sumfunction", so that I can filter all the words
down into row 14 ?
Thanks
Therese