Excel Finding instances of a value in defined range

[wannabetechie]

Can some one help me with a small excel problem..

I have a excel sheet in which I have.... wait... why dont you check th
attached file and then tell me how do I find out the repeated instance
of a check..

For example , I want column H to say - "Instance Correct" if a chec
no. X has been found 2 times in the defined range A1-F7 , and if th
amount mentioned under deposit column of Bank is same as amount mentio
in Deposit column of company.. If the check number is found 2 times bu
the amount is different then column H should say - "Instance Wrong", i
the check number is found only once , then it should say - "N
corresponding entry found"

Please help fast as I am due to present this data in next 2 hours

Attachment filename: example of excel.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=63330

 

[Frank Kabel]

Hi
please try to explain your issue in plain text as most people won't
open an attachment!
e.g. post some example rows of your data in plain text

 

[Myrna Larson]

I haven't met your deadline, of course, but in your example check numbers are
in column A. Let's generalize the formula by assigning names to the Ranges,
i.e. CheckNo, BankDep, CompDep.

The following all goes on one line in the formula bar:

=IF(COUNTIF(CheckNo,A2)=1,"No corresponding entry",
IF(SUMIF(CheckNo,A2,BankDep)<>SUMIF(CheckNo,A2,CompDep),
"Instance wrong","Instance correct"))