We'd like to remind Forumites to please avoid political debate on the Forum... Read More »
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Excel Formula

HillStreetBlues
Posts: 6,234 Forumite


in Techie Stuff
If there anyway (apart from manually) to get an Excel formula in order of column?
Example: =sum( X2+C2+R2+L2) to =sum(C2+L2+R2+X2)
Example: =sum( X2+C2+R2+L2) to =sum(C2+L2+R2+X2)
Let's Be Careful Out There
0
Comments
-
HillStreetBlues said:If there anyway (apart from manually) to get an Excel formula in order of column?
Example: =sum( X2+C2+R2+L2) to =sum(C2+L2+R2+X2)
I guess that would be to make it more readable. I don't know of any way, although I suppose you could use the + (which could also be a comma) as a delimiter and extract the text between them. However, probably easier to manually edit the first occurrence of the formula then copy it to everywhere else it is used.I’m a Forum Ambassador and I support the Forum Team on the In My Home MoneySaving, Energy and Techie Stuff boards. If you need any help on these boards, do let me know. Please note that Ambassadors are not moderators. Any posts you spot in breach of the Forum Rules should be reported via the report button, or by emailing forumteam@moneysavingexpert.com.
All views are my own and not the official line of MoneySavingExpert.
1 -
Well, if you are working with formulae, the question you should answer is why. What are you trying to achieve?
0 -
Heedtheadvice said:Well, if you are working with formulae, the question you should answer is why. What are you trying to achieve?0
-
Heedtheadvice said:Well, if you are working with formulae, the question you should answer is why. What are you trying to achieve?Let's Be Careful Out There0
-
Then that is good and there is , no doubt, lots more knowledge to be gained about the vast possibilities with Excel.How about researching Named Ranges. They make formula reading so much easier and help selecting the correct cells/ranges correctly less prone to errors.....and then pivot tables.....and more0
Confirm your email address to Create Threads and Reply

Categories
- All Categories
- 351.5K Banking & Borrowing
- 253.3K Reduce Debt & Boost Income
- 453.8K Spending & Discounts
- 244.5K Work, Benefits & Business
- 599.7K Mortgages, Homes & Bills
- 177.2K Life & Family
- 258K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.6K Read-Only Boards