Mark McInerney
Active Member
- Joined
- Apr 4, 2012
- Messages
- 270
- Office Version
- 365
- Platform
- Windows
Hi,
I have a large range of data - I need to use range formulas using If and Large combinations to return the largest number when certain conditions are met.
As the dataset is large, there are duplicate values.
As a workaround I add a very small number to every number in the range, to create a unique value in every cell in the range.
Is there a better way to achieve this - make every cell in a range unique?
Thanks - Mark.
I have a large range of data - I need to use range formulas using If and Large combinations to return the largest number when certain conditions are met.
As the dataset is large, there are duplicate values.
As a workaround I add a very small number to every number in the range, to create a unique value in every cell in the range.
Is there a better way to achieve this - make every cell in a range unique?
Thanks - Mark.