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

×

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
  • 75,797 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

  • 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

×

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:

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

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

3 Answers

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

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

Doctor PC
Doctor PC

Level 3 Expert

7733 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

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

Answer questions

Manuals & User Guides

Loading...