I have a huge dataset with income brackets in column B and BMI values in column C:
totinc BMI 15600>18200 19.5 18200>20800 27.4 20800>23400 22 23400>26000 29.5
And so on. What formula can i use to order this data by the total income group for example assigning number 1 in column A to those in the 15600>18200 group etc
I have tried using a VLOOKUP formula but it only works when i use one number and no with the > or < symbols and i do not have time to change the values.
Any help would be greatly appreciated,