Question about Microsoft Office Standard for PC

1 Answer

Using V llok up

Using look up to compare what figures are in one column to another and then identifying them

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 3 Answers

Here is the formula


using V llok up - d68560d.jpg

Posted on Apr 27, 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:

Tip

Getting the highest value in a column less than some other value


This is good really for SQL Server, Oracle, or anything that can handle SQL.

Most hacks know about MAX(), as in:

SELECT MAX(col_name) FROM table

So if the column has a max value in it of 10, you get 10 back. But what if you want the highest value in the column that is less than a certain amt.? This for example is good for getting back the next most recent record when col_name is an incrementing key column and you want to exclude the most recent record (ID'd by it having the current maximum value key) in the column. Now you are faced with writing an SP or egad, traversing a recordset client-side. Ugh.

Here's the fix:

SELECT MAX(col_name) FROM table WHERE col_name < {some_value}

This works. It works even when the key column is not guaranteed to have continuous sequential values, such as when records are added and deleted over time and the key values assigned all stay the same (which is what happens in 99.9999999+% of all cases).

Have fun.

Homework: Haven't tried it but I am betting you can also do this:

SELECT MAX(col_name) FROM table WHERE col_name < MAX(col_name)

Whoa... well, try it and see if it works. Some SQL interpreters don't like aggregation/sub-computational functions on the right side of the comparator. In that case, you'd get MAX(col_name) first with a simple SELECT stmt., assign it to a variable, then use that variable as the right hand side modifier for the '<' comparitor.

Seems simple, right? But oh, the pain these kinds of situations cause. Hope this helps some of y'alls.

on Mar 26, 2008 | Microsoft SQL Server Enterprise Edition...

1 Answer

I want to find out what is meaning of cell in microsoft excel 2007 windows.


The rectangular box identified by a unique letter - number combination. You would type your number or text into this box.

A cell is the intersection of one row and one column. (EXAMPLE: A1, which refers to the cell made by the intersection of Column A and row 1.)

Nov 09, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

I am trying to figure out a payroll formula. I


Here is how you could do the formula with two one column having the hours of each day in it and the overtime being in another cell:

Example:

Column A Column B
8
8
8
2
8
8
0
Total 40 OverTime 2

Formula in this cell where 40 is at:
=IF(SUM(A1:A7)>40,40,SUM(A1:A7))

Formula in cell where 2 is at:
=IF(A8>40,0,SUM(A1:A7)-A8)

Let me know if this helps.

Jan 01, 2010 | Microsoft Excel 2007 Home and Student...

1 Answer

Dear Sir, In case there are atleast 80 files or more having same format containing datas in columns in each file with different figures, I want to merge all file in a single sheet in one shot. Kindly...


Hi,

If the column names and orders are same across files, then you can directly use the MS Excel's import data function, this will do your job.

Alternatively, if you want to do it manually, import each file in separate excel worksheet using data import wizard or simple copy paste of data (in latter case you have to use Text-to-Col feature of excel), and then manually append all figures (copy-paste in one go) to any external excel sheet.

Then finally, export/save as that external sheet to any filename of your choice.

Hope this helps.

Thanks.

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

If statement that will change cell color in excel


conditional formatting is alright.

you just have to remove the $ signs in the cell reference when you set a condition.

then, copy-paste

Nov 20, 2008 | Microsoft Excel for PC

1 Answer

SUMIF formula


One in general should not use Find & Replace.
I would recommend always creating the first formula manually by selecting the cells. This will avoid common errors like extra spaces.

May 11, 2008 | Microsoft Excel for PC

2 Answers

Vlookup Syntax


Lookup,

I am not sure if Vlookup is the right function to use in this case.
A simpler approach may be to use an "IF" statement.

For example, with a data set:

A B 3 17 765 23 8645 45 43 87 634 635 34 31

Let assume you wanted to compare if A was greater than B and if true return B. If false return a 0.

=IF((A3-B3)>0,B3, 0)

The results would look like this:

A B Results 3 17 0 765 23 23 8645 45 45 43 87 0 634 635 0 34 31 31

Feb 27, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

Related Topics:

22 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2638 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

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