Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting a Range of Values
Who likes a challange? I have a workbook that has multiple worksheets. A number of the worksheets are identical and are used by multiple users to input their own data. I need to extract a set number of rows from 2 of the columns on each of these given sheets. To make matters more interesting, I only want to extract the row if there is information in it. If the field is blank, leave it! I want these to be extracted into another worksheet in the same workbook. After I perform a calculation on each of these rows that were exported, I will get a new column which will contain a time. (ie: 8:45) I want to be able to count the number of entries for a set range. (ie: Before 8:00 AM, 8:00 AM - 9:00 AM, etc...) Below is a sample of what would appear in each worksheet. Call Time Wait Time 12:44 PM 8 12:56 PM 12 Is there a way for Excel to do this? I know a little more then the average bear on how to use this program, but certain things elude me... Thank you in Advance, James :) :) -- slyverson ------------------------------------------------------------------------ slyverson's Profile: http://www.excelforum.com/member.php...o&userid=26906 View this thread: http://www.excelforum.com/showthread...hreadid=401318 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Match function...random search? | Excel Worksheet Functions | |||
Automatically clear values from a range of selected cells | Excel Discussion (Misc queries) | |||
MIN with zero values in the range | Excel Discussion (Misc queries) | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions |