Dear Kaushik,
I am having a small doubt pertaining to your solution given for transpose
formula. When i look into the sheet, the claim no. 1 shows the Amount of 10,
10, 50 & 20 was been given. But as per your formula, the Amount of 10, 30 &
20 has got transpose to the Claim NO.1. Where as Amount R
Check this one it will help you
http://en.kioskea.net/forum/affich-132961-vlookup-find-value-3-4-5-etc
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of KAUSHIK SAVLA
Sent: Wednesday, May
*Array Formula, written in 9 cells (oneRow Range) at once !*
=IFERROR(TRANSPOSE(INDEX($B$3:$B$11,SMALL(IF($A$3:$A$11=$C16,ROW($1:$9)),ROW($1:$9,"")
On Wed, May 18, 2011 at 5:36 PM, KAUSHIK SAVLA wrote:
> Hi All,
>
> I want to transpose certain data from row to column if meets specific
> cri
hatts o..
On Wed, May 18, 2011 at 8:19 PM, NOORAIN ANSARI wrote:
> Dear Kaushik,
>
> see if it help
>
> On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA wrote:
>
>> Hi All,
>>
>> I want to transpose certain data from row to column if meets specific
>> criteria: eg
>> Whole d
Dear Kaushik,
see if it help
On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA wrote:
> Hi All,
>
> I want to transpose certain data from row to column if meets specific
> criteria: eg
> Whole data is as below:
> Claim No. Amount
> 1 10
> 2 20
> 1