|
|
Conditional Format by
Randy
I'm wanting to shade a cell if 2 conditions are true. They problem I am
having is that one of the cells uses the VLOOKUP function. I can get the cell
to...
|
April 14th, 2009 03:51 PM
by Randy
|
4 |
88 |
|
|
Drop Functions and Sorting by
dicko1
I am creating a report card for work performance. Right now I have
several worksheets that contain the different data that I combine onto
the report card...
|
|
2 |
118 |
|
|
|
April 14th, 2009 02:48 PM
by Ivan
|
3 |
90 |
|
|
Sum with New Cell Reference by
DOUG
I am designing a macro to link to a cell reference and to move the reference
two cells to the right in the following month. So, this month I the formula...
|
|
2 |
128 |
|
|
lookup function help by
alberson
I am having a problem with the formula below. I have a chart of
certifications listed by date which are due annually. I have a column
dedicated to list the...
|
|
2 |
92 |
|
|
|
April 14th, 2009 08:45 AM
by NZuser
|
3 |
83 |
|
|
separate lastname from firstname by
enrico via OfficeKB.com
if lastname and firstname is in one column, can you separate it into two
columns?
--
Message posted via http://www.officekb.com
|
April 14th, 2009 06:56 AM
by Kassie
|
3 |
80 |
|
|
help with data labels by
struggling student
I am new to using excel charts. i want to change the layout of the data
labels in a pie chart to show a percentage. I click on chart tools, data
layout,...
|
|
0 |
89 |
|
|
Area by
jai
Excel 2007 has a function Area I am not getting for which purpose this
function has been created. I have tried to find learning material from
internet also...
|
|
1 |
96 |
|
|
SUMPRODUCT by
M&M[_3_]
The Min column is the calculation of MIN(ABS(A1:C1)) by row. Now I need to
have a count by each column that the value is equal to the Min column. I
tried...
|
|
3 |
74 |
|
|
|
|
2 |
80 |
|
|
conditional formatting expiry dates by
mooty
Hi All,
I am trying to conditional format a spreadsheet that i have licence expiry
dates but want to flag these 30 days prior to expiry but also want the...
|
|
1 |
78 |
|
|
Excel Functions by
LNS
hi,
i have a worksheet as similar to the one below and i am trying to calculate
the minimum function and retrieve the corresponding column...
|
|
7 |
73 |
|
|
need formula help by
jjmore
my spreadsheet looks something like this: (i have about 12000 rows)
A B C D
date depth ...
|
|
2 |
80 |
|
|
Combo boxes and drop down lists by
Rosalie
I've added a combo box to a worksheet where I have some drop down lists so
that I can change the size of the font and the number of lines in the box.
I've...
|
April 14th, 2009 04:10 AM
by Rosalie
|
0 |
85 |
|
|
IF by
Susan
Hello,
Having problem using the IF function with dates.
If the date in cell A1 is from and including 4/1/2009 to 4/30/2209, the
result in B1 should be...
|
|
4 |
66 |
|
|
definite integral by
dmahn14
how to I enter a definite integral into a cell in Excel? I have a column of
equations that i need to get the definite integral of.
|
April 14th, 2009 03:59 AM
by dmahn14
|
0 |
90 |
|
|
Using dropdown in protected sheet by
veggies27
I am having trouble choosing items from a drop down list when my sheet is
protected. In the same file I have certain areas where this is not a problem
at...
|
|
2 |
77 |
|
|
Creating automated timeline by
Ruki
Trying to create an automated time line for a process (eg process starts on a
date, 5 days later step 2 happens, 3 days later step 3 happens, etc) but...
|
April 14th, 2009 02:52 AM
by Ruki
|
0 |
86 |
|
|
|
|
4 |
97 |