|
|
formula by
Julie
I need to make a formula that if any item in column E is equal to any of the
items in column A then the quantity in column F(beside the item in E) needs...
|
|
2 |
100 |
|
|
|
|
3 |
95 |
|
|
min in a subgroup by
SteveC
A variation of a multiple criteria lookup question, this time using the "max"
function:
Column A Column B Column C
Apples ...
|
|
9 |
106 |
|
|
|
|
4 |
85 |
|
|
Unable to update data from pivot table by
chedd via OfficeKB.com
Hi
I am designing a pivot table to give a monthly report and i have clicked the
box in table options to update to refresh on opening the spreadsheet, but
this...
|
August 8th, 2008 05:09 PM
by TSW632
|
1 |
106 |
|
|
Summation Operator by
Sapphy
Hi,
I'm trying to work out a way of getting Excel 2003 to answer
y=2i+1 when i=1 initially with a final value of 10.
y=(2x1+1)+(2x2+1)+...+(2x10+1)
I could...
|
|
3 |
103 |
|
|
Comparing Lists by
PAL
I am trying to find which items in Column B are missing from A (finding the
reverse would be helpful to; any in column A not in column b)
Column A has data...
|
|
2 |
70 |
|
|
|
|
0 |
94 |
|
|
match error by
Belinda7237
I am getting an error with my formula and wondering if its just punctuation?
=IF(ISNA(MATCH,(F14,'CAU - Maturing
Loans'!$F:$F,0,)""(INDEX('CAU - Maturing...
|
|
3 |
94 |
|
|
Enable Macro message by
ub
I had few macro in my sheet.
Now I have deleted all the macro's in my sheet
But still I get the message box to Enable or Disable macro when I open my...
|
August 8th, 2008 03:37 PM
by ub
|
2 |
106 |
|
|
|
August 8th, 2008 03:32 PM
by Spiky
|
5 |
100 |
|
|
Impact of many VLOOKUPs in a spreadsheet by
Chuck M
Hi - I have a financial data spreadsheet with hundreds of vlookups. As the
spreadsheet grows over time, is there any way of knowing what the resource
impact...
|
August 8th, 2008 03:19 PM
by Chuck M
|
2 |
81 |
|
|
Linking to a graph by
VoxBox-Richard
Hello,
How do I create a hyperlink to a graph sheet within Excel? I know to
create a link to different sheets but I can't link to graph? Can any one...
|
|
0 |
77 |
|
|
TYPE function by
Iriemon
I have the following formula but it is not gving me the results I am looking
for:
=IF(TYPE(VLOOKUP(V2,'thread...
|
August 8th, 2008 02:43 PM
by Iriemon
|
3 |
67 |
|
|
Help? by
Dylan
I can't get this formula to work, please...
|
|
3 |
70 |
|
|
|
August 8th, 2008 12:38 PM
by Dima
|
6 |
67 |
|
|
Lookup formula & an error to find the match by
Bahareh
Hello
I am trying to create a formula which can look up to find data on a raw and
returns the value on the same column on another raw. Here is the outline of...
|
August 8th, 2008 12:36 PM
by Bahareh
|
7 |
87 |
|
|
|
|
2 |
85 |
|
|
|
|
1 |
73 |
|
|
Drop down menu by
Mark E B
I figured out how to make a drop down menu. Now I want to add in more data
when I choose a certain item from my drop down. My sheet is for a meal...
|
|
1 |
95 |