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
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.
sort by:
Show
per page
Replies: 3
|
By:
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 |
|
By:
PS: might have misinterpreted your question. Off for another coffee...
|
|
By:
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. |