Question about Microsoft Office Professional 2007 Full Version for PC

2 Answers

Excel Formula Help

Is there a formula that will find a mode of a series of text fields. ie the moste reoccuing text string in a list?

Posted by on

  • martaw Apr 23, 2008

    I need this to be more automated for forms that are going to be repeatadly filled out. this is not a one time occurance.

×

2 Answers

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

Tools funiton

Posted on Dec 07, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

Name the list as a range. Copy the list to a different location, eliminate duplicate values, then write the formula next to the newly listed items to count the number of occurrences in the original list range. Thanks for rating FixYa!

Posted on Apr 23, 2008

  • 3 more comments 
  • Cheryl Whalen Apr 24, 2008

    I will help you write the exact formula if you can give me some more definite information. For instance, is the list a relatively stable length? Are the choices for the text within the list limited to a certain number of words/phrases?



    For example, assuming the choices are going to be fairly stable, the copying suggested above would only have to be done once (to set the "choice" list for counting). Then, by naming the range in which the choices are to be counted, we can compare them to the specified values and count. Then, we put in a min/max type formula to give you a one-cell answer (if that is what we're aiming for...) I can certainly give you the formula if you can give me more info - I would like very much to get to FixYa!

  • Cheryl Whalen Apr 26, 2008

    If you are still having an issue with which I might assist, I would like to get to FixYa!

  • Cheryl Whalen Apr 27, 2008

    martaw:

    If you are still having an issue, I would like to get to help. If you could just give me some more information, as indicated earlier, we can work out formulas for you. As you know, mode is a numerical/mathematical term, but we can get a maximum count on text entries, I would just need to know a little more about what types of issues you face. Thanks, and I look forward to you feeling comfortable enough to rate this at FixYa!

  • Cheryl Whalen May 05, 2008

    martaw:

    Could you please take another look at the post here, and my attempts to provide you with further help? I responded in the best possible way to the original question, which did not indicate this was a recurring need, nor is it a one-phrase response with the need you have. I have offered several times, and continue to offer, additional help in reaching the exact formula you need, as I am an expert specifically in Excel and related functions and formulas. If your issue has been resolved, I would appreciate it very much if you could rerate the response, as all ratings are calculated in an expert's ranking and status, and I have provided not only valuable information, but also numerous attempts to continue to help if you have not found the best solution through the advice I have provided. If you still need help, please repost; otherwise, I would appreciate it if you would consider rerating the level of information provided in my response - hopefully it is at a FixYa! Thank you for your consideration.

  • Cheryl Whalen May 05, 2008

    I am back again even though I haven't heard back. The best way to do what you want is to create a pivot table that would count your various text entries. If you need help with this see http://office.microsoft.com/en-us/excel/....



    Then if you need the information returned to another place in the file regarding the one with the maximum count, it is quite easy to pull out the maximum value, using a getpivotdata formula. Again, if you need help with this please post back. Otherwise, please rate at FixYa!

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

What is the function of Microsoft excel?


Ok - if your question is "What is Excel" - then the answer is that it is a spreadsheet program that allows you the ability to compute data (usually numbers) for example, pulling together a list of hours worked by employees and adding them up automatically. It also can be used to develop sophisticated computational models and I have used it to develop professional services proposal sizing tools using formulas and functions ... which is a good segwey into my other answer.

If your question is "what is a function or formula in Excel" - then the answer is a function or formula in Excel is a collection of mathematical, text, statistical, etc. preprogrammed tools that allows you to manipulate the data you have in your spreadsheet e.g. a SUM() function that adds a series of numbers, and AVERAGE() funtion that computes the average of a series of numbers, etc.

Hope that helps!

Rgds

David

Oct 01, 2010 | Microsoft Office Excel 2007 Upgrade:...

Tip

HOW TO COUNT THE OCCURRENCES OF A TEXT STRING


In the cell that you want the result to appear in, enter the appropriate formula from the following examples.
How to Count the Occurrences of a Number
Use this formula
=SUM(IF(range=number,1,0))
where range is the range that you want to search, and number is the number that you want to count.
NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
How to Count the Occurrences of a Text String
Method 1
Use this formula
=SUM(IF(range="text",1,0))
where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).
NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
Method 2
Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula
=COUNTIF(range,"text")
where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).
NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.
Wildcard characters can be used within the COUNTIF function.
The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:
=COUNTIF(a1:a10,"*x*")
The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."
=COUNTIF(a1:a10,"?x*")

on Nov 11, 2013 | Microsoft Excel Computers & Internet

2 Answers

Sometimes when I use a formula in Excel 2003 it will not calculate - it is as if the formula does not exist. an additional problem is that when the formula works it will not calculate several columns if...


Make sure, when you entr a formula that you hit the ENTER key instead of just moving to tyour next cell. To have all numbers added or moved, use the"Special" application, or change the value. Such as -if you are working in text mode and you enter numbers, they are only numbers in text mode. They don't have a value. Correct the cells to reflect numbers. Right click, format cell - select what you want.

Nov 05, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

When I create a formula in a cell, hit enter, I get #VALUE. How do I get the actual result to appear, instead of #VALUE?


#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

2 Answers

Writing a formula for a sumif problem


Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

1 Answer

What is data series in microsoft excel


The data series the the string of data you would like to have included in a formula or charted on a graph. For example, if you have data in cells A1, A2, and A3 and would like this data to be included in your formula or chart, it would be designated as A1:A3, translated as A1 through A3. This can most easily be accomplished by highlighting the data when the software is asking for the data series.

Nov 18, 2008 | Microsoft Computers & Internet

1 Answer

Microsoft excel Formula


create a dummy column (columnC) containing columnA&columnB
use countif at columnD to count the number of observations per combination of columnA and columnB (in particular those with blank entries in columnB).

Sep 15, 2008 | Computers & Internet

2 Answers

Regarding Excel formulas


Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

1 Answer

How to find day of particular date in excel


First type in 31-Aug-1974 in Cell = C1
then in the calculation cell use this formula

=text(C1,"dddd")

this yields Saturday in text

Jul 29, 2008 | Microsoft Excel for PC

2 Answers

When I enter a formula in a cell with the the insert functon device, it does not calculate itself, but shows as text


Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

209 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18381 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...