Question about Microsoft Excel for PC

1 Answer

Excel Formulas! Hi, I have a column with the following data: Eg. A1=2007T3P; A2=2008T4HD; A3=2006T1D and so on. Now I want to count the number of "P", "HD" and "D". I just want it to take the character "P", "HD", "D' and ad it up for me, i,.e the number of times they appear. I have put in a string formul, but it takes "HD" and counts it three times for me. It takes it as "H", "D" and "HD". But I just want to take it as "HD" ...hope I have not confused you. Help in solving my problem is much appreciated. Thanks Candy:)

Posted by on

  • 1 more comment 
  • NicoleCurtis Sep 03, 2008

    Noted...with thanks:)

  • Tim Babcock
    Tim Babcock May 11, 2010

    I'll have to look this one up at work tomorrow.

  • Tim Babcock
    Tim Babcock May 11, 2010

    I'll have to look this one up at work tomorrow.

×

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Master
  • 2,794 Answers

Does the search formula help?

Posted on Sep 03, 2008

Ad

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 there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this 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.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Construct both an ungrouped and a grouped frequency distribution for the data given below: 139 130 128 134 140 139 136 130 136 128 138 137 134 128 127 136 140 132 141


Sorry to disappoint you but I will just give you directions to do it yourself.
Ungrouped
First sort the data in ascending order (from lowest to highest value)
Create a two-column table
In the first column enter a data value.
In the second column enter the frequency of a data item
Count how many times one particular data value appears in the set (how many repetitions). If it appears only once, its frequency is 1; twice, frequency 2, etc.
For each single (different) data value complete the frequency column.

Grouped
For grouped data representations you create classes: A class is just an interval of values, for example between [125, 130[
For each class interval you create, count how many data values fall within the interval. For the class given as example it will encompass all values between 125 and 129, It I counted correctly its frequency is 4.
Complete the frequency table for the class.

How many classes should you create? Usually this information is given to you. If not, create a moderate number of classes (4,5) It depends on the span of the distribution (highest value- lowest value). The intervals should have equal length. Read your instructions.

Sep 02, 2012 | Office Equipment & Supplies

2 Answers

How do I get a meter reading of number of copies?


Here you go.

  1. Press the [Reports] button on the Control Panel

    m15-console-report-but.jpg

  2. Press the [Up] or [Down] arrow until 'Systems Data' is displayed on the Display Screen.
  3. Press the [Enter] button.

    The System Data list will be printed with the following information:
    • Total Page Counts: Total number of pages printed
    • CRU Prints: Number of pages printed using the current Toner (Dry Ink) Cartridge
    • Replaced Toner Counts: Number of new Toner Cartridges installed in the machine
    • Replaced Drum Counts: Number of new Drum Cartridges installed in the machine
    • Current Drum Page Counts: Number of pages printed using the current Drum Cartridge
    • Platen Scan Page Counts: Number of pages scanned using the Document Glass
    • ADF Scan Page Counts: Number of pages scanned using the Automatic Document Feeder (ADF)

Feb 10, 2010 | Xerox WorkCentre M15i Laser Printer

2 Answers

Hi i need the code for one for all urc-7562 for my tv goodmans GTV42P3


Goodmans:
0036 0072 0037 0009
0264 0516 0179 0374
0487 0371 0499 0556
0343 0235 0035 0480
0217 0335

Oct 23, 2009 | One For All URC 7740 Remote Control

2 Answers

Count the number of open and closed order status per owner


My suggestion is to use a Pivot Table.  Follow these instructions:
Click on column A1 - then in the menu bar click DATA > Pivot Table and Pivot Chart Report.  

Click NEXT on step 1 of pivot table wizard.
For step two you will want to highlight all of the data on your sheet.  then click next.
Choose NEW WORKSHEET for step 3 of the pivot table wizard and click finish.
Once the Pivot Table sheet opens, drag the STATUS field into the top left corner of the pivot table view, where "drop column fields" and "drop row fields" meet.  Next drop another instance of the STATUS field into the "drop row fields here" column.  And lastly drop the OWNER field into the "drop column fields here" section.  You should now be viewing a report showing you exactly what you were looking for.
Regards,
Joe


May 07, 2009 | Microsoft Excel for PC

1 Answer

I have a column A with repetitive dates. Column B with repetitive names Example: 05/01/09 a 05/02/09 b 05/03/09 a 05/01/09 c 05/04/09 a 05/01/09 d 05/03/09 c I want to count how many a,b,c,... I have for...


Use 3 pivot tables, put a, b, and c in the row areas and "Count of a", "Count of b" and "Count of c" in the data sections. That will give you a count of each date for each column

Apr 28, 2009 | Microsoft Computers & Internet

1 Answer

Count with 2 or more criteria


Can you do this using a pivot table where columns B & C are Row Fields and Count of B&C is data fields.

Jan 17, 2009 | Microsoft Excel for PC

1 Answer

Excel formulas


{=max(if(category column = category in query, price data column))}

Nov 18, 2008 | Microsoft Excel for PC

2 Answers

LOOK UP AND ALLOCATE


Hi,
Could you write the column names from both the sheets seprately, and one data eg. that you need. It would be easier to understand the problem.


Thanks
Proton

Oct 17, 2008 | Microsoft Excel for PC

1 Answer

Excel Spreadsheet


It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

1 Answer

BASIC EXCEL FORMULA


Are you looking to solve any particular problem?--- because there are a huge number of possible formulas in Excel.

However, in my opinion, the most commonly needed ones are addition, subtraction, division, multiplication, and summing.

Suppose you have the following numbers typed into your Excel spreadsheet:

columns: A B C D
rows
1 20 3
2 10 4
3 15 2
4 1 2 3


Then suppose you type in the following formulas (in the D column):

columns: A B C D
rows
1 20 3 =A1+B1
2 10 4 =A2-B2
3 15 2 =A3*B2
4 1 2 3 =sum(A4:C4)


Then the following answers will appear in the D column:

columns: A B C D
rows
1 20 3 23
2 10 4 6
3 15 2 30
4 1 2 3 6

Sep 29, 2008 | Microsoft Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

53 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

3002 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Alun Cox

Level 3 Expert

2678 Answers

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

Answer questions

Manuals & User Guides

Loading...