|
|
edate missing - still stumped by
Den
Thanks to the two helpful responses on how to get the EDATE function. I do
remember vaguely that that is where I had gotten it from before. BUT NOW,
how do...
|
August 3rd, 2008 08:30 PM
by Den
|
3 |
91 |
|
|
find and add vaules by
MLT
Is this possible?
Sheet 1
Column A = list of part numbers on each purchase order ( a part number will
show up many times)
Column H = In stock ready to...
|
|
1 |
93 |
|
|
Conditional Formatting in XL2007 by
Steve Haack
I have a table of numbers and I want to put a conditional formatting rule on
each column to highlight the lowest number in the column (there is a built in...
|
|
3 |
196 |
|
|
edate missing by
Den
I have reloaded Excel 2003, but it does not contain several of the functions
(eg EDATE) that I have used in previously saved worksheets. I believe that...
|
August 3rd, 2008 04:38 PM
by Mike H
|
4 |
100 |
|
|
Lock after entering by
bgkgmg
Cell B2 has the formula SUM(A1,A3). After entering data in A1 and A3 the sum
appears in B2. I would like to lock only B2 after data entry so it never...
|
|
1 |
145 |
|
|
|
|
2 |
137 |
|
|
|
|
2 |
101 |
|
|
Can a page number be displayed in a cell? by
jdwyer
I am trying to lookup a value in a different sheet, and insead of having
excel return specific values within that sheet, I would like for it to return
the...
|
|
1 |
102 |
|
|
filter in a filter by
Erik
Is there any way to run more than one filter from the drop down menu? I have
a large pivot table and am trying to create a filter, or set of filters to...
|
|
1 |
64 |
|
|
Using the if function in a formula, by
Nick
Im trying to create an IF forumla to tell excel to go to a different sheet in
my workbook if a cell value = 1.
How would I do this??
|
August 3rd, 2008 12:24 PM
by Mike H
|
1 |
80 |
|
|
|
|
2 |
85 |
|
|
SUM COUNTIF problem by
AD Carvajal
In the following spreadsheet, I need to count the number of times "y" appears
in the Guest column when B appears in the Site column. Is there any way to
do...
|
|
1 |
123 |
|
|
SumProduct CountIF issue by
JimG
I am trying to count the number of times the value "F" appears in column G,
if the value "HCSO" appears on the same row in column J. And I need it to...
|
|
5 |
113 |
|
|
|
|
1 |
93 |
|
|
Vacation Tracking by
NewAccessUser
I have 4 different groups that accrue vacation at various rates. I have set
up a table with each of these groups in one worksheet.
In a separate worksheet I...
|
|
1 |
64 |
|
|
|
|
3 |
119 |
|
|
Chart and date data by
Xaraam
Hey!!
I’ve been having some troubles with Excel 2003 (SP2) chart.
I’ve to do a chart which the x axis is date type data and in which the same
date has...
|
August 3rd, 2008 01:14 AM
by Xaraam
|
4 |
91 |
|
|
Copying and updating formulas by
dimitry
I have a workbook with mutiple sheets, each corresponding to a date. I
use a formula which is the
actual stock, based on the remainig of the previous. I...
|
|
1 |
77 |
|
|
Copying and updating formulas by
dimitry
I have a workbook with mutiple sheets, each corresponding to a date. I
use a formula which is the
actual stock, based on the remainig of the previous. I...
|
|
2 |
106 |
|
|
Copying and adjusting formulas by
dimitry
I have a workbook made of a lot of consecutive sheets( each one a date).
I use a formula
meaning my actual stock is the remaining o the previous. I am...
|
|
1 |
76 |