|
|
Excel 2007: Vlookup Problem by
ocean mist[_2_]
I don't use Vlookup much and it's not working for me. I know it's user error
so can you tell me what I did wrong?
I have two worksheets in my file. In the...
|
|
5 |
120 |
|
|
|
January 8th, 2010 09:51 PM
by Rebecca
|
0 |
164 |
|
|
|
January 8th, 2010 09:34 PM
by Steve
|
8 |
121 |
|
|
calculating a minimum fee by
Jackie
I'm looking for a formula that will calculate the following information:
If 15% of the sum of a range of cells is less than $40.00 then the fee is
$40.00.
If...
|
January 8th, 2010 09:29 PM
by Jackie
|
3 |
169 |
|
|
If Then Help by
nabanco
Hi, how would I say:
if cell e1 is a positive number, then return "win". If cell e1 is a
negative number then return "looser".
Thank you
|
January 8th, 2010 09:11 PM
by nabanco
|
3 |
109 |
|
|
|
January 8th, 2010 08:26 PM
by Carmela
|
2 |
113 |
|
|
copy between workbooks by
Carmela
I am having a problem copying between workbooks. I usually just right click
on copy and then go to the new workbook and right click paste. However, the...
|
January 8th, 2010 08:24 PM
by Carmela
|
3 |
135 |
|
|
Cross Referencing by
misstrious
Apologies if this seems a simple question, but I am at a bit of a loss
on how to do it.
I have two lists of people with a many to many relationship Group...
|
January 8th, 2010 07:34 PM
by Basil
|
1 |
107 |
|
|
Need a formula by
Rob
I am hoping some genius out there can help me with a formula.
I want to do this…. First cell has total sales of 10,000, Second sell has
fees of 100. I...
|
January 8th, 2010 07:04 PM
by Eduardo
|
5 |
89 |
|
|
Lookup or an alternative by
CHerzog
I have several sheets and I am trying to pull data from the master to the
others, I have been trying to use the Lookup and IF function. But I cant
get the...
|
January 8th, 2010 06:34 PM
by CHerzog
|
2 |
92 |
|
|
|
January 8th, 2010 06:17 PM
by Meenie
|
4 |
116 |
|
|
Lookup/multiple by
Minerva
This is a small snapshot of what i have in 2 sheets:-
Department/Category/Place-----------(3 similar columns for both...
( 1 2)
|
|
13 |
166 |
|
|
|
|
2 |
119 |
|
|
Creating a Formula in Excel by
Rob
I am hoping some genius out there can help me with a formula.
I want to do this…. First cell has total sales of 10,000, Second sell has
fees of 100. I...
|
|
4 |
150 |
|
|
|
|
2 |
101 |
|
|
Formulas & Dates not working in .xls file by
AOA
I have recently converted to Excel 2007 and upon opening a .xls file in
compatibility mode, I find that no formulas work in the entire workbook, and
all of...
|
January 8th, 2010 04:25 PM
by Squeaky
|
1 |
127 |
|
|
Nested Conditional Functions by
DyingIsis
This may be simple for everyone else except for me.
I have a spreadsheet in which each column I can fill in one of three options
(N/A, Yes, No). This is done...
|
January 8th, 2010 03:52 PM
by Paul C
|
2 |
92 |
|
|
attach files by
ankurcma
Hi to all Elite Group members
some time queries and their solution posted here are not in good
format , its little bit confusing
I want to request all of you...
|
|
2 |
115 |
|
|
Refresh - F2 by
enna49
You are probably tired of this type of question, but here goes.
Is there any way to quickly go through a spreadsheet with the
F2 Enter (to refresh a cell) ...
|
|
1 |
118 |
|
|
Need to create rows from columns by
patc303
I have a spreadsheet that looks like this:
Name | item 1 | item 2 | item 3 (etc.)
I need to format it into:
Name | item 1
Name | item 2
Name | item 3
|
January 8th, 2010 01:59 PM
by Paul C
|
1 |
109 |