Hi,
I have been set the task of understanding how a vba process we have deindex's a series of indexed numbers. We have 2 sets of data, the 1st has been verified as accurate, but when appyling the process to a second data source the figures appear inflated when compared to the first. The verification test has been conducted whereby we uplift the resulted deindexed figures to a national level and compare this to our history table.
Does anyone know of a Excel routine that can de-index numbers that we can apply this to the second source?
Any help would be gratefully received.
Sam
I have been set the task of understanding how a vba process we have deindex's a series of indexed numbers. We have 2 sets of data, the 1st has been verified as accurate, but when appyling the process to a second data source the figures appear inflated when compared to the first. The verification test has been conducted whereby we uplift the resulted deindexed figures to a national level and compare this to our history table.
Does anyone know of a Excel routine that can de-index numbers that we can apply this to the second source?
Any help would be gratefully received.
Sam