LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find amount in row. art Excel Worksheet Functions 13 May 11th 09 06:46 AM
Find the smallest amount Brian Excel Discussion (Misc queries) 1 September 4th 08 02:34 PM
Find a cummulative amount can't understand excel Excel Discussion (Misc queries) 1 February 15th 07 03:45 PM
find values that add up to certain amount Joshua Jacoby Excel Discussion (Misc queries) 12 May 25th 06 08:09 PM
find same amount in different workbooks Debbie Excel Worksheet Functions 1 November 15th 05 11:07 PM


All times are GMT +1. The time now is 12:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"