Question about Computers & Internet

2 Answers

Re: Microsoft Excel I have a list of numbers. Every number should have another exact match number. I want to see a list of numbers that do not have a match. What's the solution?

Posted by on

  • ritahill Sep 02, 2010

    The numbers were all in one row - not side by side.
    I figured out the answer already. I put in a simple COUNTIF formula and then sorted the countif.
    I would appreciate it if I did not have to pay for this, but I do appreciate your quick reply and promise to tell my friends about your website. Will I have to pay? Thanks. Rita

  • ritahill Sep 02, 2010

    I see that my debit card has already been charged. How do I reject your answer and get that charge removed. I think that is fair in this instance.

    Rita Hill

×

Ad

2 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Top Expert:

    An expert who has finished #1 on the weekly Top 10 Fixya Experts Leaderboard.

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

  • Computers & ... Master
  • 80,637 Answers

I am not really sure what u are asking here, if this is an accounting problem u have the wrong site.

Posted on Sep 02, 2010

Ad
  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 1,851 Answers

Assuming that the list is with direction from up to down with the first number at A1 cell and the list to compare with starts at B1. Click at the cell C1. Click at the function tool. Choose "all functions" and type EXACT. At the top of the cells type A1 and at the bottom type B1. The result for the first line is at the C1 by the meaning of TRUE (if matched) or FALSE (if not matched). Substitutionally you can just type at the C1 cell "=EXACT(A1;B1)" without the quotes. Go with the mouse at the lower right corner of C1 cell. Just at the state of cursor getting into cross drag the mouse all the way till the end of the list. You get the result for each line at the C cells. In case you want to hide the FALSE enable Automatic Filter and choose the TRUE.
Here is an example print screen:
Re:  Microsoft Excel
I have - 9bf9620.jpg

In case of a problem or clarification, don't hesitate to post me a reply before rejecting my answer.
If you are satisfied, accept my solution.

Thanks and regards
Stelios
direct FixYa link: http://www.fixya.com/users/technical114

Posted on Sep 02, 2010

  • Stelios
    Stelios Sep 02, 2010

    In case your think that my answer didn't help you, you might reject the answer. In my thought the answer is helpfull and in typed out in details for your problem.
    It's up on you to decide.

    Thanks and regards
    Stelios
    direct FixYa link:http://www.fixya.com/users/technical114

  • Stelios
    Stelios Sep 02, 2010

    Are you still looking for an answer?

    In case of a problem or clarification, don't hesitate to post me a reply before rejecting my answer.
    If you are satisfied, accept my solution.

    Thanks and regards
    Stelios
    direct FixYa link:http://www.fixya.com/users/technical114

×

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

4 Answers

Cannot open file. Error message reads: Excel cannot open


Use Excel Repair Toolbox is efficient corrupt XLSX file repair software, suitable for all data recovery activities, applied to Microsoft Excel documents.

For more: https://www.xlsxrepairtoolbox.com/

Aug 03, 2015 | Microsoft Excel for PC

2 Answers

IS THERE A FORMULA IN EXCEL THAT WILL HIGHLIGHT CELLS THAT MATCH A NUMERICAL INVENTORY LIST?


One way would be to create a colunn C and use the formula: =COUNTIF(B$2:B$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

Sep 16, 2014 | Microsoft Excel for PC

1 Answer

How do i select the lowest 3 numbers from a list of 4 numbers


type =MIN(B1:B4). if the 4 numbers is in the cell b1 to b4, else, name the cell number.

Nov 15, 2011 | Microsoft Excel for PC

2 Answers

How to fix"microsoft office excel


Exactly as it says, go to control panel, add-remove programs, Microsoft Office - change, but not uninstall. Have your CD ready, ask it to repair. Be ready to download lots of updates after it is finished from Windows Update.

Sep 12, 2011 | Microsoft Windows XP Professional

1 Answer

I have Microsoft Office 2007 which I purchased from Dell and installed late last year or earlier this year, however, the Excel keeps getting lost and I cannot open documents which I have done or received...


Use http://www.magicaljellybean.com/keyfinder/ to find the serial number. As for the corrupt Excel program, you may need to determine what exactly is the problem there.

Go to Start, All Programs, Microsoft Office and see if Excel is listed. If it is, then click on it to launch it. Does it open? If so, then go to where your excel spreadsheets are saved to (e.g. My Documents) then right click an Excel spreadsheet & click on "Open With". Select Choose Program. Select the Microsoft Excel. If Excel is not listed, click the browse button and browse to C:\Program Files\Microsoft Office\Office12. Click the Always use the selected program to open this type of file checkbox. Click OK

Nov 26, 2010 | Microsoft Windows XP Professional

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

2 Answers

How to use vlookup


you can a tutorial here.

please rate.

Feb 06, 2009 | Microsoft Excel for PC

1 Answer

Excel lookup - match index array


The best solution may be to re-define the named columns, or to add new names to multi-column arrays, then use the VLOOKUP function.
Note that the "indexed" named cells must be sorted by the index column.

Test (this is a 2 year old question)... Please ignore ths following. The plus symbol does not display.
Upper key plus symbol displays:
Right plus symbol on number pad displays:
[Shift] Right plus symbol on number pad displays:
[Alt] [4] [3] displays:
slash/slash/plus displays: //
slash/plus/slash displays: / /
Plus Plus Plus displays:
upper Plus Plus Plus displays:
Shift Right plus plus plus displays:

end of plus test.. thanks.

Dec 09, 2008 | Microsoft Excel for PC

1 Answer

What is vlookup & hlookup?


1024x768 Normal 0 false false false /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} These are Excel functions for Lookup tables. The purpose of Lookup tables is to bring a value to the table, find the closest (or exact) match, and then return another value.

An example is the federal income tax table. On your tax return you get your gross income and number of dependents, go to the Lookup table, and find your taxable income.

The V in VLOOKUP means that the table is vertical; HLOOKUP has a horizontal orientation.

If you use the Insert Function button in Excel and paste either function, the dialog box will explain each required field separately with examples.

Dec 02, 2008 | Microsoft Excel for PC

2 Answers

Excel - Automatically update invoice numbers


Yes but You need to tell your exact requirements eg. from where you would like to update your Invoice Template i.e from A Separate Database or from a Dropdown List etc

May 14, 2008 | Microsoft Excel 2000 Step by Step...

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

39 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18424 Answers

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

David Payne
David Payne

Level 3 Expert

14162 Answers

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

Answer questions

Manuals & User Guides

Loading...