I have created a ranking sheet for sales performance that automatically ranks
based on sales numbers.  The rank formula works fine, but when ever I try to
sort the data based on the numeric ranking the formula in the column loses
its integrity.  

What does an apostrophe (') in front of a word mean in an cell of an Excel
spreadsheet? How can I change the format with an ' into a text format of
general format? Please let me know. Thank you very much.
Youzhong Li

i have tons of info with about 10 columns, when i use the autofilter, i
want to add the values in a column but only the filtered ones. how can
i do this?
thank you in advance

I want to create a timestamp in A2 cell if there is a value in A1.
I used the Now() function which worked great, but each time i save the
worksheet, the timestamp cell (with the Now formula) changes to the current
date/time.

I've got about 500 rows of data with about a dozen columns. There are
about 100 "items" in the column "A", repeated several times each (hence
the 500 rows), with different rows of data each time
I want to be able to sum up each column for each entry in A

I multiply my cost price by 2.35 to arrive at my retail price which is
straight forward enough!
However I'd then like to round up each resultant retail price as
follows:

I am trying to round currency figures up and down to the nearest
5pence/10pence etc etc How do I round up to these. What is the formula
I need to use. Please Help!!

OK, thanks for the quick reply to prev. post, it seems a pivot table
might be a better way to do it, but for quickly summing e.g. NFL stats
the sumproduct way seemed quicker.
I tried a version using e.g.

I posted eariler and no answer. How do I nest an IF function that will
read 3 different scenarios or results? Ex. If a cell in column A
contains P, then give me the charge code xxxx-xxx in cell a5 in col K.
I have three situations in this case. If you need more info, please

I'm trying to figure out how to count the number of occurrences of an
given account identification number in a column. I'd like to get th
information in this type of format
Account ID: Frequenc

Hello From Steved
=HOUR(A1)*60+MINUTE(A1)
I am using the above to convert 6:47 a.m. to minutes it gives me 02 it
should be 407. I formatted the cell mm

How do I set up and perform a two-way ANOVA test? I am attempting to use the
microsoft office program Excel to do a statistical analysis. However, I have
been unable to figure out, using the 'Help' menu, how to do this

I have to setup a spreadsheet but i want to have all the data in the
same format.
Once they complete the data entry sheet the data is displayed on
another spreadsheet.  I would like to make everything on this sheet in

Any ideas how to write this function or where I might go for help?
I have a column of 5 digit zip codes and  column of frequecy of those zip
codes.
I would like to find the frequency of the first three digits of zip codes

I have a sumif function to return a report from a worksheet and would like to
make the condition refer to another cell (in the same workbook).  
E.g.
This works...