=IF(OR(ISNUMBER(FIND($O$1,L2,1)),ISNUMBER(FIND($S$1,L2,1)),L2=""),"",L2)
This coding eliminates particular numbers from a list – how can I alter this coding to eliminate all numbers "outside a designated "sum" range?
(FYI: The sum is the addition of each of the three digits to get a "total").
See attach sample where I manually placed what I'm looking to accomplish.
Bookmarks