|
|
Look-up a value within an interval by
Christine
I would be very grateful if someone could provide me with a formula that will
look up the closest minimum and maximum based on a value and bring back the...
( 1 2)
|
|
12 |
241 |
|
|
|
|
2 |
141 |
|
|
Populate a spreadsheet from a data set by
rev
I have a data set from access that I exported into Excel. Now I am trying to
write a formula that will summarize the data based 3 criterias
(appropriation,...
|
|
1 |
137 |
|
|
|
September 26th, 2008 04:58 PM
by T. Valko
|
5 |
242 |
|
|
Option Box protected errror by
Whois Clinton
I have option boxes from the "Forms" toolbar. On the sheet there are some
cells with formulas I would like protected. When I protect the sheet a
couple of...
|
|
0 |
133 |
|
|
protecting and unprotecting by
Fusion1337
I googled the group before posting, but I wasn't able to make any use
of what I found (my VBA-fu is still pretty feeble). Anyway, I was
wondering how to do the...
|
|
5 |
143 |
|
|
Calculating % by
Erica
I am trying to calculate the percent of budget used according to hours worked
and pay rate.
In order to calculate the hours worked i used the following...
|
September 26th, 2008 03:51 PM
by Erica
|
2 |
119 |
|
|
VLookUp - Questions - Spreadsheet setup by
Cpviv
Hi,
I need to setup a spreadsheet that has criterias go like this:
Cell A3 - Enter a key word. It will give me a list of the searched key words
(maybe...
|
September 26th, 2008 03:13 PM
by Spiky
|
3 |
138 |
|
|
Macro_AND function by
Aline
There is an formula I’d like to add it in a macro.
=IF(AND(L3="Y", M3="Y", N3="Y"), "Y", "N")
I want it to automatically fill up for the rest of row....
|
September 26th, 2008 03:10 PM
by Aline
|
1 |
111 |
|
|
Arrow keys when cells locked by
sam
Can anyone help. In a protected worksheet when the up or down arrow keys are
used the cursor moves to row 1 (if you use down it moves over one column; up...
|
|
1 |
113 |
|
|
Get data from specific collumn by
KT
Hi,
I have a date in sheet one cell A1. In sheet two I have monthly data. Now If
the date is 30/6/2008 I want data from June collumn and so on. Hope I\m...
|
September 26th, 2008 12:28 PM
by KT
|
4 |
125 |
|
|
SUM of a 3D calculation by
Werner Rohrmoser
Hi,
I have a book with Sheet1 through Sheet10.
On Sheet2 through Sheet10 there are numbers in cell "A1", "A2" and
"A3".
What I'd like to do is to calculate...
|
|
6 |
249 |
|
|
Average by
Alexey[_2_]
Hi
I have three cells O28,O29,O30. In cell O27 I want to display the average
of the other three cells, but only if they have values in them.
Not sure how to...
|
|
3 |
143 |
|
|
|
September 26th, 2008 11:30 AM
by John
|
2 |
121 |
|
|
XL2000 - Average/If/And Functions by
LPS
My Excel 2000 workbook has two sheets, the first (Evaluation Detail) contains
details about course evalutions per instructor. Column A is Course Name, B
and...
|
|
7 |
140 |
|
|
|
|
2 |
110 |
|
|
|
|
2 |
213 |
|
|
IF AND - need help with formula by
lsgKelly
I have to write a formula that accomplishes the following task:
I have a spreadsheet that has three columns. The columns are "Subs1"
"Subs2" and "RATE1"....
( 1 2)
|
|
10 |
182 |
|
|
Tracking how my bets are going by
Robbo
I have no idea how to use excel but have been told it will help me do what I
am asking(if that makes sense)
I bet on horseracing and want a sheet to
How much...
|
|
3 |
123 |
|
|
|
September 26th, 2008 06:59 AM
by liuyann
|
1 |
116 |