Thread: What function should I use to pull those records that match
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default What function should I use to pull those records that match
Hi,

Try this in H1 and drag down

=AND(A1="No",D1<"",D1=E1,E1=G1)

Mike

"Helen" wrote:

I have a huge table and want to look at records where Column A = "No" and
Column D, E, and G = the same values as an identified record.


Reply With QuoteReply With Quote