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...
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 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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.