View Single Post
 
Old 09-06-2011, 05:42 PM
KIM SOLIS KIM SOLIS is offline Windows XP Office 97
Novice
 
Join Date: Sep 2011
Posts: 29
KIM SOLIS is on a distinguished road
Default How to capture start and ending Ref. Nos. in an array

Hi all,

I have an array of data with date, OR No. Code and Fees. My desired output is a recapitulation report that should capture automatically the start and end of OR Nos. on a per-day basis, as well as tally the Fees collected. Note however that, the number of ORs to be issued on a certain day is unpredictable depending on the number of clients. Also, I will need a summarized tally of the collection by Grade Code and total ORs issued per grade level.

The desired output must be in my sheet2 as my main data entry in in sheet1. My desired output is highlighted in green per my attached Query101 Excel file.

Our office issue more than 1,000 ORs every week and manual process is prone to errors and is very tedious. I know Excel can handle this but i am clueless how it is done. Please help.

Thanks a lot in advance,

Kim
Attached Files
File Type: xls Query101.xls (21.5 KB, 14 views)
Reply With Quote