Mar 27 2022 09:02 PM
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.
Mar 28 2022 04:39 AM
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 :).