xoxe1337
New Member
- Joined
- May 22, 2022
- Messages
- 2
- Office Version
- 2021
- 2019
- 2016
- Platform
- Windows
- MacOS
Hello, I would really appreciate if somebody could assist with the problem.
=IFERROR(MATCH(MIN(INDIRECT("'Export Data'!"&ADDRESS(
MATCH(I2,'Export Data'!$A:$A,0),51,4)&":"&ADDRESS(
MATCH(I3,'Export Data'!$A:$A,0),51,4))),'Export Data'!AY:AY,0)-2,"")
I2 and I3 specify row range numbers
51 is column same as AY:AY
I wanted the formula to check the values of cells(numbers) between row numbers in range specified in I2 and I3 cells and return minimum row number value.
The formula is working fine unless AY:AY has repetitive value then it will ignore I2 I3 range and return the first repetitive number.
If i want to find the smallest value in range of row numbers 45-57, the formula will ignore my specified range and return me the row 35, just because row 35 has the same numeric value as row 49 which is in range 45-57.
=IFERROR(MATCH(MIN(INDIRECT("'Export Data'!"&ADDRESS(
MATCH(I2,'Export Data'!$A:$A,0),51,4)&":"&ADDRESS(
MATCH(I3,'Export Data'!$A:$A,0),51,4))),'Export Data'!AY:AY,0)-2,"")
I2 and I3 specify row range numbers
51 is column same as AY:AY
I wanted the formula to check the values of cells(numbers) between row numbers in range specified in I2 and I3 cells and return minimum row number value.
The formula is working fine unless AY:AY has repetitive value then it will ignore I2 I3 range and return the first repetitive number.
If i want to find the smallest value in range of row numbers 45-57, the formula will ignore my specified range and return me the row 35, just because row 35 has the same numeric value as row 49 which is in range 45-57.