Dear RagDyeR,
Thank you for you interest!
Here the new cell is H1 where I chose the column names like C or D as per
need. A2:D7 are the total data range. I just type the column name"C" or "D"
in H1 then the formulas in colum F and E should return the nonblanks same as
before. For example the formulas should hlookup (I think) for the letter/text
C in H1 and in row 1:1 then return the nonblanks in column F. And accordingly
E always from A only. Slighltly advanced problem but I could't do it!!


"RagDyeR" wrote:

I don't see your problem.

If I understand your question, you already have all the formulas you need!

All you have to do is revise the column references to get the additional
values.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Narnimar" wrote in message
...
Hi Ragdyer/Hans,
I thought I should be more clear to you with my question.
I have further need to get the small list when there is added rows like
below for the same. What my idea is I should now lookup at A column from H1
&
return nonblanks list from C or D and its value in F & E column
respectively
So when nonblank list needed in F & E based on the H1 (will be equal to
either C or D or E...) from C column or D column what would be the
formula? Hope I have improved the question. Please feel free to reply if
not yet clear. Thanks in advance.

A B C D E F
Car 2 blank 5
Bus 1 2 1
Train blank blank 3
Flight blank blank 1
Cycle 20 35 Blank
Horse Blank 1 2