Both COUNTBLANK and ISBLANK relate to empty cells. Yet I have a spread sheet that provides the following seemingly contradictory results: * The calculated...

How do I express the following as a formula: If any number between A1 , B1 and C1 have values that are either one value higher or lower from each other then...

Hi folks, I need help. I have a list in a column of times in 24-hour format, like the following: .... 21:00 21:30 22:00 23:00

Is there a simple way for a user of Excel 5.0 to open a file created in Excel 97? Geoff

Hi, All of a sudden my spreadsheet is taking FOREVER to do anything. If I delete a row, it takes a good 5 minutes to do. Is there something I need to do to...

I am hoping for some advice regarding the most efficent way to perform the following task. I have data that looks like this: a b c d e

In Sheet 1 Row 147 Col’s C to IV are numbers between 0 and 17 Rows 150 through 165 is the target formula location In Sheet 2 Row 99 Col’s B through R are...

Hi, I hope someone can help me with this one. I need a=20 formula that will calculate the monthly interest if i have=20 the following data: Loan value (=A3)...

I have 500 names, addresses, phone numbers etc. How do I set them up in Excel so they have their own line? I think it is referred to as "comma separated" ...

Thank you for your attention. I only have A/P and G/L, no payroll module...so I have been trying to create spreadsheets. Are you able to help me with formulas...

Hi all, Im kind of stuck with excel. I have an excel spreadsheet created with option box, calculations etc. I want to save this excel sheet saved as an...

Hi, I am using data validation, "from list" option. I get the combo box containing the list's contents from which I can make my selection. However, when the...

I have a filter turned on and need to COUNT only the visible cells in a column. Any suggestions? Thanks in advance for your help.

HOW TO CONVERT $ TO INR ? BY APPLYING A FORMULA ?

I have a table that has the values that I want to base the vlookup on in the second column and the information that I would like to return in the first. Is...

1. I have a table of around 3000 rows, incresing daily. How can I find the last entered value 'X' in column A. Table is not sorted by column A and the value...

Cell A2 contains the text "a100". Cells A5 through F15 contain indirect and offset functions that use the text in A2 to cause cells A5 through F15 to refer...

What is the difference between the formula functions count and counta?

Is it possible to use conditional formatting to change the formatting of a cell based on the value in an adjacent cell? For example, if D4 is less than half...

hello to all... I have a problem: I can increase to the number of columns in one excel table? that is I can have 1000 columns in place of 255 columns? thanks...