anouncing that it is time for paiment
Mon, 11 Aug 2008 23:38:04 -0700
I have clients that I am intruducing starting with a date. After exactly
10 days, I have to pay them some money. I would like to be notified by
changing colour of the their rows, and not changing back until I complete the
cell of paiment, that is, of course, in the same row. Is it possible to do
this in E ...
|
formula to convert 15 minute to hourly data
Mon, 11 Aug 2008 17:24:07 -0700
I need a formula to convert 15 minute timestep data to hourly average (an
average of the four 15 minute data points for the hour).
My spreadsheet looks like this:
datetime in first cell data in second cell
1/1/00 00:00 2.2
1/1/00 00:15 2.0
1/1/00 00:30 1.9
1/1/00 00:45 2.0
1/1/00 01:00 2.4
1/1/00 01:15 ...
|
How do I tackle this problem?
Mon, 11 Aug 2008 14:11:01 -0700
Using Excel07 ... I've got several thousands of lines like so:
A B C
row1 joe blah1 date1
row2 date2
row3 bob blah2 date1
row4 date2
i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and
so on ...
...
|
How do I get the lowest number in a row to turn red in Excel ?
Mon, 11 Aug 2008 12:28:48 -0700
Using Excel 2003. I can use the min function to find the lowest number in a
row but how do I get the lowest number in a row (or column) to change colour
so that it stands out?
Any help would be greatly appreciated. ...
|
Posible IF formula
Mon, 11 Aug 2008 09:05:18 -0700
A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can
I write a formula for this. ...
|
VLOOKUP
Mon, 11 Aug 2008 04:24:00 -0700
Hi,
I was trying to use VLOOKUP, to check whether the data for employees in the
1st worksheet exists in the 2nd sheet as well.
I realise that when I drag the formula to ensure that the same formula can
be used for all the rows below, the formula tends to change the table array
destination also along with ...
|
SumProduct problem
Mon, 11 Aug 2008 14:57:55 +0800
Hello,
One of the ranges I use in my sumproduct formula includes cells with formula
like
=IF(A1=0, "", A1)
The sumproduct returns a #VALUE! error whenever the cell A1 is 0, otherwise
it works fine.
How to deal with the problem by modifying the sumproduct ?
(The formula IF(A1=0, "", A1) is fixed and ...
|
|
|
Freezing Panes
Sun, 10 Aug 2008 22:31:01 -0700
How can I freeze two different rows in a single sheet.
--
Naidu ...
|
Paid bills notice
Sun, 10 Aug 2008 11:27:01 -0700
I would like to be notified when a payment is due the day before and then I
would like to be able to check that payment "Paid" when it's done. How do I
do this? ...
|
acheter propecia canada bon marche dans commande propecia canada corpus eurodrugs.org Achat propecia canada Simple Achetez Le propecia
Sat, 09 Aug 2008 16:12:12 -0700
acheter propecia canada bon marche dans commande propecia canada corpus eurodrugs.org Achat propecia canada Simple Achetez Le propecia
+++ SANTE MASCULINE +++ SANTE MASCULINE +++ SANTE MASCULINE +++
+
ACHETER VIAGRA BON MARCHE (ALL CARDS ACCEPTED !!!)
http://jhku.net/ACHETER-VIAGRA-BON-MARCHE/
http://jhku.ne ...
|
