I have two excel workbooks, one including data on current employees and
one including data on terminated employees, both start with the
employee No in the first column, I would like to make a vlookup on both
files at the same time, so that for example when the employee # Im

I am trying to vlookup data in column X based on a particular month eg
December.
Is that possible?
Month    x    Data

So, here's something along the lines of what I'm trying to do:
for every row where column x says "foo" countif(y:y,"<100")
maybe it's something like countif(and(x:x="foo",y:y<100))
or maybe it's a whole other function.

I have one sheet called master list which is basically a customer list of:
custid, name, address, state, ...
On a different sheet I want to make a report that does something like:
State: <enter state>

How can I sum cells containg text?
I have a column of distances: 1km, 2 km, 3 km and I'd like to tally the
distances using a formula.
Thanks!

It has been a while since I have worked with functions in Excel.  I do not
remember the best way of designing a formula for this problem.  For a ball
and auction event, which raised about $100,000 for charity, each bidder (name)
was assigned a bidder number and table on one ...

I am having trouble trying to make a formula work.
what I am trying to do is this.  I have text in one cell ie Townsville,
Sydney, Brisbane.  If I have Brisbane in the cell then I need the worksheet
to take the value from an adjacent cell and *0.44%*50/25.  If the value of

I am creating a construction schedule: one row has each step and the columns
have the customers.  The data will be date driven.  I need a fixed number of
days to populate the schedule based on the user choosing one of 3 items
(A,B,C).  Each represents a type of job and each have ...

I have 13 worksheets (Jan. - Dec. and Total). The Total worksheet has 12
columns (Jan. - Dec.) Total!A1 = Jan!$A$1.  How can I copy the reference from
Total!A1 to Total!A2, Total!A3 all the way to Total!12 so that I get
Feb!$A$1, Mar!$A$1 thru Dec!$A$1???

I have a column that's supposed to be an address, but somehow got the
company name mixed in at the beginning:
123 Main Street
One Park Place

I have a column which has a variable number of comma delimited values in the
range of 11 to 56 in each cell. Is there a method or macro to count the
occurrences of each number in the column and either output the results to a
file or another worksheet?

I am facing a problem. I have a list of around 700 email addresses, in which
some are hyperlinked (mailto) and some are not. Now I wanted to know that is
there any function or any way to convert all of them into Mailto Hyperlinks
that when someone clicks on them links are opened ...

Here's the setup:
A1=Date Received (formatted m/d/yyyy hh:mm)
B2=Date Sent (formatted m/d/yyyy hh:mm)
C2=Turnaround Time

Is this possible?
I have a calender that runs horizontally. Below each date are a series
of empty cells into which I can insert items. Currently a cell near the
top displays 'TODAY' under today's date. I do this by using the =IF

I have a rather complex equation that I cannot solve with pen and paper. I
need to calculate x for a very large nr of variables, by entering r. Can I
type an equation in Excel so that it can solve it automatically? (I don't
want to use the goal seek 150 times!) The equation is: