|
|
|
|
2 |
137 |
|
|
=IF(ISNA + VLOOKUP? by
GD
Hi, i have a lookup i'm currently using; "=VLOOKUP(A3, ELMAX, 2,)" I want to
expand this formula to include an IF(ISNA aspect as when the value being
looked...
|
|
4 |
118 |
|
|
|
October 9th, 2009 05:08 PM
by nsd
|
0 |
128 |
|
|
Pivot Table Calculation based on 2 columns by
Lost in Microbiology
Hello All,
I had created benign table, but of course, the powers at hand changed their
mind on their goals and have started asking questions that are...
|
|
3 |
131 |
|
|
Countif formula appearing in cell why? by
edju
I am trying to modify a coutif formula. It has worked up to this point. Now
when I try to add another +countif with another qualifier to it the result is...
|
October 9th, 2009 04:53 PM
by edju
|
3 |
140 |
|
|
microsoft office 2007 by
jon
i got a worker who does a lot of record in excel...she was recently updated
to 2007 office professional...on some records when she opens it up from a
..xls...
|
October 9th, 2009 04:52 PM
by jon
|
0 |
123 |
|
|
Code Execution Message by
canderson
When opening a spreadsheet in Excel 2003, I get a "Code execution has been interupted" message. I've been using this same spreadsheet for 3 years and I only...
|
October 9th, 2009 04:28 PM
by Joel
|
1 |
253 |
|
|
VBA ComboBox Text Color by
jlclyde
Is there a way to change the font color as it is loaded into a form on
a combobox? I have items that I am adding to a form and I want to
keep the font color...
|
|
3 |
115 |
|
|
Faint cell highlighting in Excel 2007 by
JimAA
I just upgraded to 2007 and am disappointed with the faint highlighting color
when dragging and selecting groups of cells. I just installed SP2 Office...
|
|
4 |
131 |
|
|
|
|
3 |
133 |
|
|
Pivot table by
WINDMILL
Would someone be able to tell me how to enter a calculation to subtract one
group from another in a pivot table, without having to modify the source data.
ex...
|
October 9th, 2009 04:09 PM
by Luke M
|
1 |
120 |
|
|
|
|
1 |
121 |
|
|
|
|
0 |
156 |
|
|
Pivot Table link/export by
javablood
I have a Pivot Table Report in Excel that is connected to a query in Access.
The query will either provide a zero (0) or another number based on a
condition....
|
|
0 |
172 |
|
|
minimize and maximize buttons missing by
KR4d
I opened an excel spreadshhet which didnt contain the minimize, maximize and
exit button? now all my sheets are like that the only way to close a sheet
is to...
|
October 9th, 2009 03:32 PM
by Dcalli
|
8 |
222 |
|
|
|
|
2 |
121 |
|
|
Using drop down lists by
supercalifragilisticexpialidosiuos
I have a drop down list of recipes. How can I set up the drop down list so
that when a recipe is selected, all the ingredents are listed in a separate
sheet?
|
|
2 |
127 |
|
|
Custom Toolbar by
Enyaw
Can I add a list of products into a drop down menu on a custom toolbar?
|
|
1 |
97 |
|
|
MAXIF / SUMPRODUCT?? by
Andrew Mackenzie
Hi All,
It would be very useful for me to be able to use SUMPRODUCT to get the
maximum and minimum values depending on type similar to using it instead...
|
|
1 |
105 |
|
|
|
October 9th, 2009 12:58 PM
by Susan
|
1 |
118 |