Help with counting user entered text values

Hi,

Version: Excel 2000 

Situation: 
In Column G, I will have testers entering in their initals. 

I would like to display the tester's initals in column H of another
worksheet with the number of times that set of intals appeared in
column G on column I of the other worksheet.


The catch is that I do not have a list of the testers initals ahead of
time, so I'll need to pull them from column H.


Thanks for any and all help in advance,  

David
0
dleslie1 (1)
4/1/2004 6:29:17 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
421 Views

Similar Articles

[PageSpeed] 18

Hi David,

H10:  DAL
i10:  =COUNTIF(G:G,H10)

or  if you don't want to see 0 if H10 is empty
I10:  =IF(H10="","",COUNTIF(G:G,H32))

If your last line was a typo and you meant column G.

an alternate approach if list is not too long and you don't
know what initials are in column G ahead of time.  Will
show count next to the first occurrence of the initials.
H2:  =IF(CountIF(G$2:G2,G2)=1,COUNTIF(G:G,G2),"")

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

"David Leslie" <dleslie@columbus.rr.com> wrote in message =
> In Column G, I will have testers entering in their initals.
>
> I would like to display the tester's initals in column H of another
> worksheet with the number of times that set of initials appeared in
> column G on column I of the other worksheet.
>
>
> The catch is that I do not have a list of the testers initals ahead of
> time, so I'll need to pull them from column H.   <-- is this a typo ???i
>
>
> Thanks for any and all help in advance,
>
> David


0
dmcritchie (2586)
4/1/2004 7:46:58 PM
Reply:

Similar Artilces:

Copy text
In Sheet3 I have my formula ( e.g. MOD(H7)), and I want the result to be copied automatically to Sheet1 - the value only. Which function would do it for me? On Tue, 15 Nov 2011 10:28:31 +0100, salonowiec wrote: > > In Sheet3 I have my formula ( e.g. MOD(H7)), and I want the result to be > copied automatically to Sheet1 - the value only. Which function would do it > for me? Think about it this way: Excel doesn't copy results *to* cells, it pulls results *from* cells. In Sheet1, in the cell you want the result copied to, put this formula: =Sheet3!P47 (assuming P4...

help!! #2
Hi. can anyone help me solve this formula on excel.. =IF(PlanA=0,PlanB,PlanD) Thanks -- reddie12345 ------------------------------------------------------------------------ reddie12345's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28500 View this thread: http://www.excelforum.com/showthread.php?threadid=480997 see solution in your other post: http://www.excelforum.com/showthread.php?t=480996 PLEASE don't multi-post, as this wastes the time of the volunteers who spend time answering in one location when the problem has been already solved in another...

Signatures and formats, Help Please
Ok, Here is the situation: - Outlook 2000 Workgroup Only format to send mail: HTML - Exchange Server 5.5, provides messages for pop3 and imap: html. - Outlook Express 6 (POP3 access) sends and receives as html. all email clients have a png file as signature, inserted with html code. (<img src= /> Situations: a) Outlook 2000 WO, sends email to another Outlook 2000 WO, signature Ok. b) Outlook 2000 WO, sends email to Outlook Express 6 (or any other client with pop3 access), signature NOT ok. (appears a red X telling me that it can't find the file) c) any other client (not our ...

Counting frequency in unsorted data
hi...I'm looking for a function that will count frequency using multiple variables in an unsorted data set using two variables. I can get the information that I need by sorting the data and then using Data->Autofilter and using the countif function ti isolate the variables individual. However, this is problematic if the data gets re-sorted. Data example A B C XA GM 125 XC BA 34 XA GM 23 XC NY 19 XA GM (blank) I'm looking to count the number of occurrences of XA where the value of GM i...

Returns Issue pls help!
I have not been able to figure this out and i hope i am overlooking something small. My warehouse staff had done partial receipts of a po and on the last receipt then did it incorrectly. the po only has two line items but on the final packing slip the items had been listed inversley from the po. So this caused the warehouse staff to under recieve one item and over recieve the other but everytime i try to do a return i get an error The quantity returned can't exceed 0. This is the maximum available based on tthe item and receipt number. Please enter a smaller quantity to return....

Problems with New Users
Hi Everybody I have problem when I create a new user in Dynamics GP 8.0 and the user wants to enter in the system inmediately appears in the following message: A get/change operation on table 'SY_End_routines_Check_MSTR' failed accessing SQL Data. So I tried to delete but the users is blocking? Any suggestions about this? Regards, Jose G. What service pack level are you on? Go to Help > About Microsoft Dynamics GP. Que nivel de parche tienes? Ve a Ayuda > Acerca de Microsoft Dynamics GP. Best regards, -- MG.- Mariano Gomez, MIS, MCP, PMP Maximum Global Business, L...

Getting the tool tip text from a CToolBar
How can I get the tool tip text from a CToolBar? For instance, I want to get the 5th button tool tip text in the CToolBar. I understand about the ToolTipCtrl but can't find a away to get a single buttons text. Any help would be appreciated. thanks. "Jeremy R. Harner" <jrh04009@hotmail.com> schrieb im Newsbeitrag news:1d0511ec.0310151158.7b024e3d@posting.google.com... > How can I get the tool tip text from a CToolBar? For instance, I want > to get the 5th button tool tip text in the CToolBar. I understand > about the ToolTipCtrl but can't find a away to g...

How to transfer Outlook files to new user installation or file server?
I have created a new Windows XP account and I want to transfer the the Outlook email files from the old logins to the new login. I have copied the Outlook pst files from the old accounts folder to the new accounts folder, but when I open Outlook the mail contents are there but it seems that Outlook does not remember the old email account details. Is there a way to transfer the email accounts details as well? The previous email accounts are still there with the original mailboxes in the old logins, only the email account details not coming over. It appears that they are not stored with the...

Outlook sends mails in "Rich-Text" since SP2
Hi, I have problems with SP2! Since I have installed SP2, Outlook always sends mails in "Rich-Text" though in Outlook's options Tools --> Options --> Mail-Format is configured that new messages will be send in "Plain-Text". I figured out this behavior when I sent an email with an attachment to users who are using outlook express. All receipients told me that they have not received an attachment. Receipients of this mail which are using Outlook received the attachment. Below you can see a part of the header: This is a multi-part message in MIME format. ---...

Change Users AD Name
We installed CRM with a domain admin and would now like to change the AD entry for that user. We would like to know is there any CRM downstream hazzard in changing that administrator's user name in AD? Yes. Changing the AD login breaks the tie to AD as it looks at both the login name and the SID. There are a few options to fixing this, I remember seeing a KB article recently that outlined how to synch CRM up with this type of change. 1) Go into Deployment manager and expand User manager 2) Right click on the account in question and select Change Account 3) Choose a new AD accou...

HOW TO PASS THE VALUE TO CORRECT INPUT BOX ?
Hi, I am a new member in this group.. I have some dificulties in form's date input box. I am trying to get date from a calendar and there are two date input box. How do I pass the dates into respective input boxs. How do I check the cursor whether is in Textbox1 or Textbox2 ? Not quite clear on this. When a control is invoked (entered), the events for that control fire. So normally you would add code to the events for the specific control. So, the user would type into Textbox1 say, and you could code in the Change, Exit events, or any of the other events associated with ...

Need help with Alphanumeric Auto number combination
Access 2000. I need a to assign an Audit number that is alphanumeric and partially auto number and partially assigned by the user. Example: Audit Number: 01086AB07 The first two digits of 01 is the first audit, which will advance one number automatically for each audit (Textbox). The second, third and fourth digits are the julian date which will be set to default(Textbox). The fifth and sixth digits are assigned indicating a company name(Combobox) for selection by user. The last two digits are the year which will be set to default(Textbox). I need this alpanumeric sequence to en...

Dear God
I'm nearly going out of my mind trying to format a Mileage Log in Excel 2002. My needs are specific and don't seem to fit any of the ready-made templates out there. I need the day-numbers in a month (1-31) down the left-hand column. Excel (being written for nuclear physicists who don't appear to bother with such things) won't allow me just to enter numbers. Every number I type in those cells comes out as 0. I have tried formatting the cells to "Number" with no decimals, to no avail. (I am NOT going to write in every number in this Log as "1.0"...

Office 2008 doesn't install
Hi,<br> <br> when I tried to install it said it can't find software to install, just after choosing the install location. what's going on? I have office 2004 installed. problem solved - I had to change the system language to english before installing! ...

Error message when adding text to bar
-->Sorry, nothing happened when I hit the submit button, so I hit it again. sorry.<-- Microsoft Project 2000, I am trying to add text to the right of a bar in a Gantt Chart. Don't I select "Right", then scroll down and choose "Text1" change the text to what I want to say, and hit OK? When I do, I get a pop up that says "This value is not valid in this situation, Chick the field to see if it requires text, a date, or a number, and that you typed the information correctly. How do I do that? I thought I did... Thanks for your help. -...

paste special | values should work with merged cells
When you use past special | values, and try to paste a large bunch of data with merged cells into another sheet, it will not let you paste just the values. This requires un-merging the cells. The problem that I have with this, is that the error message makes NO sense. It says "This operation requires the merged cells to be identically sized". Well, guess what? They are!!! I just copied them in from another worksheet. I even used paste special | column widths to ensure that the were indeed the same size. I don't understand what the big deal is anyway? If Excel can ...

Conditional Formatting Formula Help Part 2
Hi, I am working on a conditional formatting formula that will refer to a different worksheet that the one it is in, I hope this can be done, so here's how the formula needs to be: in cell X2 of worksheet "10 DAY AVERAGES" I need a formula that tests cell W2 in worksheet "PASTE DATA" to see if it's greater than the 20 day average of cells W2 through D2 in worksheet "PASTE DATA", and if so I will program a certain highlighting color via conditional formatting, I would appreciate very much some help with this formula THANKS! -- RalphSE ---------------...

Excel file locked by user/process problem
Hi all, I need help! We have a shared Excel file on the network. The las person who worked on it on Saturday says he closed the file properl and everything was fine. However, today, Excel keeps saying that he' in it. I've asked him to reboot his computer. I've searched fo temporary files in the folder where the file resides. Still couldn' find anything. I tried deleting it with DOS and it still doesn't le me because it says "The file is in use." I don't care who's using i now. I just want to terminate the process and delete the file. I was going t...

hidden value in each cell or in each row in Excel
hi, I need to store a two information in one cell with one value as hidden ,kindly reply if any one know the way without creating hidden rows or columns or worksheet The need is to store two information in one cell,with one value in display ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ Using comments is one option. >-----Original Message----- >hi, > >I need to store a two information in one cell with one value as hidden >,kindly reply if any one kn...

Help! Can't boot even to safe mode. Can't re-install OS. 0xc000
Hi all, I'm hoping some experts are on the discussion group here because I am getting close to a dead end. I am trying to help a friend restore his Windows XP installation. It's a real doozie. He has a very expensive CAD program on it and wants to avoid at all costs wiping the hard drive clean and losing the program -- for which he has no installation software... (I know, that was a dumb thing to lose the installation software, but it's been my experience that it's all too common among the non-geek population...) --This is a Dell laptop, but there is no re...

Charting Text #2
Below sample data I am trying to chart but I'm not sure if Excel can do this. It is basically a record of animals (tags) and where they have been spotted. I am trying to create a chart (maybe a scatter) with Location and Month on the X & Y axis and the tag data to appear to show a sighting. I have created a work around using a pivot table but the person looking at this chart is not an Excel user and I want to keep it simple. Any suggestions? Location Month Tag NW Jan J33 NW June J34 SW May J33 SW June J35 E Oct J36 E Nov J35 W May J33 W Apr J34 Hi, Insert new blank columns ...

Chart data from text file
I have my x- and y- values as tab-separated values in a text file. There are many different files, so it is too cubersome to open them all convert them all to Excel. Is there any way I can create a chart that reads its data from a text file? On Sun, 16 Sep 2007, in microsoft.public.excel.charting, hmm <hmm@discussions.microsoft.com> said: >I have my x- and y- values as tab-separated values in a text file. There are >many different files, so it is too cubersome to open them all convert them >all to Excel. > >Is there any way I can create a chart that reads its data fr...

Formula help...
I need help in devising a formula that will subtract 100 hours from a specific date and time. For example, if I entered a date and time (1/20/04 @ 1140) I would like the formula to subtract the 100 hours and give me that date and time (1/16/04 @ 0740). Is that possible? If you enter your date and time as a real date and real time: 01/20/2004 11:40:00 You can just subtract the 100 hours (100/24 represents 100 hour) =a1-(100/24) and format as mm/dd/yyyy hh:mm:ss (or your favorite date/time format) 1 = 1 day = 24 hours. So 100/24 is really 4.167 days (or 100 hours). BB wrote: > &...

partner programs... need help..
Hi. I used to work on restaurant POS software, and try to work on MS RMS. I was looking at the MS partner programs, but couldn't find information about MS RMS reseller(or partner) program. So.. which partner program do I have to get in? Thanks guys.. First become a Registered Partner - you just have to sign up, there's no fee. Then you'll need to take an exam at a testing center to become certified to sell RMS Store Operations. If you want to sell Headquarters, there is an additional exam. Your first stop should be http://partner.microsoft.com - once you become a register...

HTTP_300 error when useing Active Sync, any clues would help
First I was recieveing an HTTP_500 certificate problem, but I got that straightened out by following this article http://support.microsoft.com/kb/817379/en-us, the option # 2. Now I get an HTTP_300 error. Any thoughts?? Hi Joe, What version of the server are you running? What platform are you running the server on? "Joe" wrote: > First I was recieveing an HTTP_500 certificate problem, but I got that > straightened out by following this article > http://support.microsoft.com/kb/817379/en-us, the option # 2. Now I get > an HTTP_300 error. Any thoughts?? > > ...