Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi all,
Looking through my reference book of 'Excel 2000 Formulas', I am able to find what seems to be close to what I'm looking for, but not quite. A little background, I have many rows of the same type of information, with different columns. One column contains numbers from 0.19 to 1.5, another has eight different abbreviations (GE, TOS, etc). My goal: To obtain the number of instances where the text coordinates with the row of a certain range of numbers(ex: 0.1 - 0.4 and 0.5 - 1.0, etc). GE with a range of 0.1 - 0.4 GE in the range of 0.5 - 1.0 TOS with a range of 0.1 - 0.4 etc, etc I know I have to use a COUNT function, as well as maybe a LOOKUP function, but am having a brain lapse at how to put it all together with a range of numbers. Thanks in advance, Nikki |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
quick charting question for similar charts on multiple sheets | Charts and Charting in Excel | |||
Quick Question | Excel Discussion (Misc queries) | |||
Excel Colours - Quick Question | Excel Discussion (Misc queries) | |||
Quick formula question | Excel Worksheet Functions | |||
Quick question: What does "--" in an equation do? | Excel Worksheet Functions |