Hello,
I have a list of vertical numbers that gets placed in segments
eg.
#=Segment
11-27=7
8-10=6
4-5=4
2-3=3
In the solution cell, I would like to match a number automatically with a segment, how do I do that?
eg. if cell C39 = 11 (which is the #)
Then I would like C41 = 7 (which is the segment)
I have attached a sample, and the highlighted area is where I would like to plug the equation instead of manually selcting.
Thanks!
Bookmarks