Question about Computers & Internet

# 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

×

• 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

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

• 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

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:

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

• 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

×

## 1 Suggested Answer

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

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### 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

### 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

### 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

### 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

### 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

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

### 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

### 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

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

## Open Questions:

#### Related Topics:

39 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert