|
|
Help with array lookup and max by
DavidFarnsworth
Ladies and Gentlemen,
If someone would assist me in adding a max formula to this array without
adding any columns I would appreciate it...
|
|
1 |
47 |
|
|
Lookup Formula help by
DavidFarnsworth
Hello,
I have a formula that results with 2 rows of data spread across 9 columns.
The first row contains text. The second a value.
(Text Text Text Text ...
( 1 2)
|
|
10 |
125 |
|
|
|
|
0 |
213 |
|
|
|
|
2 |
72 |
|
|
|
|
1 |
68 |
|
|
|
|
3 |
73 |
|
|
copy info from another sheet by
Davidgg
I am using a column in sheet1 that I input the info, and I need that this
info go to
another sheet2 and then print it.
Return to sheet1
continue the...
|
December 18th, 2006 11:04 PM
by Davidgg
|
5 |
61 |
|
|
perform calculations in 2 sheets by
Davidgg
I have 2 sheets, in sheet1 I will be input info, and I need
that when I input for example :15, this appears in sheet2
sum the total and print it.
Next: Go to...
|
December 20th, 2006 04:39 PM
by Davidgg
|
0 |
62 |
|
|
|
|
2 |
47 |
|
|
Pls help me!! by
davidiew
Hallo there!
Pls refer to the attached file (01) Filename = "Auto Update".
How can I have my cell in "yellow" to show TEXT + sum of month
automaticlly while...
|
February 25th, 2004 09:02 AM
by Nicky
|
1 |
91 |
|
|
|
|
4 |
170 |
|
|
Help with lookup (vlookup) by
davidio
I have a work book with 2 sheets in.
One has a listing of drugs.
Drug
Abacavir Sulfate
Abelcet
Abilify
Aciphex
Actinex
|
|
1 |
65 |
|
|
|
|
1 |
63 |
|
|
Concatenate or not? by
DavidJ726
I need to take the contents of three cells and combine them to form a
telephone #, but when a number in cell begins with 0's, the concatenation
function...
|
|
4 |
93 |
|
|
Adding workdays as part of the equation by
DavidJ726
I'm trying to put together a simple schedule in Excel and need to calculate
x working days from a given date. So if cell A1 = the project start date,
and I...
|
|
2 |
53 |
|
|
|
April 7th, 2005 10:17 PM
by JB2K
|
4 |
151 |
|
|
Counting values containing part of a cell by
davidm
I have a list of dates and wish to count the number of times February
appears. If I search for a specific date such as 03 February 2005 I have no
problem but...
|
March 27th, 2005 12:17 PM
by davidm
|
3 |
73 |
|
|
Q. How can I change this date by
DavidM
Hi
I have some dates like this:Sunday, 10 September 2006
in my worksheet, I've tried to change the format in excel with no luck.
If they can be changed...
|
September 15th, 2006 03:53 PM
by Pete_UK
|
3 |
53 |
|
|
Can you color cells with Array Formula? by
davidm
If I have an assortment of odd and even values in range a1:j100, using
the Array formula* {=If(Mod(a1:j100,2),"",a1:j100)*} will clear out all
the odds,...
( 1 2)
|
|
10 |
219 |
|
|
Conditional formatting from Dates by
DavidM
Today's date will be manually entered in to a header cell.
The worksheet contains the dates that customers last purchased from me.
How can I change the colour...
|
|
3 |
136 |