I have a spreadsheet with values entered by category number (column A). I
can't think of a formula that would check column A for a value and if it is a
match add the values in the corresponding column B cells. Can anyone help me?
Is there a variation on the IF statement? Thanks.

I used to have a box on the bottom bar in excel that would give me a subtotal
of highlighted cells.  It has disappeared and I cannot figure out how to get
it back.  I really miss it.

I would like to scan specific columns (but all the rows in the specified
columns) for a certain value, in this case 99, and if a cell has a value of
99, I need to replace it with another number, 3 in this case.
I think this would be an 'if then' type of thing with a loop perhaps, ...

I have a column containing three digit numbers and four digit numbers.  I
need to replace the three digit numbers with the first four digit number
listed below them.
Here's an example of the numbers listed in column "B" and what the result

Can you tell me how to print the drop down filter list in Excel.  I need to
prune and consolidate the various selections.

I need to save a file as CSV, But I need the delimiter to be a semicolon (;)
Can this be done with a macro?

I would like to create a function that would put 5 random numbers from
a list.  The list is in cells A5:A105 and the five random selections
can go in B5:B9.  I'm using the formula:
=INDEX(A:A,RAND()*COUNTA(A:A))

I have two work sheets, A and B.  Work sheet A is a Master sheet, it has in
it a Part Number column, along with Description and Price columns of 50,000
parts. The other sheet B is just part numbers, 900 parts, no description or
price column.  How do I get matching part number ...

Hi I am using Excel 2002 SP3
I want to Protect a sheet to prevent users from making certain changes
(delete rows, some cells etc). When I use the Tools Protect Sheet option I
select "Format Columns", Edit Obects, Edit Scenarios and Use Autofilter.

In several spreadsheets the contents of cells in one column displayed as a
series of pound signs. I set the cells to wrap, data type to text. In some
cases I was able to restore normal display by removing part of the text if
that part includes numbers. Most of the cells had lots ...

Excel
I am deducting two tables and I am using V-Lookup. However, in one of the
tables I don’t have all the headings as in table 1. When I subtract then I
get #N/A. To correct this, I am using ISERR but it returns False.  

Is there a way that I can highlight cells temporarily with color until they
are selected or until they are filled in?  I would like specific colors to
disappear once data has been entered into certain cells of the document so
that it can then be printed.  Any help would be ...

Hi everyone. I need a validation formula that will allow (only) the word
"CHIPS" in the validation cell if cell A1<>"MB". If Cell A1="MB", then the
words "CASH, CHIPS, or CHECK" (only) may be entered.
Please help- "Thanks"

I noticed this before when using Lotus notes but it's now happening in
Windows too. Any ideas? Thanks

A1 has a list of 4 choices
AAA
BBB
CCC