- Joined
- Dec 16, 2012
- Messages
- 2,314
- Reaction score
- 38
- Points
- 48
- Excel Version(s)
- 365
While developing a solution for here I'm creating a function which includes a FillDown step.
First I add a conditional column (MostRecentH4):
then I want to fill down, so I expect everything below the date in the top row to be filled with that date in the top row, right?
This is what I get:
The top two rows are swapped round first, then it's filled down!
Why!?
An earlier sort on another column has to be there as it cannot be assumed that the dates are in the right order in the source table.
Is there an explanation and or workaround?
In the attached file the function to be is called fnMiniTbl and it's the 4th step.
First I add a conditional column (MostRecentH4):
then I want to fill down, so I expect everything below the date in the top row to be filled with that date in the top row, right?
This is what I get:
The top two rows are swapped round first, then it's filled down!
Why!?
An earlier sort on another column has to be there as it cannot be assumed that the dates are in the right order in the source table.
Is there an explanation and or workaround?
In the attached file the function to be is called fnMiniTbl and it's the 4th step.