Repeating a formula in text

  • Thread starter Thread starter Lyn
  • Start date Start date
L

Lyn

I'm concatenating two columns in an excel data file. The formula works, but
won't replicate in the column to subsequent rows, all it will do is copy.
I'm tearing my hair out - I've done it before but all of the sudden it won't
work. Can you help?
 
1) What happens if you hit [F9] ?
If this recalculates the correct results - then your Calculation option
is set to "Manual".
2) Did you, by mistake, fix the References of the concatenated cells with $
[like: $A$1] ?
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counta not counting correctly!! 2
Errors when using named ranges 1
Excel Formula displays text of formula 2
Excel Help to copy information from one row at a time to another sheet 1
Repeating formulas.... 2
Print Titles: Repeating both left column and top rows 2
Row #s Not Advancing When I Copy Formula 2
Print area won't change 8

Back
Top