A Count-type formula?

  • Thread starter Thread starter brbolin
  • Start date Start date
B

brbolin

I have a user who has a "different" request.
They have a document that consists of two columns of data. Column "A"
consists number of times an item has been measured. Column "B"
consists of the measurement. They are wanting column "C" to actually
show the measurement that number of times.
Example:
A B C
---------------------------
1| 2 2 x 4 2 x 4
| 2 x 4
|
2| 1 10 x 15 10 x 15
|
3| 3 5 x 10 5 x 10
| 5 x 10
| 5 x 10

Now, I'm pretty sure I wouldn't be able to get it to list it in a
different row for each measurement, but even if I were to get it to
list it the desired number of times in one cell, I can format that cell
to "Wrap Text" and scrunch the cell down to where it will make it
taller, and look like the above example.
Any thoughts or ideas would be GREATLY appreciated.

Thanks!

Bryan
 
Hi

try
=LEFT(REPT(B1&CHAR(10),A1),LEN(REPT(B1&CHAR(10),A1))-1)
and fill down, this will repeat the text the given number of times in a cell
with a carriage return (enter) between each repetition
(you may need to adjust row heights)

Cheers
JulieD
 
Back
Top