Hi,
I have a COUNT formula that scans a database and returns the number of times a certain value (let's say "Widget") is mentioned. I was wondering if there was a way to have an input cell, say A1, that I could type "Widget" into, and it would populate column E with "Widget" that corresponds with the count number.
So if I had a 50 count for "Widget", it would populate E2 and then 49 rows down, all in Column E, with the word "Widget", and then stop at E52 when it hits 50.
I have a COUNT formula that scans a database and returns the number of times a certain value (let's say "Widget") is mentioned. I was wondering if there was a way to have an input cell, say A1, that I could type "Widget" into, and it would populate column E with "Widget" that corresponds with the count number.
So if I had a 50 count for "Widget", it would populate E2 and then 49 rows down, all in Column E, with the word "Widget", and then stop at E52 when it hits 50.
