Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I just need to do a count on the data below:
Any client # that begins with JE - I need to know the total # of JE's for each day of the year. For the JO clients - I need to know the total # for each day of the year - but divided into 3 different time periods - anything between 0701 - 1500 or 1501 - 2300, or 2301 - 0700. Can anyone help me? Client # TIME DATE JO01804/03 855 20-Dec-2003 JO01822/03 1141 20-Dec-2003 JO01825/03 1431 20-Dec-2003 JO01826/03 1551 20-Dec-2003 JO0183/03 753 23-Dec-2003 JO0187/03 809 23-Dec-2003 JO0124/03 834 23-Dec-2003 JO0189/03 1038 23-Dec-2003 JO0186/03 1226 23-Dec-2003 JO01882/03 1533 23-Dec-2003 JO0186/03 1946 23-Dec-2003 JO0187/03 2158 23-Dec-2003 JO01902/03 846 24-Dec-2003 JO0162/03 730 26-Dec-2003 JO09069/03 1432 26-Dec-2003 JO0070/03 1504 26-Dec-2003 JO01978/03 1103 27-Dec-2003 JO01985/03 814 28-Dec-2003 JO01977/03 1133 31-Dec-2003 JO0195/03 1601 31-Dec-2003 JO01986/03 1659 31-Dec-2003 JE00890/03 2226 31-Dec-2003 JE00889/03 1920 31-Dec-2003 JE00888/03 1820 31-Dec-2003 JE00886/03 1517 31-Dec-2003 JE00885/03 1412 31-Dec-2003 JE00884/03 1352 31-Dec-2003 JE00883/03 1308 31-Dec-2003 JE00882/03 1255 31-Dec-2003 JE008481/03 1241 31-Dec-2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Rainfall Data | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Importing Data From Another Spreadsheet | Excel Discussion (Misc queries) | |||
Entering data on template and then data going to a spreadsheet. | Excel Discussion (Misc queries) | |||
How can I transpose data from a spreadsheet into a form that does. | Excel Worksheet Functions |