|
|
Trouble with linset by
Confused
When I enter in linset and hit ctrl shift enter it still doesn't display the
information as an array, what is the problem?
|
|
1 |
148 |
|
|
|
|
1 |
116 |
|
|
|
|
4 |
124 |
|
|
I am stuck by
Ujpest
The numbers represent rounds.
So a name will go with a round (number) but some names know more than one
round.
Name a 1
name b 2
name c ...
|
March 6th, 2010 12:19 AM
by zvkmpw
|
1 |
128 |
|
|
How to format the phone number by
Michelle
Hi,
Can any one tell me how to get rid off the "-" at end of the data
(downloaded from SAP). The data I download from SAP look like this (203)
968-7273-. ...
|
|
2 |
126 |
|
|
|
|
5 |
182 |
|
|
Transpose multiple Columns to rows by
Michelle
Hi,
I know if I have few columns I can transpose it to rows by using the
function "Transpose". But if I have hundreds of columns that content the
same...
|
March 5th, 2010 10:55 PM
by Max
|
8 |
197 |
|
|
multiple calculations in 1 cell by
Pulling Hair
In cell C 13 is the quantity of units. In cell G 13 is the total cost. In
cell G 6 is the percent of overhead and in cell G 8 is the percent of profit.
I...
|
March 5th, 2010 10:41 PM
by Pete_UK
|
1 |
130 |
|
|
Confusing results by
Papa Jonah
In cells H15 and H36 I have 10/31/09 and 1/31/10 respectively.
In J 15 and J36 I have the following formula:
=DATE(YEAR(H15),MONTH(H15-DAY(H15))+2,)
...
|
|
5 |
173 |
|
|
|
|
2 |
127 |
|
|
VLook-Up Possibly Conditional Formatting by
C Kreig[_2_]
I am working on a spreadsheet that has three columns. A(Equipment
Description) C (Part Number) and AA (Price Each)
What I would like to be able to do is to...
|
|
1 |
160 |
|
|
Autofit height by
jdenegal
Why doesn't the autofit height in excel work properly ?
--
jpd414
|
|
1 |
170 |
|
|
|
|
1 |
130 |
|
|
changin date dd/mm/yy into Month by
Jo
I am trying to summarise dates from 01/04/09 to April. Can any body help.
I have tried = month(cell) , but it comes up with a value . Any ideas?
|
|
3 |
132 |
|
|
|
|
7 |
145 |
|
|
|
|
12 |
223 |
|
|
Calculate % from list of scores or ratings by
P. Hayes
I have eight responses to an evaluation that scored experience from 0 (worst)
to 10 (best). From the results posted below, I need to compute % of
responses...
|
|
3 |
96 |
|
|
help with input box by
Ken
I am using an Input box for my sheet to sort, I have 28 sorts and it is not
working. Can someone tell me if my code is incorrect. The sort works fine
when...
|
|
1 |
107 |
|
|
SUMPRODUCT Returning 0 or wrong totals by
Rbirdie
I have been trying to figure this out for 3 days.
I have 2 criterias that need to be met and then I want the total of a column.
I am trying to get a total of...
( 1 2)
|
March 5th, 2010 07:05 PM
by Rbirdie
|
11 |
241 |
|
|
#REF! by
Curtis[_6_]
Why is this giving me #REF! error
=INDEX('(312) - POS Pricelist'!$E$5:$E$8148,MATCH('Store Price
List'!$A4,'(312) - POS...
|
|
1 |
114 |