Good afternoon guys,
I have another one I have been fighting for a while. I am trying have Excel place a number value in a cell based on the text value of a different cell.
For example:
I have 4 text values: Overdue, Due, OK & Completed (These are all in drop down's in 1 column)
I would like to have a 1, 2, 3 or 4 placed in a seperate column (based on priority for filtering purposes)
I have looked in quite a few placed and havent really come up with anything, tried a few but I dont think I got anywhere close with it.
Anyone have any thoughts?
Thanks!
Bookmarks