Backboards: 
Posts: 153
In response to "It sounds like you're trying to do multiple comparisons of values in a single cell/function. " by Fuzzy

I used xmatch to return "which line is my data on" and then an xlookup to return the corresponding decrement level. it's not super elegant

but it works without a helper column so...


Post a message   top
Replies are disabled on threads older than 7 days.