Comparing values in cells
I m totally new to vba excel. I m not sure if what i m planning to do could b done with vba.
is it possible to identify value/content of 2 cells in same column which is identical (the cell position is not fixed as the data is pulled from another database where the data changes each week)and compare the subsequent columns for both items.
sample table
A B C
1 Part# Measurement1 Measurement2
2 abc 10 153
3 abd 55 142
4
5
6
7 abc 15 160
8 abd 45 126
in this case is it possible to locate the identical cells (there will be only 2 duplicates) in column A (abc) and then do a comparision of the measurement 1 and 2 between the 2 rows? and it will need to do the same thing for the next item abd as well (constraint: the sequence of abc,abd,etc might vary every time the data is pulled from the database).
I would really appreciate it some on could help me out here.
at present i m stuck at the point, on not even knowing if this is possible and how to proceed.
btw hope my explanation is clear.
Thanks in advance.