Search results for query: *

Thank you to all for your responses. I was not aware of the SUMPRODUCT function before and will use it. I debated about how much info to include in my original post and now see I made an error in that as well. FWIW: I've got is a bunch data from traffic tickets and I need to count the number...

Thank you for your reply. My function name is a misnomer - I don't want to SUM anything, I want to count based on 3 different criteria. I guess what I really want is a COUNTIFS() function for Excel 2003.

I am trying to create a custom function for use in Excel 2003 (Excel 2007 has the function I need but I have to use 2003 at work). I want the function to count based on 3 criteria but I can not get it to count using only 1 criteria. Here is my code: Function sumviolation(strViol As String) As...

Thank you for your reply. The frames sound like the way to go. I'm not familiar with them but I'll research them. Thanks again!!

I am writing a program to tabulate responses to 54 questions. Each question is answered “Yes”, “No”, or “N/A”. I set my table up with 3 fields for each question: Qx_Y,Qx_N, Qx_NA (with ‘x’ being the question #) – each field is a “Yes/No” data type. Each question can only have one “Yes”...

I'll reply to my own post - I found the answer at http://www.forumco.com/jmhare/topic.asp?TOPIC_ID=993&FORUM_ID=6&CAT_ID=3&Topic_Title=nasty+excel&Forum_Title=General+Questions Here's their sample code: Sub sCopyRSExample() 'Copy records to first 20000 rows 'in an existing Excel Workbook and...

I have an Excel workbook with multiple worksheets. The third worksheet: 1) Is titled "Priority Codes" 2) Contains data in columns "A" & "B" - number of rows is unknown 3) Some of the cells are in "BOLD" type I want to import the data in column...

Due to a bunch of flack from management, it's looking more and more like a total re-write job. Thanks for your help and suggestions.

I have a Clipper 5.2 app that I need to load onto a common network drive. The app lets users query numerous databases and the results are displayed on a series of screens. The users have been accessing this app via a BBS, and are used to doing screen prints. Once we move to app to the NT...