To help with this question, please look at the attached sample data. In the ethnicity section in cell D57 you can see there's a simple formula. If you then click on the adjacent E57 cell, some how the formula got erased but the correct value is there.
How can I tell Excel to use the same formula in D57 but to change cell so that it's E56/E6 etc for the entire row all the way to L? There must be a way so I don't have to type formula again for each column.