Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUM data if meets criteria | Charts and Charting in Excel | |||
Show only data that meets a certain criteria | Excel Discussion (Misc queries) | |||
Averaging data that meets a criteria | Excel Worksheet Functions | |||
Retrieving an Item from a List that Meets Multiple Criteria | Excel Worksheet Functions | |||
Retrieving a Value from List that meets multiple Criteria | Excel Discussion (Misc queries) |