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 30
1 10
2 20
I want as
Claim No.
1 10 30 10
I want tran
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
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
*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
, May 18, 2011 4:07 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help on Transpose Function based upon criteria
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
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