|
|
|
January 18th, 2005 09:24 PM
by Paul B
|
3 |
141 |
|
|
Large() with twist by
Dan
Hello,
I am interested in returning the name(s) of a product if it is one of the
top 5 money makers for the year. I believe the large() can return me the...
|
|
2 |
95 |
|
|
SUMIF FUNCTION by
Bel
For hourly employee, I need to add total hours for each day. But some day,
they are off. I put " off" in this case. The format like this:
A
1. 8
2. 3
3. OFF
4....
|
|
1 |
114 |
|
|
Weekly Transaction Processing by
Ralph Howarth
I have a download report in *.csv that I want to use MS Excel to convert into
another *.csv every week. The purpose is to prepare transactions for
importing...
|
|
4 |
885 |
|
|
|
|
2 |
151 |
|
|
Date conversion by
Gerrym
I want to convert a number i.e. 041006 into a date, having
formatted the new cell as date: dd/mm/yyy. When I use
the formula ...
|
|
3 |
183 |
|
|
|
January 19th, 2005 09:59 AM
by Max
|
3 |
646 |
|
|
Converting text to a number by
Helen Black
I am trying to do a sheet containing Holidays and Absence my problem is that if you only have a 1/2 day holiday my formula is counting it as a full day I need...
|
|
2 |
123 |
|
|
Count based on color by
John Kirschner
I need to use a formula that does a count based on font color. Is it
possible? And do you have an example I could see?
--
John Kirschner
|
January 19th, 2005 02:27 PM
by Ola
|
2 |
125 |
|
|
|
|
3 |
231 |
|
|
|
January 19th, 2005 03:23 PM
by Keith
|
4 |
212 |
|
|
|
|
3 |
109 |
|
|
SUM values between dates by
Qaspec
I have 2 columns D7:D36 and E7:36
Column D contains dates ie: 9/7/2004
Column E contains a value ie: 2
In another cell I would like to add the values for...
|
January 19th, 2005 03:45 PM
by JulieD
|
1 |
204 |
|
|
|
January 19th, 2005 04:12 PM
by JulieD
|
1 |
273 |
|
|
|
|
0 |
80 |
|
|
|
January 19th, 2005 08:17 PM
by Qaspec
|
3 |
86 |
|
|
Creating a Formala by
Jenn
Here's my scenerio:
Sheet 1 is the main page with all the information (a quotation with material
and price breakdown). In columns A & B data has to be entered...
|
January 19th, 2005 09:16 PM
by Jenn
|
2 |
89 |
|
|
Finding the maxium value of a column by
feman007
Hi,
Is there a way to find the maximum value of a column in Excel and then list
it along with the corresponding values in adjacent cells in the row? I know
it...
|
|
5 |
99 |
|
|
Sheet Names and Cell References by
Reed
Hi,
I am using the formula below and others like it to extract certain data from
a single workbook into several different workbooks. I have multiple sets...
|
|
1 |
196 |
|
|
LOOKUP and COUNTIF by
borris
hi all,
i wonder if anyone can help me with a formula i want to create.
in column A i have names of products, and in column B i have the date (sell
by date,...
|
|
5 |
110 |