|
|
Formula for week ending by
Nelix
Hi
I am putting together a time sheet to record working times from week to
week, I have a cell that contains the week ending date using the following...
|
April 10th, 2009 06:20 PM
by Bernd P
|
2 |
88 |
|
|
Will not give accurate totals. by
marsjune68
I can not get this to work right.
SHEET " Daily Totals"
col B
date total4 this come from Sheet "Jan" Col FO
1/1/09 0 **should be 0...
|
|
3 |
136 |
|
|
|
April 10th, 2009 05:41 PM
by shelly
|
0 |
100 |
|
|
|
|
1 |
79 |
|
|
|
|
3 |
73 |
|
|
formula by
Nikki
Level Low High
1 $140,000 $155,000
2 $125,000 $155,000
3 $115,000 $145,000
How do I get a formula to look up a salary of $130,000 within the low...
|
April 10th, 2009 03:01 PM
by Nikki
|
3 |
66 |
|
|
sum numbers in cell string array by
kookie
I need to summ the numeris value of a cell string. The input of the cell will
be alphanumeric and semicolon delimited.
Example:
A1 = GBR 4; FRA 5; USA...
|
April 10th, 2009 02:56 PM
by kookie
|
6 |
102 |
|
|
Goto last row of the sheet by
Elton Law[_2_]
Hi Expert,
My excel spreadsheet is different days by days.
Sometimes, it has 6552 rows. Sometime, it has 7744 rows .... etc ... etc ....
Except Control + End +...
|
|
3 |
61 |
|
|
Macro to insert lines by
Linda
I'm trying to write a marco to search for a certain value in column A. When
the value is found, I want to insert a blank line above it. Once this is
done,...
|
|
2 |
69 |
|
|
Tabulate Survey Results in Excel 2003 by
Stoshu K
I have a pile of survey results that I'd like to tabulate into one
spreadsheet. Some of the data in the surveys are numerical and some are
text. I’d like...
|
|
2 |
61 |
|
|
Looking for an ID number in a column by
Glenn
Hello,
I have created a worksheet that consists of 550 people. I would like to
configure a box where I put the person ID # in and the page moves to that...
|
|
1 |
63 |
|
|
sumif by
Raggy
I am trying to use sumif to work out the problem below using excel 2003.
Sheet 1
Col A Col B Col C
1 Oct 08 C Check ...
|
April 10th, 2009 01:39 PM
by Raggy
|
3 |
100 |
|
|
|
April 10th, 2009 01:02 PM
by error
|
10 |
145 |
|
|
|
April 10th, 2009 08:58 AM
by VCKW
|
2 |
170 |
|
|
sort function by
Life by the Ocean
unable to sort, sheet is not protected, sort icon is faint grey....
|
|
0 |
60 |
|
|
|
|
1 |
60 |
|
|
|
|
1 |
91 |
|
|
Average every x cells by
Wox
I am trying to average data in a column from every 4 cells together. For
example, if data is in column A, then average A1:A4, A5:8,... Then put the
results...
|
|
3 |
57 |
|
|
Multiple Logics to be looked at by
Sri Harsha[_2_]
I am preparing an estimates tool. I have 5 different products and each has 2
types of deliverables, RN and UG.
In a table we have estimates for each product...
|
|
2 |
60 |
|
|
Conditional formatting. by
owiek
I'm trying to conditionally format one cell depending on data entered into
another.
Ex;
a b c
1
2
If C1 = 100% ...
|
|
1 |
62 |