I need a way to select a cell in a column, find all the cells with the same value, and place specific text in adjacent cells next to each of them.
For example, I select "Rite Aid" and for all cells containing "Rite Aid" I want to fill the cell next to it with "Prescriptions".
I'm brand new to Excel and I'm using the version that comes in Office 2010.
Please tell me what to do and how to implement it.