Nested IFs
 

Please, I need a for me complex formula to do the following:

1. if line 1 = line 2 in column A, then "No." in column C, if not then
" ",

2. if line 1 = line 2 in column B, then "Date" in column D, if not
then " ",

3. if line 1 = line 2 in column C, then "Amount" in column E, if not
then " ",


4. if line 1 = line 2 in column A and if line 1 = line 2 in column B
and if line 1 = line 2 in column C, then "HIT" in column F, if not
then " "

Thanks for your effort.

Alvaro

Nested IFs
 

if I understand your need
in col c copied across to c and changed to suit text
=IF(A2=$A$1,"no","")
in col f
=IF(COUNTIF(A2:C2,$A$1)=3,"Hit","")
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alvaro" wrote in message
ps.com...
Please, I need a for me complex formula to do the following:

1. if line 1 = line 2 in column A, then "No." in column C, if not then
" ",

2. if line 1 = line 2 in column B, then "Date" in column D, if not
then " ",

3. if line 1 = line 2 in column C, then "Amount" in column E, if not
then " ",


4. if line 1 = line 2 in column A and if line 1 = line 2 in column B
and if line 1 = line 2 in column C, then "HIT" in column F, if not
then " "

Thanks for your effort.

Alvaro

Nested IFs
 

Thanks Don.

No, I do not think this will do.

What I want is to select from a numerical list of invoices from
vendors, those which have the same Number, same Date and same Amount
so that they are identified as Duplicates on the three conditions
tested, making them candidates for further scrutiny.

During the process I also want to identify those which meet any of the
conditions tested and report on that finding.

I hope the problem is a little bit better stated now.

Thanks again

Alvaro

Nested IFs
 

in D:G (not C:F) onwards ...

=IF($A1=$A2,"No.","")

=IF($B1=$B2,"Date","")

=IF($C1=$C2,"Amount","")

=IF(AND(A1=A2,B1=B2,C1=C2),"Hit","")



"Alvaro" wrote:

Thanks Don.

No, I do not think this will do.

What I want is to select from a numerical list of invoices from
vendors, those which have the same Number, same Date and same Amount
so that they are identified as Duplicates on the three conditions
tested, making them candidates for further scrutiny.

During the process I also want to identify those which meet any of the
conditions tested and report on that finding.

I hope the problem is a little bit better stated now.

Thanks again

Alvaro

Nested IFs
 

Thanks a lot Toppers. It did work to my expectations.

Alvaro