View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Captain Snuggles Captain Snuggles is offline
external usenet poster
 
Posts: 12
Default Find values over a certain amount

I need to find a way to identify all the people who have a dollar
amount of 250 or more in two of five columns.

Name Amount1 Amount2 Amount3
Amount4 Amount5 True/False
John Doe 300 0 100
5000 0 True
Mary Yu 90 100 100
100 50 False

Any ideas?