I have a database some 10 columns wide and 1200 rows deep. When I sort by
one particular column it sorts BLANKS before text meaning that the data
appears at the bottom of the database although still in alphabetical order.
I have the formatting set to GENERAL for the whole column ...

hi guys, can anyone help me out?
when i select line option in charts, excel keeps drawing a chart with
two lines. what i really want is to plot $ as my y axis and t as my x
axis (in example below). how do i do it?

My data looks like this
ID                   Date                      CWA
Amount
1                    08/12/2006             0

Is it possible to put a limit on the columns/rows that can be scrolled
to when splitting the window into panes? This way the column/row labels
can be visible when you scroll through the main data area, but you
can't accidentally scroll into the labels from the main area, or the

I have an excel worksheet with a street name column.  I need to
rename some names from "Main Street" to "Main St".  I can do it for one
name easily with find and replace, but how do I make it work for an
entire column of different names such as "Easy Street" and "Main

I have a table with "x" in some squares.  Below the columns, I put
=COUNTA(B3:B17, "x") to count the non-blank cells containing "x".  But the
formula in every instance is returning one more than the actual count - if
there are 2 x's, I get 3; if there are 5, I get 6, etc.  Can ...

Hi, I have all the English football league results from 1890 to present day.
The data is in the format "20010821","P","home team ","1","away team ","0"
---- Date,Div,Hteam,Score,Ateam,Score.
I have for a long time wanted to use excel to format league tables for any

My csv file is delimited by commas and text is delimited by ".  My file
considers carriage returns and next line characters enclosed in " as
text.    I am facing a problem when trying to open this file in excel.
The excel doesn't care that next line character enclosed by " and

Seemingly random temp files are appearing in a directory where I maintain
three excel files that are accessed by multiple users.
I have three excel files stored in a single directory on my company's
network. The files are accessed by Store Managers through our VPN via Citrix.

At any time I would need to enter the three values
I have to solve for the fourth.
When I have Margin, Index and rate I will need teaser.
When I have Teaser, Index, and Rate I will need Margin.

I have a couple sheets in Excel that have information as follows:
Table 1
Req || Req Date
A01 || 01/11/06

First, this is my first post, I don't know if this one has been aske
already and please point that earlier topic out if necessary or move m
post to where it belongs. Thank you.
How can I count a sum of lowest five filled cells automatically, s

I'm trying to help my wife with simplifying her scheduling of
employees.  She uses 11 different time periods (1-11) some
are worth the same amount of hours others are more or less.  I can use
seven functions to describe the period and the

Is there an easier way for splitting a workbook into 2 smaller workbooks
than copying the workbook to 2 separate files and deleting the appropriate
worksheets from each?  Thanks in advance.

Sheet 1 below:
A13 is a lookup from Sheet 2.  I want the cell B13 to take this value and
lookup the column 1 and enter the value into B:13.
=LOOKUP(A13,A2:B11)  but get this #N/A?  What am I doing wrong?