LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Formula to display data if it meets multiple criteria

I have a workbook with several worksheets, one that has the data, and the
other that displays the results (report). I have 4 ranges of data - 0-19.9,
20-29.9, 30-39.9, 40-49.9)

My data sheet shows actual data (ex. 15.9 or 37.2) What kind of formula can
i use to get the actual data to show up under the range that it falls under?
So if someone has a 16.3, it would show up under the appropriate column on
the report page.

I hope this doesn't sound confusing.....I appreciate any help!
 
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
SUM data if meets criteria Jose Mourinho Charts and Charting in Excel 3 May 29th 07 08:06 PM
Show only data that meets a certain criteria Bob Excel Discussion (Misc queries) 1 June 26th 06 10:01 AM
Averaging data that meets a criteria Intuit Excel Worksheet Functions 4 February 22nd 06 01:02 PM
Retrieving an Item from a List that Meets Multiple Criteria hgopp99 Excel Worksheet Functions 0 January 21st 06 03:10 PM
Retrieving a Value from List that meets multiple Criteria mamalik Excel Discussion (Misc queries) 3 January 2nd 06 02:28 PM


All times are GMT +1. The time now is 10:32 PM.

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"