LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Copying the data's

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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copying the Hyperlink function result without copying the actual formula mcheng Excel Worksheet Functions 2 June 9th 07 02:43 AM
copying a row Excel Greenie[_2_] Excel Discussion (Misc queries) 1 May 21st 07 04:11 AM
Combine all the data's from different sheet to one sheet. cheenu Excel Worksheet Functions 1 May 15th 06 04:34 PM
Copying neilangelo Excel Discussion (Misc queries) 5 February 1st 06 01:13 PM
collect data's from different excel files Alex Excel Worksheet Functions 2 November 22nd 05 04:08 PM


All times are GMT +1. The time now is 07:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"