I am trying to count a range of numbers in a column I created in excel to see how many times a particlar range appears. For example, I have a column with 10...

Hi, I can't seem to add non-adjacent columns to my print area in Excel 2000 and don't know what I'm doing wrong. I'm defining my area (in page break view) by...

Thanks in advance for any help offered. I have a table with GPA's and I need to calculate the different ranges. I have the function for 3.0 and above and...

Hello, I have a SS with 3 columns that look something like this: A:(NAME) B:(Agency) C:(Formula Result) Jones, Joe Agency1 Agency1...

Do you need help on MS Word, Excel, Access, or many other programs? Would you like a little more training in these programs to help you work more efficiantly...

I want to insert a row at every 6th row in an excel spreadsheet, but I have 1400 rows, so do not want to do this manually. Is there a formula I...

Hi, Hpefully you may be able to help. I can't think of what to call what I want to do....hence can't search the help. Question: I have cells in a page that...

I want to be able to use lookup to extract values common to two list. What is the formual and do I input values in all the boxes in the drop down box??? New to...

Hi! I wonder how to get a macro that counts a mean and median on the right side of the row. I have many worksheets filled with data. I would like the macro to...

Hi, New to this so please bear with me. I have a spread sheet where I am listing names in column A and other info relating to that name in columns B and C in...

I know this is an old question. Is there a way to display zero fields as blanks? I know I can do this with and If (x=0,""...etc, but then if this cell is used...

I have many pages in excel with hundreds of prices. I need a formula to round the price up or down. For example: R 1465.55 rounded up to R 1495.00 R 1419.26...

I need to mix some columns like this: Suppose A1:A3 = 1,2,3 and B1:B3 = a,b,c How can I get C1:C6 = 1,a,2,b,3,c ? Is it possible just with formulae (no macro)...

Hi all Is it possible to protect the contents of a range of cells (Tools Protection etc.), but still be able to use 'Autofilter' on these cells? Many...

I am trying to automate the copying of values from a particular array on one sheet of a work book to a blank sheet in the same work book. The sheet that the...

Hello I would have thought this to be easy but it has be stumped! I have a workbook with 100 sheets (names sheet1 through 100) and I need to retrieve the...

Hello, I'm trying to use data validation to restrict the text allowed in a cell. I want to allow the cell to contain any combination of 7...

When I was using Office 2000-Excel, it was a very simple procedure to make a calculation of e.g.: - (L8+L9)-E9= Now when I want to make this simple calculation...

Hi all. I have formula in A2 =SUBTOTAL(3,A4:A2963) this counts the number of visible records, (after using Autofilter), that contain text (ignores blank...

Hi,=20 how can I change the default cell shape? i.e round edges=20 =EDnstead of the normal 90 degree corners. Thanks