monzer_yazigi
New Member
- Joined
- Mar 14, 2014
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I have a large random data, given a search value as input, I need to:
1. search for its' next greater value within the random data
2. return the row and column of the next greater value
The first part is solved by the formula:
I know I can use VBA but I am trying to avoid that.
Any advise?
Thanks
1. search for its' next greater value within the random data
2. return the row and column of the next greater value
The first part is solved by the formula:
LARGE(A1:H1000,COUNTIF(A1:H1000,">=" & K1))
where: - A1:H1000 is the range of random data
- K1: Search value
The problem is with the second question. Not able to figure it!!!I know I can use VBA but I am trying to avoid that.
Any advise?
Thanks