Help ! Formula needed

[Sally Rose]

Hi there !

Help please with the following:

If I have one entry in Column A, Row 1 (apple for example) and then in Column B, Rows 1 -10 I have entries, I need a formula that will automatically fill in Apple into Column A depending on how many entries there are in column B. So Apple will appear 10 times.

Hope that makes sense & somebody can help!

Thanks

Sally
x

[Tony Valko]

You're probably going to get tarred and feathered for using a non-specific thread title. I suggest you change it to something more specific, like maybe:

Repeat value depending on number of entries in another range

Now, let's get down to business!

If cell A1 = Apple...

Enter this formula in A2 and copy down to a number of cells that will match the maximum number of cells in column B that will contain data.

=IF(B2="","",A$1)