We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I'm wanting to set up a macro to auto sort a block of cells.
the problem arises because the column i'm wanting to sort from takes it's value from another cell
for instance A152 takes it's value from the following =A2, this returns a number, some cells below A152 are blank.
When i try to sort the block of cells, it doesn't recognise column A as numbers it gives me the A to Z sort option.
the problem arises because the column i'm wanting to sort from takes it's value from another cell
for instance A152 takes it's value from the following =A2, this returns a number, some cells below A152 are blank.
When i try to sort the block of cells, it doesn't recognise column A as numbers it gives me the A to Z sort option.
Show More
Once the numbers are sorted, do they remain that way?
If yes, then before SORTING
a) COPY THE COLUMN
b) KEEP THE COLUMN HILITED
c) PASTE SPECIAL / VALUES
d) then SORT
If yes, then before SORTING
a) COPY THE COLUMN
b) KEEP THE COLUMN HILITED
c) PASTE SPECIAL / VALUES
d) then SORT
PS: might have misinterpreted your question. Off for another coffee...
I would say that your problem is one of relative reference not absolute
reference.
If cell A152 takes it value from A2 change the formula =A2 to =$A$2 which
is an absolute reference. Change all cells that are in the sorted range that
refer to cells outside the sorted range to absolute references.
Hope that helps.
reference.
If cell A152 takes it value from A2 change the formula =A2 to =$A$2 which
is an absolute reference. Change all cells that are in the sorted range that
refer to cells outside the sorted range to absolute references.
Hope that helps.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539