Tag/Identify Cells
 

Is there a way to tag/identify cells with the same value? When
creating cell values off of cells with the same value, I need a way to
distinguish that they are/are not values created from the same cell.
Ex. :
(A1=10, A2=20, A3=30, A4=20)

Cells(1,2)=Cells(2,1)
Cells(1,3)=Cells(3,1)
Cells(1,4)=Cells(1,1)

Cells(1,2)=Cells(4,1)
Cells(1,3)=Cells(3,1)
Cells(1,4)=Cells(1,1)

Both of these produce the same results for cell "B2", although they
came from different cells in column A. I do not need to know where
they came from. Just that the values are from different cells.

Any help is appreciated.

Joe

Tag/Identify Cells
 

Show Auditing Toolbar, then click on the "Show Precedents" button.

Or, double-click the cell. Excel will select all cells that are referenced
in the formula, unless this default behavior has been overridden by an
event macro.

Or, write a macro to cycle through all cells with formulas and look for
formulas that all have the same cell references in them ("B2"). (Not easy.)

--
Regards,
Bill Renaud

Tag/Identify Cells
 

On Sep 29, 4:34 pm, "Bill Renaud"
wrote:
Show Auditing Toolbar, then click on the "Show Precedents" button.

Or, double-click the cell. Excel will select all cells that are referenced
in the formula, unless this default behavior has been overridden by an
event macro.

Or, write a macro to cycle through all cells with formulas and look for
formulas that all have the same cell references in them ("B2"). (Not easy.)

--
Regards,
Bill Renaud


Thanks Bill. I'm going to write the macro that checks precedents for
the cells in question.