|
|
|
|
3 |
130 |
|
|
List Functions by
Brooklyn
Is there anyway that the list function can be used withing Excel other than
in a spreadsheet ?
|
|
2 |
133 |
|
|
Equation Values by
RED
I am trying to calculate the days between two dates. I have used both
equations =a1-b1 and =days360(a1,b2) and both have worked in the first cell.
I need...
|
September 27th, 2008 04:40 AM
by RED
|
4 |
140 |
|
|
Automating transposition exercise by
Bob Matthews[_2_]
Hi there
I have a workbook with many worksheets - all set out in an identical manner.
I wish to combine the data in all the identical worksheets into one new...
|
|
2 |
148 |
|
|
|
|
1 |
124 |
|
|
Calculating MAX, MIN & AVG for each year by
dc059
I have a long list of data, from which I need to calculate the Maximum,
Minimum and Average values for each seperate year. The data spans many
years. An...
|
September 27th, 2008 02:23 AM
by dc059
|
2 |
138 |
|
|
|
September 27th, 2008 12:16 AM
by Pete_UK
|
3 |
149 |
|
|
Can't We Set Print Area with condition? by
Need Help on axis problem in a chart[_2_]
Hi,
I would like to set auto print area to an worksheet.
I have fixed width (number of columns), but length (number of rows with
values) changes, anywhere...
( 1 2)
|
|
10 |
243 |
|
|
Create Registration Form by
Di_W[_2_]
I work for a non-profit company in the education field. I need to create a
registration form for about 100 of our field staff who are located across the
US....
|
|
5 |
117 |
|
|
Sum last 13 cells in column by
vdubluv74
I am looking for a formula that calculates the last 13 numbers in a column
that are greater than 0. thanks
( 1 2)
|
|
13 |
329 |
|
|
Adding Columns if Criteria Met by
JD_Ottawa
I am using a spreadsheet with multiple colums for each period of a year and
having problems adding a Year To Date summary. See Below:
Period 1 Columns: ...
|
September 26th, 2008 10:00 PM
by IanC
|
1 |
134 |
|
|
Help with INDEX by
Joe Gieder
Thank you for your help with this.
I have this array formula:...
|
September 26th, 2008 09:39 PM
by T. Valko
|
1 |
105 |
|
|
EXCEL LOOKUP by
Wallace
my excel matrix is set up as such:
A1=BOB; A2=TIM; A3=BOB; A4=SUE; A5=JOHN; A6=BOB;
B1=100; B2=101; B3=102; B4=103; B5=104; B6=105;
D1=BOB;
Which function...
|
September 26th, 2008 09:06 PM
by T. Valko
|
4 |
111 |
|
|
Excel Multiple sheet updates by
Liz
What is the correct function to use in my macro if I have many sheets in my
workbook and I need to update them monthly. after I update them, I have the...
|
|
1 |
108 |
|
|
Excel VBA. Compare 2 worksheets. by
u473
I need to filter to a new workbook for exceptions of potential
mischarges, by comparing
a Table of Actual Charges Vs a Table of Allowed Charges by Employee
and...
|
|
3 |
135 |
|
|
If, if, if with & by
Steve
I need the results as either a 1, 2 or 3.
if the number is 200, I want a 1
If it's between 200 - 299, I want a 2, and if it's 300, I want a 3.
This formula...
|
|
6 |
109 |
|
|
Vlookup Data Split by
Atif
Hi
Data is split in two sheets, can I vlookup both sheet in single formula.
i.e.
Sheet 1 (half data)
Sheet 2 (half data)
Sheet 3 (vlookup)
Thanks
|
|
3 |
116 |
|
|
New Twist on Old Question-Averages by
LPS
Refresher: My Excel 2000 workbook has two sheets, the first (Evaluation
Detail) contains details about course evalutions per instructor. Column A is
Course...
|
September 26th, 2008 06:33 PM
by Pete_UK
|
4 |
86 |
|
|
protection by
Darrell_Sarrasin via OfficeKB.com
I have a page set up with groups
any way to use them and protection at the same time I am using 2003 excel.
--
Message posted via...
|
|
9 |
114 |
|
|
read only cell by
pdaws
Is there a macro that I can wright that would make a cell read only on a form
after date entry has been performed in the cell? The intent is to have the...
|
September 26th, 2008 06:23 PM
by pdaws
|
2 |
114 |