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

×

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

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

### Function

VLOOKUP is to Searches for a value in the leftmost column of a table, and then returns a value in the same row from a column you specify in the table. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find. The V in VLOOKUP stands for "Vertical." Syntax VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Lookup_value is the value to be found in the first column of the array. Lookup_value can be a value, a reference, or a text string. Table_array is the table of information in which data is looked up. Use a reference to a range or a range name, such as Database or List. If range_lookup is TRUE, the values in the first column of table_array must be placed in ascending order: ..., -2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise VLOOKUP may not give the correct value. If range_lookup is FALSE, table_array does not need to be sorted. You can put the values in ascending order by choosing the Sort command from the Data menu and selecting Ascending. The values in the first column of table_array can be text, numbers, or logical values. Uppercase and lowercase text are equivalent. Col_index_num is the column number in table_array from which the matching value must be returned. A col_index_num of 1 returns the value in the first column in table_array; a col_index_num of 2 returns the value in the second column in table_array, and so on. If col_index_num is less than 1, VLOOKUP returns the #VALUE! error value; if col_index_num is greater than the number of columns in table_array, VLOOKUP returns the #REF! error value. Range_lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match. If TRUE or omitted, an approximate match is returned. In other words, if an exact match is not found, the next largest value that is less than lookup_value is returned. If FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned. Remarks If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the largest value that is less than or equal to lookup_value. If lookup_value is smaller than the smallest value in the first column of table_array, VLOOKUP returns the #N/A error value. If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP returns the #N/A value.

Aug 30, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

39 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 3 Expert