|
|
Keystroke for Formatting by
AMaxwell
Is there a keystroke for text wrap in a cell?
--
Anne Maxwell
Workman Nydegger
SLC, UT
|
|
1 |
88 |
|
|
|
|
1 |
74 |
|
|
|
August 18th, 2007 05:01 AM
by Max
|
5 |
104 |
|
|
Calculating the Median Price Sold by
AMB
Hello,
I am trying to find a reasonable way of calculating a median. I have a data
set that is about 20,000 lines long and it contains Quantity Sold and Unit...
|
August 22nd, 2008 09:37 PM
by AMB
|
3 |
64 |
|
|
|
June 11th, 2008 03:47 PM
by PCLIVE
|
2 |
74 |
|
|
copying formulas by
ambam
Probably a very simple question but... i use excel for bookkeeping and
therefore have sheets of jan to dec with formulas in certain cells to work
out VAT...
|
|
7 |
152 |
|
|
INSERT COMMENTS WONT SAVE by
AMBAZ
EVERYTIME I ENTER A COMMENT INTO A CELL AND PRESS SAVE ITS NOT THERE THE NEXT
I GO INTO THE FILE, I NEED TO KNOW WHAT WOULD BE CAUSING THIS TO HAPPEN SO I
CAN...
|
December 14th, 2005 03:57 AM
by AMBAZ
|
2 |
91 |
|
|
Countif within and if statement by
Amber
Good morning,
I have data that I am trying to do an embedded countif statement and I can
not get it to work.
I would like to say If the date is within the...
|
|
2 |
72 |
|
|
excel formating by
amber
How do I convert military time to reg on a spreed sheet?
|
|
2 |
58 |
|
|
Multi Function for Unique Numbers by
Amber
We run catalogs with special part numbers. I am trying to see how many
unique special part numbers I have as each day passes. Each of these part
numbers...
|
May 15th, 2007 09:56 PM
by Amber
|
4 |
51 |
|
|
"Begins with" by
Amber
How can I express the following within a function?
begins with
contains
ends with
( 1 2)
|
|
12 |
102 |
|
|
conditional format, day of month by
Amber
I have a column filled with sequential dates. Cell A41 will always be the
30th day of a month, cell A42 will be EITHER the 31st day of that month OR
the...
|
|
5 |
65 |
|
|
SumIf Function by
Amber
I have a spreadsheet that contains two columns, one is the date (m/yyyy
format) and the other contains cost associated with the date. I would like
to have a...
|
|
2 |
88 |
|
|
Pivot Table by
Amber
Every time I refresh my Pivot tables, Excel re-formats the Boarders on the
entire worksheet. The boarder pattern seems to be completely random. I have
gone...
|
February 21st, 2008 09:03 PM
by Amber
|
0 |
65 |
|
|
Sumproduct with 2 criteria. by
Amber
Good Morning,
I have an expression =SUMPRODUCT((MONTH('Raw Data 2008'!A2:A1528)=1)*('Raw
Data 2008'!B2:B1528"XIAPPLXRP110")) in which I would like to add...
|
|
4 |
112 |
|
|
Return cost with 2 criteria by
Amber
I have an excel spreadsheet with 2 sheets. I need to return a value based
off of 2 criteria.
Sample Data: First Sheet
A B ...
|
|
5 |
73 |
|
|
Help with Formula by
Amber
I have a graph built that automatically updates based on data that is
entered. One of the columns that is graphed, has a formula of =MIN(cell
#,500),...
|
June 8th, 2007 07:46 PM
by Amber
|
2 |
61 |
|
|
|
September 25th, 2007 02:52 PM
by Amber
|
3 |
79 |
|
|
Odd functionality by
Amber
I had submitted a previous question but it was getting confusing and I
believe head ing in the worng direction.
Here is the situation.
I have a document...
|
July 10th, 2007 10:12 PM
by Amber
|
4 |
89 |
|
|
Count items by day by
Amber
I have a list of data where I want to know, by day, how many time different
items occur.
I have tried several possibilities with no luck. I would like to...
|
October 23rd, 2007 04:40 PM
by Amber
|
5 |
57 |