LinkBack URL
About LinkBacks
Hi My data in excel is shown
Under A
A
B
C
under B
1
2
3
till 100
My expected output should be
Row A Row B
A 1
A 2
A 3
...
C 100
This should be done automatically...in a new excel sheet
Hi My data in excel is shown
Under A
A
B
C
under B
1
2
3
till 100
My expected output should be
Row A Row B
A 1
A 2
A 3
...
C 100
This should be done automatically...in a new excel sheet
???? could you clarify that ,you want 100 a then 100 b then 100 c's and if the value changed to say 88 youd have 88 of each. please post a workbook showing some expected results
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Example file attached
Number of entries in both the row can change
Put these formulas in Cells A1:B2 respectively:
and drag the formulas from row two down to row 300
-------------------------------------A-------------------------------------- -----------------B------------------ 1 =LOOKUP(ROW(),{1,100,200},{"A","B","C"})&1 1 2 =LOOKUP(ROW(),{1,101,201},{"A","B","C"})&IF(RIGHT(B1,3)=100,1,RIGHT(B1,2)+1) =IF(RIGHT(B1,3)=100,1,RIGHT(B1,2)+1)
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Look at post #3 for a solution
Sorry but can u post the same in excel ...also the numbers in my original sheet are not unifrom...i can only give u the count based on the sheet
this will do anything put in column a repeated the number of times of the max in columb b
Last edited by martindwilson; 07-01-2012 at 07:24 AM.
Fantastic thank you ...
something went wrong again....Please find ur sample sheet
in the attached file i see that a is generated for 1300 times
but i only want a with 13 entries mapped to the the data in 13 columns in B
Column B sometimes might have text as well...i put them in the attached file again
Hi can you please check this post again
this is not the same as you originaly asked however
Can u check this sheet...looks like i have not given you my right requirement(atleast we are not on same page on the final result)
ok see sheet 2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks