Need a formula (maybe IF statement)

[lovelyanai]

I was wondering if someone could knew of a formula that would identify any rows where the dates and gross amounts match but voucher number is different.


<TABLE style="WIDTH: 855pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=1139 border=0><COLGROUP><COL style="WIDTH: 35pt; mso-width-source: userset; mso-width-alt: 1718" width=47><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2779" width=76><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 210pt; mso-width-source: userset; mso-width-alt: 10240" width=280><COL style="WIDTH: 212pt; mso-width-source: userset; mso-width-alt: 10349" width=283><COL style="WIDTH: 71pt; mso-width-source: userset; mso-width-alt: 3437" width=94><COL style="WIDTH: 199pt; mso-width-source: userset; mso-width-alt: 9691" width=265><TBODY><TR style="HEIGHT: 16.5pt" height=22><TD class=xl65 style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext 2pt double; BORDER-LEFT: windowtext 2pt double; WIDTH: 35pt; BORDER-BOTTOM: windowtext 2pt double; HEIGHT: 16.5pt; BACKGROUND-COLOR: silver" width=47 height=22>Unit</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext 2pt double; BORDER-LEFT: windowtext; WIDTH: 57pt; BORDER-BOTTOM: windowtext 2pt double; BACKGROUND-COLOR: silver" width=76>Voucher</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext 2pt double; BORDER-LEFT: windowtext; WIDTH: 71pt; BORDER-BOTTOM: windowtext 2pt double; BACKGROUND-COLOR: silver" width=94>Vendor</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext 2pt double; BORDER-LEFT: windowtext; WIDTH: 210pt; BORDER-BOTTOM: windowtext 2pt double; BACKGROUND-COLOR: silver" width=280>Name</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext 2pt double; BORDER-LEFT: windowtext; WIDTH: 212pt; BORDER-BOTTOM: windowtext 2pt double; BACKGROUND-COLOR: silver" width=283>Invoice</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext 2pt double; BORDER-LEFT: windowtext; WIDTH: 71pt; BORDER-BOTTOM: windowtext 2pt double; BACKGROUND-COLOR: silver" width=94>Date</TD><TD class=xl65 style="BORDER-RIGHT: windowtext 2pt double; BORDER-TOP: windowtext 2pt double; BORDER-LEFT: windowtext; WIDTH: 199pt; BORDER-BOTTOM: windowtext 2pt double; BACKGROUND-COLOR: silver" width=265>Gross Amt</TD></TR></TBODY></TABLE>

 

[Gerald Higgins]

Can you give us maybe 2 or 3 different examples of matching and non-matching items please ?

 

[Robert Mika]

You can try
if your data are in column A-G
In column H copy down(works for Excel 2007 and above)

=COUNTIFS($F$2:$F$8,F2,$G$2:$G$8,G2,$B$2:$B$8,"<>"&B2)

any rows greater that 1 woudl indicate your requirments.