I need to know which formula to use to make excel return a value based on what cell is "checked off" by entering an X for a survey question.
For instance, on the form I am creating, I want the enduser to be able to enter an X in cell A1, B1 or C1. (Doing so indicates how satisfied they were...
I am having trouble getting 2 or 3 cells to properly sort using the "custom sort" function. I have about 30 values in a single column that I need to sort in descending order. It is sorting the overwhelming majority of the values correctly, but for some strange reason, it is placing 2 or 3 cells...