Hello - first post and never programmed a macro.

I have the same 100 words in 10 columns and I need to add the row number of where each word appears in the different columns:


1 apple pear peach pear
2 pear apple plum plum
3 plum cherry pear cherry
4 cherry peach apple peach
5 peach plum cherry apple

eg., apple should equal 1+2+4+5 = 12 , etc.

Any detailed help would be greatly appreciated. Best regards, Zeke.