|
|
Time Format to Text Output - A Tough One ! by
John Calder
Hi
I run Excel 2K
I have a series of times that I download from the mainframe. (these are in a
date format)
EXAMPLE
23/09/2009 6:07:00 AM
22/09/2009 ...
|
|
4 |
187 |
|
|
Formula required for matching cells by
daviebutton
Hi
On sheet 2 I have a 13 digit code in Col A, the description in Col B and the
price in Col C, these will be constantly added to manually.
On sheet 1 I...
|
September 24th, 2009 12:07 AM
by Max
|
2 |
180 |
|
|
help with columns by
mike
i need to know how to make a column of cells increase in number from 1 - what
ever so i dont have to keep going from cell dropdown to next cell and so on.
|
|
1 |
181 |
|
|
|
|
4 |
226 |
|
|
Local OLAP cubes in Excel/MS Query by
IgorM[_2_]
Hi
Can someone please recommend some good book or web page about creating local
OLAP cubes using MS Query. I have some data in Access that I want to work...
|
|
3 |
189 |
|
|
|
|
5 |
229 |
|
|
|
|
3 |
189 |
|
|
|
September 23rd, 2009 12:56 PM
by Eduardo
|
1 |
303 |
|
|
|
|
1 |
153 |
|
|
Excel 2007 Sheet with rows more than 15000 by
Hemant
While working with excel sheets having rows more than 15000 lines, sometimes
I observe that the processing is slowed down if data more than 15000 lines is...
|
September 22nd, 2009 07:47 PM
by JLatham
|
3 |
159 |
|
|
|
|
2 |
226 |
|
|
formulas by
leeammatt
I need to add up cities and i cannot for the life of me figure out how to get
the cities added in a formula. PLEASE HELP ME . thank you
|
September 22nd, 2009 03:21 PM
by Eduardo
|
1 |
150 |
|
|
|
|
4 |
217 |
|
|
MS Excel 2000 - Compare two lists of data. by
Jerry
I have two different files, both use the same unique identifiers. How can I
ascertain which records are missing from the smaller file.
For example:
File A,...
|
September 22nd, 2009 06:58 AM
by Max
|
3 |
219 |
|
|
|
|
1 |
178 |
|
|
display columns alphabetically by
Grocer
Columns used to display alphabetically left to right. It changed to now
displaying numerically left to right. How do I change back to alphabetically?
|
September 21st, 2009 06:51 PM
by Grocer
|
0 |
173 |
|
|
How do you make Pareto diagrams by
Person
For example for a chart like this:
Procedural and diagnostic code.....40 (Frequency)
Provider information....9 (Frequency)
Others .....4 (Frequency)
I know...
|
September 21st, 2009 01:00 PM
by JLatham
|
1 |
272 |
|
|
Best way to set up Excel customer list? by
Pianotech
Hi all, I'm new to Excel, having used MS Works for a customer list/database
for many years. I'm trying to decide whether it would be best to have:
1. A...
|
|
5 |
223 |
|
|
|
September 21st, 2009 09:28 AM
by Stefi
|
1 |
216 |
|
|
|
|
1 |
180 |