if my series is a2b, a3b, a4b, a5b how do i use excel to fill the rest a6b
a7b and not repeat a2b a3b
thanks
jared

I work with alot of names, ID numbers, and text in Excel. Three TEXT
functions I would find handy would be:
NameFirst(cell,format)
NameLast(cell,format,criteria)

If my cells are a2b, a3b, a4b a5b how do i make excel coplete a6b a7b and not
start with a2b?

I'm trying to generate a color-background format result in one cell (cell B1
for instance) when a condition in another cell (A1) is met.  I've tried
conditional formatting but it seems to apply only to conditions being met the
same cell that is affected.

I'm trying to use VLOOKUP to find the corresponding cells to a
particular dash number.
Example
A1  B1  C1  D1  E1

here is my situation:
I have an excel spreadsheet to keep inventory of toner cartridges.
Cell A is the inventory of toner cartridges this number fluctuates according
to what's in stock and what has been added or subtracted. In Cell B I want to

I am trying to troubleshoot an error in a macro, can anyone tell me what the
error is in this string.
=PAGE.SETUP("&L&""Arial Narrow,Regular""&8Audit Bureau of
Circulation&C&""Arial,Bold""&9CIRCULATION RECORD","&R&""Marigold""&8Circ

I am trying to do some simple math, but it will include the MO
function, and I can't get the result I need.
what I have is one column of datetime (dd/mm/yy hh:mm) and anothe
column of just time (hh:mm). I need to subtract the TIME ONLY in th

Can someone help me with a macro?
I've got an excel worksheet with a huge number of rows.  I want to identify
any row that contains certain text and tag that row with an "X" or something
that I can sort by in a new column.  Does that make sense?

Here is the formula.....=IF(SUM(C7-4000)>6000,6000,SUM(C7-4000))  I know I
should be able to insert another IF statement or perhaps a Max.....

I am trying to create a quote template that will auto populate the name and
pricing based upon the sku selected in a drop down list.  How do I do it?

When i copy number from a web page then paste them to a column i cannot use
the sum feature to get a total for the column.  What can i do?

How would I hide a worksheet in a workbook if I don't want people to se
if I sent the workbook to them.  I still want this sheet though becaus
it affects the main sheet.
Thank

This string returns #N/A:
=VLOOKUP(LARGE('Price List'!B3:B44,1),'Price List'!$C$3:$H$44,6,FALSE)
First need to identify the LARGEST value(in this case the most recent
date) then bring in corresponding data such as the next price-breaks.

I would like to make a formula that will highlight a specific range if
two statements are true. I have started with
=(IF(AND(A3>100),(A7>2%)Range(A3:A10)... this portion gives no errors,
but I cannot find the command to turn the background color for this