Shaolin
09-14-2007, 06:20 AM
I'm trying to compare the value of the cells in row A with row B. So, for instance, if the values start in Row A, Column 6, then I want it to search in row B, column 6, and row B, column 7.
Let's say cell A6 reads "HELLO NY" and cells B6, B20 and B54 have the same value, then in cell C6, I want it to print out the cell locations "B6, B20, B54"
Also, the same can be said about cell A7, A8 and so on. If cell A7 reads "Bedtime" and cells B7 and B11 also read "Bedtime", then in cell C7 should print out the locations "B7, B11"
Let's say cell A6 reads "HELLO NY" and cells B6, B20 and B54 have the same value, then in cell C6, I want it to print out the cell locations "B6, B20, B54"
Also, the same can be said about cell A7, A8 and so on. If cell A7 reads "Bedtime" and cells B7 and B11 also read "Bedtime", then in cell C7 should print out the locations "B7, B11"