Forum Discussion
Numeric range conversion
As part of survey data, I have an Excel column that is a numeric range for the time each respondent commutes (in minutes): 1-5, 6-10, 11-15, 16-20, 21-25, etc. up to 85-90, 90+. This was a mistake as...
To add some more 365 options you could have
= MAP(numericRange, LAMBDA(r,
AVERAGE(VALUE(TEXTSPLIT(r, "-")))
))or, using a named Lambda function to simplify the worksheet formula,
= MAP(numericRange, RangeAverageλ)
RangeAverageλ
= LAMBDA(r,
AVERAGE(
VALUE(
REGEXEXTRACT(r,"\d+", 1)
)
)
);