Recode Multiple Values in the same column

Question

I want to re-code multiple values in One column.  I know we can use IF function to re-code, but how about multiple values in the same column.  How can we re-code all of these values?  I also know we can do each value per time then add them up.  But I would like to do all these re-codes at once and use one column.  Thanks.

Answer 1

Hi,

Replicating formulas in a column can be facilitated by dragging the indicator from the originating cell where you've entered the changes. To better understand your concern, we'd like to know if the cells in the column share the same formula.

In addition, we'd like to request for the following:

• Sample data or values based on your document.
• The codes that you're using in the specified column and the changes that you'd like to implement.

We look forward to your response.