Using formulas to create new lines with given quantities

February 11, 2015 at 04:14:45
Specs: Windows 7
2 Apple
1 Orange

Is there a formula for excel whereby the results will be as follows:

Row1 Apple
Row2 Apple
Row3 Orange

message edited by naveyafluz


See More: Using formulas to create new lines with given quantities

Report •

#1
February 11, 2015 at 04:23:35
It can only be done with a macro. A macro is a set of instructions written in Visual Basic for Applications, normally referred to as VBA.

Do a Google search on Excel VBA or Excel macro and see if that is something that you think will work for you, then come on back and let us know.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question