Update Cell Value

Microsoft Excel 2007
January 20, 2010 at 19:16:31
Specs: Windows Vista
I work for an insurance company and I have a spreadsheet that shows a list of policies along with all US states. Each row will have at least one state indicated. The value used as the state indicator is a '1'. I need to replace the value of '1' with the State Abbreviation (which is the column header). I know I can filter to find all values equal to '1' and then I can do a find/replace to update the '1's' to the applicable state. There has to be an easier way, though! Any thoughts are greatly appreciated!

See More: Update Cell Value

Report •

January 20, 2010 at 21:25:34
In the empty column to the right of your data, row 2 enter the following formula changing the B to whatever column contains your 1 values
then drag the formula down to populate all the rows of data

Report •
Related Solutions

Ask Question