Forum Discussion
Thaddaeus
Nov 24, 2024Copper Contributor
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...
Harun24HR
Nov 24, 2024Bronze Contributor
You may try the following formula-
=AVERAGE(--TEXTSPLIT(A1,"-"))