Tum apna dimag ma use karna ...sab hum hi kar le . h r u prabaht
Nitesh
On Wed, Feb 18, 2009 at 11:03 PM, prabhat.shrivasta...@gmail.com <
prabhat.shrivasta...@gmail.com> wrote:
>
> Dear All,
> I want to know the formula to which retrieve multiple data from single
> column.
>
> 1 a
> 2 b
> 1
a little addition to Dilip's solution
see the attached file
On Thu, Feb 19, 2009 at 1:39 PM, Dilip Pandey wrote:
> Hi Prabhat,
>
> One dirty way may be:-
>
> Column A Column B Column C Column D 1 a =IF(A2=1,B2,"")
> =C2&C3&C4&C5&C6&C7 2 b =IF(A3=1,B3,"") 1 c =IF(A4=1,B4,"") 1 d
> =IF(A5=1
Hi Dilip,
Thanks for your valued help...
Pls can you send me this in the excel format?
this would be more helpful for me to understand the below mentioned.
I want to know the formula to which retrieve multiple data from single
column.
1 a
2 b
1 c
1 d
3 e
4 f
lookup Value is 1 and d
Hi Prabhat,
One dirty way may be:-
Column A Column B Column C Column D 1 a =IF(A2=1,B2,"")
=C2&C3&C4&C5&C6&C7 2 b =IF(A3=1,B3,"") 1 c =IF(A4=1,B4,"") 1 d
=IF(A5=1,B5,"") 3 e =IF(A6=1,B6,"") 4 f =IF(A7=1,B7,"")
Now, if you drag the column C till the range you want, you have the result
in
