Query for specific characters in a spreadsheet

I used Excel to track student attendance for a class this summer and used one 
character to indicate attendance, another absence, a third for cancellation, 
etc...  Is there a way to query how many of each of these characters appear 
in the spreadsheet?
0
Utf
12/16/2009 10:10:01 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
531 Views

Similar Articles

[PageSpeed] 5

=COUNTIF(range,"A")

Where range would be a column or row that would contain the character.A for
absence.

You will need a formula for each character.


Gord Dibben  MS Excel MVP


On Wed, 16 Dec 2009 14:10:01 -0800, Vicki B
<VickiB@discussions.microsoft.com> wrote:

>I used Excel to track student attendance for a class this summer and used one 
>character to indicate attendance, another absence, a third for cancellation, 
>etc...  Is there a way to query how many of each of these characters appear 
>in the spreadsheet?

0
Gord
12/16/2009 10:39:46 PM
Reply:

Similar Artilces:

Combo Box- Character Look Up
Excel VBA Look Up I have written a macro to look up data from several other worksheets. Now I want to use that summary and create specific reports (by VP, b fiscal year, by company). I want to use a combo box where if I selec "Jim Johnson" from the drop down list, all items requested by Ji Johnson will appear on the report sheet. Any help! I tried writing the index match formula by it only return values for the first character found. any ideas!! -- Message posted from http://www.ExcelForum.com Hi, Could you send soma sample data to me with info. You can see some of my handiwork...

How do I add up a column of figures? on excell spreadsheet
I am doing my accounts in an excell spreadshee and want to add the coloumn of figures where my income is. How do I do it. Normally I would go to formula and just say add, but it does not work the smae on my home computer. Thank you. Dxx Dorothy, use sum, something like =SUM(A1:A100) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dorothy" <Dorothy@discussions.microsoft.com> wrote in message news:2BA003FD-0A58-48B...

Extracting a character from a string of characters
I would like to extract the 6th character (the 5) from the following example of a string of characters e.g.B123456789. Have a look in HELP index for MID -- Don Guillett SalesAid Software donaldb@281.com "Sue" <Sue@discussions.microsoft.com> wrote in message news:73FB02F4-EDA0-4819-9280-3F74F4163B4E@microsoft.com... > I would like to extract the 6th character (the 5) from the following example > of a string of characters e.g.B123456789. > > If its always the 6th character use MID i.e. if B123456789 was in cell A1 =MID(a1,6,1) -- ______________________...

Open Excel 2002 to specific size?
Is there a way to fashion a shortcut that opens an Excel 2002 spreadsheet so that it just shows a certain set of cells, say A1 to G17? The user could then maximize the program, if he wanted, but all the relevant information would be contained in that array, so there would be no need. TIA! ** Captain Infinity You probably should use a macro once the workbook is open to resize Excel. Excel will restore itself to the position it was in when last closed and there is no command line parameter to override that. -- Jim Rech Excel MVP ...

How to invoke PowerShell ISE from C# code on a specific script
I invoke PowerShell scripts from C# code. That is working fine. What I want to be able to do is to invoke the script running in the ISE debugger (or some other PowerShell debugger would do) so that I can debug the script. It's not easy for me to debug the script without invoking it from C# because the script depends on certain variables being set up by the C# code - and also depends on calling back through those variables to functionality implemented in the C# code to do its work. I thought it might be possible when creating the runspace in the C# code like this: Runspac...

Moving a line of data when information is entered in a specific cell.
HELP NEEDED. I am trying to create a spreadsheet to keep track of problems that we encounter at our volunteer organization. It is pretty simple. I am having one problem. One of my fields is "completion information." What I need is when completion information is entered into the field, I want that line of information to move to an "archived sheet". In effect, so that I have a sheet with only active problems and when the completion information is entered it moves to the archived sheet. Anyone have any suggestions? -- opshmo -----------------------------------------------...

Spreadsheet links
I have a spreadsheet that links to another and does seriosly rely on this link but it doesn't function unless the linked spreadsheet is open. Normally this doesn't happen. I don't really ant to open as it will then block outother users as it is shard. Please can anyone help. -- Marshall Not clear on the issue... if book 2 is open the updates appear in book 1, clear enough. But if book 2 isn't _open_ nothing in it is being changed, so there is no need for book 1 to update. Can you provide a more detailed description of the problem & version? Regards |:>) "M...

Query Help 02-02-10
I have a database which I created for schoool registration. I am wanting to make it more simple so parents only go to one location for registration. For example a parent has a child in the Elem School, Middle School and High School, so they go to the High SChool they can register all 3 children in one stop. I have the database set up with switchboards that redirect you to a form which can hold up to 3 children. The purpose of this was to eleiminate multiple entries so how can I fix the data base to automatically separate the schools but still contain all the contact informati...

Include comments on another spreadsheet
I have a spreadsheet that has lastname in column B. The lastname can be repeated several times in column B. In column C are comments that I want to capture. (Sheet1) I want to capture the comments on Sheet2. I have another worksheet (Sheet2) that I want to capture all of the comments if lastname = Jones. So in other words, if lastname = Jones and there are five comments in column C, then in Sheet2, cells B2, B3, B4, B5, I want to put the comments. Thanks in advance for any help I can get with this. Here's a little more information of what I am trying to do. If Sheet1!B2:B10...

Delete query 11-07-07
Hi, can i make a "delete query", and when i start this query window appear and type there "start date" then in another window "end date". And all the records from this period to be deleted?? For example i want to delete all rows which includes dates from 01.11.2007 till 04.11.2007. Hope you understand my question:)) "Forza MIlan" <ForzaMIlan@discussions.microsoft.com> wrote in message news:F29987DC-59B4-4C0B-AE5C-31D082D10E29@microsoft.com... > Hi, can i make a "delete query", and when i start this query window appear > and ty...

Moving Parameter Queries
I have created a Parameter Query that imports transactions from an Access Database on my 'C' drive to "work out the bugs". It works just fine, however when I move it (as well as the related dqy file and the database) to a shared network drive so that others can access it, it sends back an ODBC driver error message. I am at a loss as to how to remedy this situation without recreating the query (very time consuming) at the new location Has anyone run into this before Any efforts will be much appreciated Tom Sounds like a confused link - am assuming your query pulls from a...

adding specific "Lead Source" contact or account to Lead form?
The Lead form has a "Lead Source." When the lead source is "External Referral" we'd like to track the actual Contact (or Account) so we can send them a thank you or special offer. How can we create a "Lookup" attribute (relationship?) from the Lead to a Contact and put it on the Lead form for the user to select a lead source contact from the search Contacts form? Would using the Referral field help? -- Larry Lentz [CRM MVP] MCSE+I, MCSE W2K, MCDBA, MCSA Messaging Lentz Computer Services Microsoft Small Business Specialist San Antonio, Texas Larry@LentzCo...

Is there a way to query the Outlook database?
I want to extract some data from a few hundred emails I have, but each one is huge and rather than spending the half-hour it'll take opening them manually, searching for the tag string and then copy-pasting the value immediately after it into Excel, is there a way to query the email database directly using regular expressions or something similar? Just as an explanation: I have a few hundred emails with errors in them, and I want to extract the actual error code, but it's in different places pages down in each email. It always says "ErrCode: [" and then the 20-digit code. ...

Excel function query
Hi everyone, Somehow i need a formula or something similar which will do the following. Basically, i have a column (A) of cells with different dates in them (e.g. 11/10/07). I then have another column (B) with some blank cells and some cells with numerical values in them. What i want to do is make only the blank cells in column B turn blue if 60 days over the date in Column A passes. For example, cell A1 contains the following date: 11/07/07 and Cell B1 is blank. Therefore cell B1 should be blue because 60 days have passed since 11/07/07. Hopefully someone can help, and that makes se...

Reference field in Distribution Query
Hi there, I am using GP10.0. While using Distribution Query, i have selected "Refrence" (8) as one of column. I expecting "Distribution Refrence" from General Ledger Entry should be populated. But i am not getting it. (It is showing Blank values in Excel. I am sure we are having Distribution Refrence in GL entries) Can you pls. let me know, Is my understanding correct? And also in Distribution Query how we can bring Distribution Refrence from G/L entries? Thanks, Loganathan S Logu, Distributioin reference field is available in GL10001 (GL_TRX_LINE...

Finding a function call in queries
Does anyone know of a way to find if a function is being called from a query? Another words, I have a function that might be called from 1 or more queries in my DB and I am looking for a quick way to see which queries it is called from. With over 200 queries in my DB, it will take me some time to check them manually, and I have 2 functions to check. Is there a utility or something that will do this for me? Thanks! On Thu, 6 May 2010 15:57:01 -0700, cherman <cherman@discussions.microsoft.com> wrote: >Does anyone know of a way to find if a function is being calle...

Query by Form: Output to Listbox?
Hi, I have been asked to look at a database at work that has a query by form where the user can select a table to query. There are three columns of boxes on the form. The first column are drop-down combo boxes that allow the user to select the fields depending upon the table selected above. The next column of five are for the comparison operators (<,>, etc) and the third column of five boxes are text boxes where the criteria values are typed. There is one connector box that has two values: OR or AND. The form works and displays the query in a table view. This is the code behind the but...

capture specific emails
Environment - Exchange 2K3 SP1 with Symantec Mail Security for Exchange We have an ex-employee emailing people in the company. I want to capture all emails sent from that specific address while not blocking the email to the original recipient. I thought about using the Message Tracking Center, but that is extremely manual and then to dig up the emails. Any thought...? On Wed, 25 Jan 2006 08:33:16 -0500, "Tom K" <tkarpowski@bennettcompany.com> wrote: >Environment - Exchange 2K3 SP1 with Symantec Mail Security for Exchange > >We have an ex-employee emailing p...

Excel 2007 spreadsheet
I can't get the fill handle to show on my spreadsheet. I've gone to excel options under advance there is a checkmark on Enable fill handle and cell drag-and-drop, but it still will not work. I have even uninstalled and reinstalled excel still no luck any suggestions. thanks ...

Finding repeated data in a excel spreadsheet
I have a problem with an excel spreadsheet that i need help with... I am studying a road network and it is represented by points (nodes) and the space inbetween these is the road. My problem is that obviously a road goes from say point A to point B but also back the way from point B to point A. The data i have contains both data from point A to point B but also from point B to point A. This data is identical and to i'd like to delete the repeated data from B to A. The problem is that point A may go to up to 5 other locations, ie to B,C,D,E or - as roads do at a junction. Therefore ...

sql aggregate query
My table ID - Autonumber Field Patientid - This can have a number of records with the same number dDate is the date of the record and can be duplicated. I need to create a new table with the max of date for each unique patient id. So far not a problem. SELECT TblCurrentEncounter.Patientid, Max(TblCurrentEncounter.dDate) AS MaxOfdDate FROM TblCurrentEncounter GROUP BY TblCurrentEncounter.Patientid; But the kicker is that i need the id of the row containing the max of date. As soon as i try to add ID to the query I get error about not being part of the aggregate function. Any ideas w...

query returns with more columns than included
Hi, We've noticed on a couple of our queries that when we run the query we get all the columns in the table. However, in design view we see that we have not selected all columns. Anyone know why this happens??? -- MorningStarFan Open the query in design view, click on menu VIEW - SQL View. Look at the SELECT statement and see if there is something like this -- SELECT YourTable.*, or SELECT *, If so, then delete the TableName.asterisk or asterisk. -- KARL DEWEY Build a little - Test a little "MorningStarFan" wrote: > Hi, > > We've notic...

User Account Control : How to allow a specific app?
Hello NG, is it possible - and if yes how - to "always allow" a speciffic application to be started with out the user account control window popping up. In general I think it is ok to have this window popping up, but on some frequently used application it is kind of bothering to always see this window. Regards Rainer Queck Rainer wrote: >Hello NG, > >is it possible - and if yes how - to "always allow" a speciffic >application to be started with out the user account control window popping >up. > >In general I think it is ok...

Blank characters when editing message to forward
When editing the main text body on an e-mail being forwarded, Outlook 2002 inserts a blank characterin front of each alteration. This then has to be removed manually by the recipient. How can I stop this happening. Thanks ...

How protect with password the access of a spreadsheet ?
Hi. I want to know how i can protect the access of non-authorized user to view the content of one spreadsheet of all workbook. The reason is my company has a sales report that it can be viewed for all user but there are 1 spreadsheet that contain confidential information (in the same workbook) that we wan't that be watched for all user of the report. Best Regards, Manuel Excel's worksheet protection is not made for this kind of security. It is easily broken. If you don't want the information getting out, don't put it in excel. (Or don't share that file!) Manuel ...