|
|
|
December 30th, 2009 07:56 PM
by Mike H
|
1 |
91 |
|
|
Sort unique data from a colum by
TR Young
I have a column (let's call it 'Column C') of data that represents part
numbers required to build an assembly. In Column C are multiple part
numbers, some...
|
December 30th, 2009 07:11 PM
by TR Young
|
2 |
106 |
|
|
UDF Function by
Mouimet
Hi,
I have many different long formulas and I need to name each of them
This way I will be able to say: Choose(A1, ATV,AVG,Unit)
If cell A1 = 2 the cell will...
|
|
1 |
91 |
|
|
Averageif year=2000 by
MitzDriver
In column A i have settledate "01/02/2000", thru todays date. In column B, I
have the price "195600", etc.
A B
settledate ...
|
|
5 |
201 |
|
|
|
December 30th, 2009 05:55 PM
by T. Valko
|
5 |
152 |
|
|
Tricky Macro Question by
Philip
I created a worksheet that consists of multiple fields of data (the columns
are ie. date, point of contact, completion date, etc) and based on the inputs...
|
December 30th, 2009 05:40 PM
by Philip
|
4 |
136 |
|
|
adding numbers in a column with dates by
piklelila
I have a column with dates and numbers. I want to add up the numbers at the
bottom of the column. For example:
A1 11/15
A2 33
A3 11/20
A4 45
A5 11/24
A6...
|
|
5 |
144 |
|
|
COUNTIF? by
AAA1986
Each entry in my database has a category listed in column A. I would like to
create a column that produces the n for each entry's category.
For example, if...
|
|
6 |
105 |
|
|
|
|
3 |
110 |
|
|
|
|
3 |
98 |
|
|
|
December 30th, 2009 01:39 PM
by Stefi
|
2 |
131 |
|
|
Add one by
GillianX
Hi,
This is probably really really easy (I hope)...
I have a column which starts like this:
P1001
P1002
P1003
P1004
|
December 30th, 2009 11:00 AM
by Mike H
|
4 |
76 |
|
|
Format date by
MAX
Hello
I'm working on excel 2007 and I have a workbook with 15 sheets. The problem
is that the dates are all in English US and I want them in English UK. What...
|
December 30th, 2009 10:37 AM
by MAX
|
3 |
95 |
|
|
offset formula by
vmohan1978
IN CELL
B1 MY INPUT VALUE VARIES FROM 1-30
IN E1 MY INPUT WILL BE AMOUNT IT VARIES ASSUME 300000.
i WANT FORMULA IN A5 TO SHOW 0 AND A6 AS 1 SO ON TILL I GET...
|
December 30th, 2009 09:32 AM
by Max
|
3 |
96 |
|
|
Auto filter custom filter by
stevefromnaki
Hi,
I have applied an autofilter to my data. I want to do a custom filter from
there.
My data is as follows:
100
110
120
200
|
|
2 |
97 |
|
|
a if calculation help by
FredDave
Hi all i have a if calculation which i need to expand but I can't figure it
out
=IF(AND(D21=1,D21=7),"week",IF(AND(D21=8,D21=15),"2 wks","3 wks"))
I...
|
|
2 |
81 |
|
|
Good example of the use of Vlookup by
TheQuickBrownFox
This sheet has a lot of vlookups and uses a lot of named ranges.
It has current stats filled in up through week 16 of the current...
|
|
0 |
89 |
|
|
|
|
1 |
101 |
|
|
|
December 30th, 2009 01:22 AM
by Max
|
1 |
98 |
|
|
concatenate within an excel formula by
sarah - northampton
I am trying to concatenate cells and have the result execute within a
formula. I am ending up with: =sheet4!A2 instead of the value that is
contained...
|
December 30th, 2009 12:51 AM
by Max
|
3 |
100 |