Question about Microsoft Excel for PC

1 Answer

Data sorting in Excel

I am entering names of people in a column serially. now i want to count the number of people with same name. please assist me at the earliest.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Habit-Forming:

    Visited the website for 3 consecutive days.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 115 Answers

If the serial numbers of all the names on the column are A1-A100.
and you want to count the no of people with a name that appears on A6.

use this

=COUNTIF(A1:A100,A6) function go(url) { window.open(AppendFromParamToUrl(url), "_self"); } function OpenInNewWindow(url) { window.open(AppendFromParamToUrl(url), "_blank"); } function AppendFromParamToUrl(url) { if (null != url) { url += (url.indexOf("?") > -1) ? "&from=" : "?from="; url += escape(window.location.href); } return url; } var L_UNDEFINED_TEXT = 'Help could not locate this inline definition.'; function InlineDefNotFound() { alert(L_UNDEFINED_TEXT); } function AppendPopup(oSource, sPopup) { InitializeGlobalData(); if (typeof(allDivsInPage) == 'undefined' || null == allDivsInPage) return; var theDiv = allDivsInPage['divInlineDef_' + sPopup]; if (typeof(theDiv) == 'undefined' || null == theDiv) { InlineDefNotFound(); return; } if (theDiv.style.display.toUpperCase() != 'INLINE') theDiv.style.display = 'inline'; else theDiv.style.display = 'none'; } var strAssetVersion = '0';var strGoDisplayCountOK = "Remaining characters: {0}";var fDisableCounter = false;var fDisableCounterFirst = true;var fWasLastCountOver = false;var fIsSimpleFeedbackWiz = false;var fIsOn2Lines = false;var strGoDisplayCountOver = 'You entered {0} characters. Please enter {1} or fewer characters.';var strGoDisplayCountOverStar = '* ';var strErrorCommentTooLong = 'The text you entered is too long. Please do not type more than 650 characters.';var iFeedbackWizStarRated = 0;var iRvasap = 0;var fFeedbackWizJustRated = false;var strYouAreNotOnlineErrMsg = 'You are not online.';var strPageAssetId = 'HP100704801033';var strFeedbackPageUrl = 'http://office.microsoft.com/assistance/fbk.aspx';var strPageLoggingParams = 'CTT=98&Origin=HP100704801033';var strCommentOnThisTemplateLnk = 'http://office.microsoft.com/en-gb/suggestions.aspx?AssetID=HP100704801033&Type=0&Rating=0';var strCannotSubmitFeedbackErrmsg = 'Your feedback could not be submitted.';var rgStrClickToRate = new Array(5);rgStrClickToRate[0] = 'Click to rate: 1 out of 5 stars';rgStrClickToRate[1] = 'Click to rate: 2 out of 5 stars';rgStrClickToRate[2] = 'Click to rate: 3 out of 5 stars';rgStrClickToRate[3] = 'Click to rate: 4 out of 5 stars';rgStrClickToRate[4] = 'Click to rate: 5 out of 5 stars';var rgStrYouRated = new Array(5);rgStrYouRated[0] = 'You rated: 1 out of 5 stars';rgStrYouRated[1] = 'You rated: 2 out of 5 stars';rgStrYouRated[2] = 'You rated: 3 out of 5 stars';rgStrYouRated[3] = 'You rated: 4 out of 5 stars';rgStrYouRated[4] = 'You rated: 5 out of 5 stars';

Posted on Jul 18, 2008

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:

1 Answer

How do I arrange a list of names in excell in alphabetical order?


Select the data range that you want to sort alphabetically.
Ensure that the active cell is in the column with the names you want to sort.
Hit the Sort Tool on the toolbar (its the one with an A, a Z and a down arrow on it - it's probably next to a Funnel)
Your data should now be sorted.

Aug 29, 2014 | Microsoft Excel for PC

1 Answer

Excel cell replacement


To have the contents of the cell change from something you input into something else, you would need to put in a macro using VBA. You'll need someone who knows VBA to help with that.

OR... It is a lot easier to get similar results, if you are ok with using a few more cells to do it. The item# will remain where it was entered, and the product name will have to go in a different cell. In that case, you can use a lookup formula.

To do this, lets say your item# is entered in cell 'Sheet1'!C1, and you want the product_name to display in cell 'Sheet1'!D1. On another sheet (lets say sheet2) In cells 'Sheet2'!A1:B5 input the item#'s in the first column (column A1:A5) and input the matching product-names in column B1:B5. This is your lookup data. This sheet can be hidden if you want In cell 'Sheet1'!D1, use a vlookup formula that will look at the item# and find a match in the list, and display the product name for you. =vlookup('Sheet1'!C1,'Sheet2'!$A$1:$B$5,2,false)
This will display N/A# if the number can't be found.

Feb 15, 2013 | Microsoft Excel for PC

1 Answer

When I try to merge my excel document with 250


Hi deloisr

It looks like you have chosen the wrong data file. Probably an earlier version of your data still present in some folder.
Check these
Do you have column headings for every column?
Make sure which folder contain the file? What exactly is the name?
When you are in the Microsoft word, make sure you select the correct data file for your mail merge. If you have selected the correct data file, when you attempt to insert the merge fields, there is no way, it give wrong field names.
The only reason you get the erong field names is because you have the wrong excel file for your data. Fix this problem first, then the rest will sort themselves out.
Have a good day.
luciana44

Nov 09, 2009 | Microsoft Computers & Internet

3 Answers

Transforming birthdates into year codes


Here is a solution that might work for you. Please be mindful that there are several different solutions that will achieve the same thing in Excel (I am assuming Excel is your software).

1) Make sure each column in your spreadsheet has a heading.

2) Highlight (select) the column of birthdays.

3) Choose Format from the menu bar.

4) Choose Cells... from the drop-down menu.

5) For the "category", choose Custom.

6) In the "type" box, type yyyy

7) Click OK and when you return to your spreadsheet, you will see only the years displayed. However, when you try to edit a cell, you will see that the entire birth date is stored and preserved.

8) Now, highlight the entire table

9) Then, choose Data from the menu bar

10) Choose Subtotals... from the drop-down menu

11) In the "At each change in" box, choose the name of the column with the birth dates

12) In the "Use function" box, choose Count

13) Leave all other choices at their defaults

14) Click OK, and you are done.

Using this method, you can continue to enter the data as you always have. In that way, the birth date info is never actually destroyed or converted. What you are doing is simply deciding what is displayed.

I hope this helps.

Aug 02, 2009 | Microsoft Office Excel 2007

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

Input data


If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

1 Answer

Lookup,s


If you can move your name column (C) to the first column, you could leverage the VLOOKUP formula pretty easily.
To do this, do the following:
1) Move the C Column to be the A Column, shifting all other columns to the right.
2) (optional) Insert a new row at the top of the sheet (to hold the formula & seach value)
3) Use A1 as your search field.
4) In A2, enter the following formula:
=VLOOKUP($A$1,$A$2:$C$6,3,)

Describing above parameters, in the formula:
$A$1 -> the search field (name your looking for).
$A$2:$C$6 -> The table/grid you wish to search and return values from. The left most column (A) must contain the values to be searched.
3 -> is the column number (A=1,B=2,C=3, etc) within the table/grid to return.

If you cannot make the name column your first (A) column, there are more complex ways to do this. For instance, create a new sheet which redisplays the info in the structure easier for this method, and perform the VLOOKUP on that data. Other options might exist in creating a complex formula that would get you what you want.
Also, if you can sort column A (names) it would find results faster, if your data set is large.

Feb 03, 2008 | Microsoft Excel for PC

2 Answers

Counting


If it isn't too big of a spreadsheet, you can sort it on the column which has the numbers in it, which will put all the 1's in the top of the stack and you can then select just the cells with 1's in them and Excel will count the number of cells that you currently have selected. The number will show up in the Name Box (above cell A1) as: R2 X C2 (for two rows and one column currently selected). Rows are horizontal and columns are vertical.

Jan 10, 2008 | Microsoft Excel for PC

1 Answer

Sorting within a column


This page covers how to manipulate columns when the data is formatted as "LastName, FirstName MiddleName"... I'm guessing you could just tweak it:
http://www.cpearson.com/excel/FirstLast.htm

This google group goes more in depth on the topic:
http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/49bf87ffdc31a9d3/954544ded2b2f620#954544ded2b2f620

Jan 04, 2008 | Computers & Internet

2 Answers

Duplicacy in excel sheet


Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel for PC Logo

1,335 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2635 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18331 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...