This might be better suited for the Macro forum, but I believe this should be possible with a formula. I am very new to excel, but have used the IF function before...which is what I assume I will need for this.

I have a two column spreadsheet with this data:

Column A/ Column B
George/ teacher
Margret/ admin
Sandy/admin
Emily/teacher
Mark/admin
Michael/admin

I need the values in Column A to be deleted if the value in Column B=Teacher