I need to track 6000 tickets by intervals of 10. We are selling tickets and
signing them out in groups of 10, ex. 0001-0010, 0011-0020, etc. How can I
create a sign out sheet on excel and track the numbers without entering them
in manually which will take forever. There has to be ...

I have a list of journal entries that is missing some detail (Table
A).  IN Another table (Table B) I have the year's listing of journal
entries that contains this detail plus a lot more.  What formula can I
write in table A that will find the associated record in B (say based

in an excel database, there ais one column with multiple dates (some dates
are repeated) and another with related values.
How does one get a sum of related values for a user given date range?  What
about averages excluding those with zero values?

I am trying to create a master spreadsheet with the main sheet providing all
of the data.  I would like to copy information so as to display relevant data
on different sheets.  For instance, On one part of my master sheet, I have a
Houston section that provides sales figures that ...

I'm a beginner/intermediate user of Excel.  I don't know if what I'm trying
to do is even possible.
I have one worksheet that contains marketing expenditures.  Each row by
column has the following type of information: Vendor name, amount of invoice,

I am pasting SQL query output information from a web page (no http
address available) into excel 2003.  Each of the cells from the SQL
data is padded with a trailing LF (hex 0A) non-displayable "blank".
How do I remove these characters.  I've tried selecting alt-0010 and

How do I underline just 1 word in an Excel cell that is created by a formula?
for example, the formula could be: ="Please underline this word." and I want
to underline the word "Word".  The actual formula I am working with is
getting words from many other cells within the ...

I’m trying to create a formula that would give different outcomes to
determine if a product was new or not. I’m new to Excel, so I’m not sure how
to go about it. Can anyone help me please?
This is what I’m trying to figure out.

I have a list of over 6,000 email addresses that I imported into an excel
spreadsheet and the list has many, many blank rows.  I need to delete these
blank rows in one command rather than spend an hour going through and
selecting them one row at a time to delete.  Is there a ...

I am creating an attendance tracking worksheet, when someone calls out sick
they can use sicktime so they can get paid and they receive an occurence. I
need to be albe to enter a code for the event on the calendar, say "S" for
sick, and then have a totals section count 1 ...

I have done this function several times, yet today when I save a 2003 Excl WS
as Excel 2.1, I am losing 4251 records out of 20,635.  This has never
happened to me before today and I need the file to stay intact for a Fox Pro
application.  I have tried to paste in the missing ...

I have 2 sheets.  I would like Sheet 1 A1 to have a list from items in Sheet
2 A1:100.  The only problem is, Sheet2 A1:100 starts off blank until there
are items listed later.
For example, Sheet1 A1:100 "WILL" contain a list of cars.  This list will

How would I do the following?  Say cell B42 has a 7 in it.  So I then want to
reference this element of column A, therefore A7.  How would I do it?  
Effectively referencing A[B42].  Thanks in advance.

I'm fairly comfortable working within Excel; however, I just know there must
be a work-around for multiple nesting requirements that I probably simply
just do not know of.
Specifically, I am looking for either the correct argument/formula or

Hi--
I need some help converting data from multiple rows/columns into one
column.  My data looks like this (numbers starting on row 3):
BA                 BB             BC           BD           BE