Formula Copy Problem
Hello,
I'm having a problem copying down a formula with a sequence in it. For example, my formula is something like A1:A100&","&B1:B100&","&C1:C100. When I copy down to the 100th row it copies the same exact contents of A1+B1+C1 for all rows. It doesn't copy it in sequence for example A2+B2+C2 for the second row and so on. Any suggestions on how I fix that?
Thanks,
Danielle
the formula only needs to be
A1&B1&C1
As you copy it down, it will increment sequentially.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That didn't work, but thank you for you're reply
Danielle
First, make sure calculation is set to automatic.
Goto the Formulas tab>Calculation Options>Automatic
Then, your formula should be:
=A1&","&B1&","&C1
Copy down as needed.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks