Copying the data's

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Christopher Naveen - 10 Sep 2007 14:48 GMT

Hi,

Good evening.

I am christopher frm India.

My challenge is :

For example I have 5 rows and 2 columns as mentioned below and now pls look
the "name" col and the 1st data is "A" and the count is "7" and now I need
the value "A" should be pasted 7 times in new sheet and again it should check
for the 2nd data ( i.e) "B" and the count is "2" so it shud paste the 2nd
data 2 times in the sheet where already u pasted the 1st data.

Name Count
A 7
B 2
C 3
D 4
E 8

Output shoud be

Name
A
A
A
A
A
A
A
B
B

Pls help. Eagerly waiting for ur reply.

Reply to this Message

bj - 10 Sep 2007 18:40 GMT

one way
assuming your data is in column A and B and starts in A1
in C1 enter 1
in C2 enter = C1+B1
copy C2 and paste down to one row below your data

in sheet 2 in A 1
=if(row()<=product(Sheet1!B:B),index(Sheet1!A:A,match(Sheet1!C:C,row()),"")
copy and paste down as far as needed

> Hi,
>
[quoted text clipped - 34 lines]
> Pls help. Eagerly waiting for ur reply.
>

Reply to this Message

bj - 10 Sep 2007 20:46 GMT

oops!
second equation should have been
=if(row()<=sum(Sheet1!B:B),index(Sheet1!A:A,match(Sheet1!C:C,row()),"")

> one way
> assuming your data is in column A and B and starts in A1
[quoted text clipped - 44 lines]
> > Pls help. Eagerly waiting for ur reply.
> >

Reply to this Message

Christopher Naveen - 11 Sep 2007 11:14 GMT

Hi,

I pasted the 2nd equation provided by u in sheet 2 but it is showing #N/A.
Pls advise.

-Christopher

> oops!
> second equation should have been
[quoted text clipped - 48 lines]
> > > Pls help. Eagerly waiting for ur reply.
> > >

Reply to this Message

bj - 11 Sep 2007 14:46 GMT

check each of the sections by itself
=sum(Sheet1!B:B)
=match(Sheet1!C:C,row()),"")
=index(Sheet1!A:A,match(Sheet1!C:C,row())
to determine which is the source of the N/a

did column C show as numbers?

> Hi,
>
[quoted text clipped - 55 lines]
> > > > Pls help. Eagerly waiting for ur reply.
> > > >

Reply to this Message

Christopher Naveen - 12 Sep 2007 09:22 GMT

I am finding problem while using the below mentioned formula's
=match(Sheet1!C:C,row()),"")
=index(Sheet1!A:A,match(Sheet1!C:C,row())

Pls help.

-Christ

> check each of the sections by itself
> =sum(Sheet1!B:B)
[quoted text clipped - 63 lines]
> > > > > Pls help. Eagerly waiting for ur reply.
> > > > >

Reply to this Message

bj - 12 Sep 2007 15:12 GMT

the match equation should have been
=match(Sheet1!C:C,row())
and the other
=index(Sheet1!A:A,match(Sheet1!C:C,row()))

> I am finding problem while using the below mentioned formula's
> =match(Sheet1!C:C,row()),"")
[quoted text clipped - 71 lines]
> > > > > > Pls help. Eagerly waiting for ur reply.
> > > > > >

Reply to this Message

Christopher Naveen - 13 Sep 2007 13:04 GMT

Sorry.
I entered the same formula in sheet 2 cell A1 it is showing as #N/A. If u
dont mind can u pls send me the excel sheet which u tried.

My email ID : christ.naveen@gmail.com

-Christ

> the match equation should have been
> =match(Sheet1!C:C,row())
[quoted text clipped - 76 lines]
> > > > > > > Pls help. Eagerly waiting for ur reply.
> > > > > > >

Reply to this Message

bj - 13 Sep 2007 20:36 GMT

I should have copied and pasted the formula rather than just typing it in. I
made multiple errors on my typed formula
try this one on sheet 2
=IF(ROW()<=SUM(Sheet1!B:B),INDEX(Sheet1!A:A,MATCH(ROW(),Sheet1!C:C)),"")

> Sorry.
> I entered the same formula in sheet 2 cell A1 it is showing as #N/A. If u
[quoted text clipped - 84 lines]
> > > > > > > > Pls help. Eagerly waiting for ur reply.
> > > > > > > >

Reply to this Message

Christopher Naveen - 19 Sep 2007 15:10 GMT

Hi,

Excellent!!!!!!!

now it is working fine. Thanks a lot for ur help and pls dont mistake me i
really cannot understand the formula which u given here first i want to know
abt the formula. Can u pls explain me abt this formula in brief.

-Christ,

> I should have copied and pasted the formula rather than just typing it in. I
> made multiple errors on my typed formula
[quoted text clipped - 89 lines]
> > > > > > > > > Pls help. Eagerly waiting for ur reply.
> > > > > > > > >

Reply to this Message

bj - 19 Sep 2007 21:24 GMT

the first section
=IF(ROW()<=SUM(Sheet1!B:B)
merely checks to see how any rows you need to go down
the second
,INDEX(Sheet1!A:A,MATCH(ROW(),Sheet1!C:C))
sets up the range to look at and uses the match funciton to determine if you
have goten to the next number yet. column C is the cumilatve summ of the
previous times numbers need to be added.
the third
,"")
just puts a blank cell when you are past the total numner of entries you
want/.

> Hi,
>
[quoted text clipped - 99 lines]
> > > > > > > > > > Pls help. Eagerly waiting for ur reply.
> > > > > > > > > >

Reply to this Message