I have rows of text and figures that I need to separate into columns. Excel
2003 will only let me do one row at a time. Is there an add-on that will
allow me to convert multiple rows?
Thanks.

Hi,
I have a bit of a problem when counting values, for example on sheet 2 in
the A colum you are allowed to select a value from a drop down, what I want
on sheet 1 is to be able to count the number of each of these options e.g.

i just want to how can we subtract the highlighted ones from the total.
eg:
1256   sdkjfs
1236   dfsdf

I have a spreadsheet that has many rows of data.  I'm trying to get a
total for a column ("G") in a cell ("A2") but only on rows where the
cell in another column ("J") for that row is empty.I tried SUMIF and
couldn't get it to work.  Can this be done with some kind of formula?

Can anyone tell me the steps for importing data from a website into Excel
2003?  The data is made up of text and numbers.  Thanks.

I have two columns of dates.  The first column is the date the event
actually occurred or is 0 if nothing has been done yet.  The second column
is the target date by which the event should happen, the deadline.
I was able to create conditional formatting for the first column.  It ...

I'm new to Excel formulas, and I need one that is well beyond me at this
stage, but probably a piece of cake for an Excel Wizard. I have a modest
staffing schedule on Excel that shows several teams of employees with
staffing requirements that may change every thirty minutes, as ...

I have a set of cells that show the fraction of #complete/#total.  They
are formatted as fractions so that I can custom format them such that
those >=50% turn green and those <50% turn red.  The problem is that
for a completion of say 8/10, excel automatically simplifies to 4/5.

I have this formula
=IF(ISNA(VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE)) =TRUE,
"DONOR NOT VALID",VLOOKUP(A17,'Data-FSList'!GEAC2000IntlFSList,2,FALSE))
on cell B17.

My knowledge of Excel is somewhat limited, so I apologize if I am
asking an overly simple question here.
I am using Excel 2003, and what I'm trying to do is organize a table
of courses.  The master table currently exists on a single

Dear NG - My workbook has grown so large with worksheets that I find
myself spending a bunch of time scrolling through the list of
worksheet names looking for the sheet I'm after.  It would be really
handy if there was a way (and I think there is) to view all of the

A few months ago client requested I create an "Excel Database" by
which she meant an Excel list.  Recently she sent it back for help
because the insert row (the one with the asterisk) at the bottom
disappeared.  For the life of me I cannot figure out what the problem

I am having an issue using filters on a pivot table in Excel 2007. All
filtering options are disabled in the menus except for Value Filters

Ideally we will be doing this on an AS2005 Cube, but I can't get it to

I have a cell that has a formula to VLOOKUP another sheet.
I want to conditional format the cell to turn yellow when no value is
returned.
If the VLOOKUP has no value returned on the cell #N/A appears.  I tried to

I am working on a work schedule for a group of employees.  They are schedule
to work through a range of time.  For example, Mr. B works from 8 am to 5
PM, Mrs. C works from 10 am through 5 pm...ect.  The layout would be similar
to the one below