In excel formula, we generally give the reference of cell range like A2:A101, if the value from A2 to A101 are in sequence like A2=11001 to A101=11100, is there any way we can give the actual value range (i.e. 11001:11100) in the formula instead of the cell range reference.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
give actual number range in excel formula instead of giving cell range
- Thread starter PANIGGR
- Start date
-
- Tags
- excel formual
etaf
Well-known Member
- Joined
- Oct 24, 2012
- Messages
- 8,789
- Office Version
- 365
- Platform
- MacOS
whats the formula you want to use it
maybe include the range , but also use MIN() and MAX()
what version of excel are you using - worth updating your profile - a lot more functions available in the later version
maybe include the range , but also use MIN() and MAX()
what version of excel are you using - worth updating your profile - a lot more functions available in the later version
Upvote
0
I am using ms 2023 and it could by any formula, example like below where the range is sheet1!$C$1:$C$15000 where i have updated the numbers with sequence 3010001 to 3025000. So i have to maintain one reference sheet always to put this formula, i am looking any logic to replace the cell refence and give the actual number range from 3010001 to 3025000
=IFERROR(INDEX(sheet1!$C$2:$C$15000,MATCH("*" & TRIM(Sheet2!C3) & "*",sheet1!$AR:$AR,0))
Upvote
0
Similar threads
- Question
- Question
