I'm trying to exclude a single result from INDEX listing. For example let's say that INDEX gives me 10 columns ( B1:10 ) with the numbers 0-9, I have a function in A1 that gives out number between 0 and 9 ( depending on changes up the chain ) and I want to exclude that specific number from showing up in the INDEX list.I don't know if it makes any difference, but in my real case I'm dealing with plain text rather than numbers.
Exclude specific result from INDEX from within the range
google spreadsheets