Hi,
I have a dataset with a column for different ranges of household income and i want to use an index (or dummy variable ) to represent each category of household income. How can i do it using excel ?

obs no household income need to created this index

1 less than $20,000 1
2 $20,000 - $29,000 2
3 $30,000 - $39,000 3
4 less than $20,000 1

and so on .....

Thanks in advance,
Pat