# Viewing formula result and history

#### 007juk

##### Board Regular
Hi,

I've had help on the forum with a question relating to using the conditional formatting function to look down 2 columns and highlight duplicate entries - this is the formula:

=countif(b2:b6,a2)>0

what I'm looking for is the following:-

Is there a way of finding out which cell refers to the target.

e.g. if I have 5,000 in cell a2 and the duplicate entry is found in cell B4. Is there a way of displaying that cell? As some debit entries may be for 45,000 (a4) and the credit entries are made up from two entries consisting of 1 at 30,000 (b5) and another at 15,000 (b6)

so a4 = b5 & b6

Thanks,

### Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Replies
3
Views
483
Replies
3
Views
282
Replies
8
Views
2K
Replies
0
Views
238
Replies
2
Views
426

1,191,092
Messages
5,984,604
Members
439,896
Latest member
SquareCare

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back