I need to sort 8300 email addresses by division which is indicated in the
later part of the email.  Any idead how I can do this?

I am using the following formula:
=VLOOKUP(ROW()-1,Formulas!$D$2:$BK$501,51,FALSE)
I'm trying to figure out a way to not hardcode the column letters and the
col_indx_num.  I have added two rows to each sheet with the information I

I am trying to get xl to look up a set of postalcodes, compare them with
another set and return a yes/no value.
Help please

A1 will be an incremented value from 1 to 3.
when A1=1, then C1 will be 1+1, D1 will be 1+2, E1 will be 1+3.
when A1=2, then C2 will be 2+1, D2 will be 2+2, E2 will be 2+3.
when A1=3, then C3 will be 3+1, D3 will be 3+2, E3 will be 3+3.

First, how exactly do you add comments to cells. I have a worksheet that has
some red tabs in the corner of the cell. When you drag over it displays a
comment. Also how do you scroll down to read the rest of the comment?
Thanks for your help.

I have recorded a macro, how do I stop it from showing all the steps I have
taken and simply run the macro?  Do I use DIM if sho what is the correct way
of doing so?

Good Afternoon
I have 2 columns one with a string of numbers and the other a number
1,-,-,-,-,-,-,-,-,-    247
-,2,-,-,-,-,-,-,-,-    34

I have created a table in Excel that lists various measurements of office
performance. I'd like to apply points for each level of value.
eg. if the value is <20% the score = 5 points; if it's >50% the score = 1
point...etc.

Using excel 2003.
Have column with date-time values. I have column formatting: "m/d/yyyy
hh:mm:ss.000".  Typical column displays "1/1/3018 00:12:03.930" in the cell
and displays "1/1/3018  12:12:04 AM" in formula bar.

Been racking my brains all day on this, I'm sure one of you clever
people out there can help me. I need to do a simple calculation based
on hourly rates, example as follows.
TA bills out at $20 an hour

I'm working on a Time Calculator for work.  On the time cards we have two
sets of In and Out on each card.  If as an example someone has clocked in at
6:00 and Clocked out at 14:00. That person has worked their 8 hours and as
they start to leave a truck shows up and they decide ...

We have created an excel file have 74 sheets which are interlinked to each
other. However whenever we try to add any additional sheets we are getting an
error “Too many different cell format"
Any ideas about this will help us a lot.

I would like to reference cells in different worksheets (up to 9) based on a
number entered in cell G6. Below, I am using nested IF statements for a
reference to only two different worksheets. If I insert enought nested IF's
for 9 different worksheets, this statement will become ...

Hello from Steve Dee
Below is on Sheet 1 would like a formula on Sheet 2
Ok I want a lookup please that would copy the data in Col C to Sheet 2
A              B                                            C

In VB, there is a way to specify a range to the bottom of filled cells:
....Range("A65536").End(xlUp).Address
Is there something like that in the worksheet functions?
I have a cell that has this command: