|
|
repeating formula on calendar by
Anne Jo
I have a work calendar that is 6 days on, 3 days off throughout the year.
The first five days are 1830-0300 hours, the 6th day is 1830-0230 hours, then
3...
|
April 23rd, 2009 01:15 AM
by smartin
|
3 |
92 |
|
|
I want to tally my sheet by
Mr. Haney
Hi guys...
I am looking for advice as to which function(s) to use he
I have a sheet where I keep track of time put toward job tasks at work.
I look...
|
|
6 |
143 |
|
|
|
April 22nd, 2009 11:59 PM
by PJFry
|
1 |
74 |
|
|
|
April 22nd, 2009 11:16 PM
by sross
|
4 |
79 |
|
|
Drop Down List by
katiapro93
Hi, can anyone help
Is there anyway I can create a drop down list on a form using data that is
located in another workbook yet not have to open it everytime...
|
|
2 |
70 |
|
|
|
April 22nd, 2009 10:26 PM
by Steve
|
6 |
77 |
|
|
Vlookup questions by
Steve
Table (leftmost) must be in ascending order. Then is it correct that you
cannot use the same table to look for a different value in a different column...
|
April 22nd, 2009 09:44 PM
by Steve
|
4 |
208 |
|
|
Sumif based on criteria on another cell by
Jane
I am trying to add values in one column, if another column meets a certain
criteria.
This is the formula I have come up with and it doesnt work. Please...
|
|
3 |
101 |
|
|
|
April 22nd, 2009 09:29 PM
by Pam V
|
0 |
108 |
|
|
Drop down list from another worksheet by
Marysam67
I have created a drop down list from another workbook. When I pick a name
from the drop down list I want to list the location also listed in the
original...
|
|
0 |
71 |
|
|
Counting rows that meet multiple criteria by
sabow71
I have a strength report that generates counts based on multiple criteria.
The workbook has 2 sheets (Roster contains the personnel names and position...
|
April 22nd, 2009 09:20 PM
by sabow71
|
0 |
82 |
|
|
|
April 22nd, 2009 09:08 PM
by PJFry
|
7 |
115 |
|
|
Conditional Formatting Using Min/Max by
CE
Regarding Excel 2003, I want to indicate the min value in a non-contiguous
range of cells. The data are located in cells G8, K8, O8, S8, W8, AA8 and
each...
( 1 2)
|
|
10 |
140 |
|
|
EXCEL Pivot Table by
Tovok
I work in education for a major city, handling complaints.
My spreadsheet contains wellover 8000 lines of data, i need to isolate
schools with x number of...
|
April 22nd, 2009 08:44 PM
by Tovok
|
0 |
109 |
|
|
Worksheet is not calculating by
David
Hi There,
I have a worksheet using the following equation several hundred times. The
worksheet is about 700 rows and pulling from 2 worksheets in the same...
|
April 22nd, 2009 08:40 PM
by David
|
0 |
75 |
|
|
INDIRECT(ADDRESS) inside a VLOOKUP by
JG
Hey all... I hope this comes across ok. I have a utility that exports data
out to an Excel file (using Excel '03) via SQL statements. My query is fine
and...
( 1 2)
|
April 22nd, 2009 08:33 PM
by JG
|
13 |
211 |
|
|
vlookup??? by
Scott D[_2_]
I've studied a lot of post and can't find what i need so here goes. Forgive
me if i missed it somewhere.
sheet 1 contains the following data:
A ...
|
|
4 |
106 |
|
|
|
April 22nd, 2009 08:06 PM
by simon
|
18 |
160 |
|
|
Duplicate data entries by
Rich
What I am trying to accomplish is to copy all the duplicate data from one
worksheet to another. I have five columns and I want to have the data
transfered to...
|
|
1 |
74 |
|
|
What function do I use by
katiapro93
After I combined 2 columns to create 1 column that I can make a drop down
list from can I have the list display my combined data from the combined
column but...
|
|
0 |
66 |