|
|
will a function do this for me? by
quailwood
Does Microsoft Excel 2003 have a function which computes the value of a
variable involved in generating a desired solution? In other words, if one
needs for...
|
August 26th, 2009 03:08 AM
by Max
|
1 |
119 |
|
|
SUMIF with "OR" criteria by
SwtHapa8
Hello, I'm having an issue with an IF-THEN formula. In my situation, I'm
trying to say," If A1:A5
= CA or DE or NJ or NY or PA or WI, then sum B1:B5"
Can...
|
|
2 |
115 |
|
|
Matching dates to cells by
Donna[_5_]
Col A COL B Col C
DATES TRANS ADJ
4/06/07 A 1
4/07/09 C
4/06/07 A 1
4/25/09 C
4/03/09 A 2
4/09/02 C
4/25/09 ...
|
August 26th, 2009 02:14 AM
by Max
|
8 |
124 |
|
|
|
|
5 |
200 |
|
|
calculated fields in pivot tables by
Brad Autry
Hi,
I have a fairly simple pivot table whose rows consist of various job post
sources.
So, for my small example, let's say the rows...
|
|
1 |
120 |
|
|
Pivot Table Calculate Field by
Brad Autry
Hi,
I have a fairly simple pivot table whose rows consist of various job post
sources.
So, for my small example, let's say the rows...
|
|
1 |
127 |
|
|
|
|
1 |
109 |
|
|
|
|
1 |
112 |
|
|
Drop down list - color coding by
Sue
I have a spreadsheet and want my drop down list of names to be color coded. I
have the orginal list color coded and when I created my list, the color...
|
|
1 |
112 |
|
|
|
August 25th, 2009 10:59 PM
by FredK
|
0 |
112 |
|
|
Attendance formula for payroll please help by
Tia[_3_]
Hello,
I am working a attendance and payroll sheet i have one sheet
called "programm" that i update the date each month 30 or 31 days
every
working day is...
|
|
0 |
91 |
|
|
Attendance formula for payroll please help by
Tia[_3_]
Hello,
I am working a attendance and payroll sheet i have one sheet
called "programm" that i update the date each month 30 or 31 days
every
working day is...
|
|
0 |
95 |
|
|
Total Working hours If by
Tia[_3_]
Hella i am working a attendance and payroll sheet i have one sheet
called programm that i update the date each month 30 or 31 days every
working day is...
|
|
2 |
116 |
|
|
Is there a way... by
salgud[_3_]
to do this without going to VBA?
I track the Division vehicle for our group. Every 5,000 miles it needs an
oil change. I have a spreadsheet to track the...
|
|
5 |
116 |
|
|
Creating a function to auto hide rows by
Robert G.
Hello,
I want to have a function that will look for a value ( 1 or 0 ) and based on
that hide the current row. The value of "1", or "0" is being based off if...
|
|
1 |
92 |
|
|
|
|
4 |
84 |
|
|
Link to word document by
mx
Hello
I am trying to create a link in an excel sheet to a word document as follows:
...\project\test%20whatever%20Specification%20.doc#35
the link is fine...
|
August 25th, 2009 08:03 PM
by mx
|
0 |
88 |
|
|
Using a variable to point to a location by
John
I want to point to a name by its index number:
=NameSheet!D
The kind of formula I want to use is like this, only instead of the "12" I
want to use a...
|
August 25th, 2009 07:27 PM
by John
|
2 |
89 |
|
|
Formula for elapsed time by
Hookette
I have two cells with dates and time in them and I need to figure out elapsed
time. When it's within the same month C2-B2 works fine, if it's months apart...
|
|
3 |
117 |
|
|
Merging sheets by
mo773w
What is the best way to merge two sheets, deleting any dupicate row entries?
|
|
1 |
86 |