|
|
text to numbers by
Miked
Here's a weird one. I have a spreadsheet that was sent to me that contains
numbers as text containing dashes(-). Normally I can remove the dashes to
create a...
|
|
1 |
84 |
|
|
|
December 10th, 2008 11:26 PM
by Max
|
3 |
127 |
|
|
Find Highest Value for Each Record by
JG
Is there a way to filter for the highest value in a list of records?
For instance if I have the following table:
Column X Column Y
a 1
a 2
a 3
a 4
a 5
|
December 10th, 2008 11:11 PM
by JG
|
2 |
103 |
|
|
|
|
1 |
149 |
|
|
Date Format by
swilkins
I have formatted a cell for a date format and I've selected it to show
12/10/08 but when I type today's date as 121008 it shows 4/22/31! I've tried
this...
|
|
2 |
142 |
|
|
Stock Trends by
Dennis[_7_]
Hi,
I'm looking for a way to create a spreadsheet that will dynamically track
historical stock prices over time using a web data source; is there any way
to...
|
|
1 |
101 |
|
|
|
December 10th, 2008 10:46 PM
by keith
|
0 |
123 |
|
|
|
|
3 |
155 |
|
|
|
|
0 |
173 |
|
|
Performa by
The Captain[_3_]
I was wodering if I could get a free excel file that has a simple PERFORMA.
For instance, If I bought a motorcycle at $1,000 for $100 payment a month,
that...
|
December 10th, 2008 10:11 PM
by Bob I
|
2 |
231 |
|
|
Alternate Conditional Pattern as #'s Chg by
Ken
Excel2003 ...
I have a list of numbers which may repeat a random # of times.
The numbers are sorted in Ascending order.
Each time the number chgs I wish...
|
December 10th, 2008 09:17 PM
by T. Valko
|
5 |
213 |
|
|
Excel 2007 Data Connections by
Ric Lager
Does anyone know of a data connection available to pull quarterly investment
results from an internet source into Excel 2007?
I am looking for a solution...
|
|
0 |
128 |
|
|
Vlookup with time by
blueriver
I am trying to do a Vlookup using time. Whenever I reference the cell in the
formula that contains the time I want to look up, it converts the time into a...
|
|
1 |
121 |
|
|
Prompt to Save Message by
Adam O
When I close out of spreadsheets in Excel 2007, I am sometimes prompted with
the "Do you want to save" question, but sometimes I'm not. I want to have
this...
|
|
2 |
145 |
|
|
Timekeeping Question by
blueriver
I have about 65 worksheets in a workbook that record an employees
time/activities. A particular code is given per activity per line. Times
are calculated...
|
|
3 |
152 |
|
|
|
December 10th, 2008 08:08 PM
by Bob I
|
1 |
150 |
|
|
Chart with 2 Axis by
Paula
Hi, I have a chart which I am struggling with, I can usually do dual axis
charts but this wont let me. Below is the data I am trying to plot. I would
like...
|
|
4 |
142 |
|
|
copy & paste in excel by
Trish
When I copy & paste a formula in excel the formula copies but does not work.
eg.
=SUM(F16:F18) is copied from =SUM(E16:E18) but the total is the same as the...
|
|
1 |
141 |
|
|
|
December 10th, 2008 07:57 PM
by Ronda
|
0 |
142 |
|
|
Create a form button by
BB Ivan
I'm developing a macro to create buttons and want to feed the process with
variables for placement and size. I'm using this...
|
December 10th, 2008 07:54 PM
by BB Ivan
|
2 |
142 |