excel list

Occasional Visitor

Hi, I created a list with 5 categories to choose from. Is there a way to assign the words in the list a numerical value so I could create a chart with the data? I actually have 5 lists and they all have the same choices. They are checkpoints. If I assign a value I can see if there is growth... Any help would be much appreciated as I'm an amateur.

1 Reply


here is a small and quick solution approach

=IF(D7="Hello","1",IF(D7="Niko",2,IF(D7="to",3,IF(D7="the",4,IF(D7="world",5,"" )))))


Hope I could help :).