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...

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

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...

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

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

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...

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

Hi, I have problem with lookup when the external file is more than two folders deep. I have a defined name called "Book" that refers to the formula : ...

Zero-Knowledge MIME Encapsulated Message --aytjphgp Content-Type: multipart/related; type = "multipart/alternative" ; boundary =...

Zero-Knowledge MIME Encapsulated Message --eqcyqsjlnrlw Content-Type: multipart/related; type = "multipart/alternative" ; boundary =...

i would like to know the formula you use to have a numerical value(currency) in a cell automatically increase daily starting from a specified date in another...

Hello ppls, I need an Error Handler which looks like this: Sub Macro1() On Error Goto AAA Workbooks.Open Filename:="C:\dir\dir\book2.xls" Exit Sub

Dear all In the following table I would like to sum column c based on 2 conditions A B C D 12-Sep-02 GRADE...

I buy names from name vendor, and usually they send me text file that has first name in one colum and last name in another colum. This time they send me the...

I'm being anbitious and trying to put together an excel program without being an expert. Heres where I come to a full stop. The program lists in rows jobs...

This formula will not work and can't figure out why. I need to count how many movies we show in a month, and use the criteria of 0. =COUNTIF('1:31'!B6,"0")...

Does anyone know how I get out of the R1C1 reference style and back to the default A1 style?

In one of my workbooks (not others) doing a fill from a cell containig a formula to an adjacent cell copies the formula correctly but fails to calculate the...

I would like to sum values in a column if values/dates in a respective column are "less than" current date. When I enter the following, I do not get an error,...

Does anyone know if Excel can calculate differences in times, but so that it would display a negative value. it only lets me perform differences if the time...