Thread: Nested IFs
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alvaro Alvaro is offline
external usenet poster
 
Posts: 4
Default 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