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
, 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
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
Dear Kaushik,
see if it help
On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
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
hatts o..
On Wed, May 18, 2011 at 8:19 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Kaushik,
see if it help
On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote:
Hi All,
I want to transpose certain data from row to column if meets
*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 savla.kaus...@gmail.comwrote:
Hi All,
I want to transpose certain data from row to column if