Thru the DOS Prompt I created a txt file of a directory. I then opened it in Excel. I created a report in Access of similar data and copy/pasted it into the...

I can a very large excel workbook that contains over 80 worksheets. I would like to create a recap that looks at each worksheet and returns a value. All of...

I have been requested to create charts by the week of the year, which display the number of patient discharges day of the week (Sunday through Saturday),by...

I have a problem that i'm sure someone can help me with. I have a list of every area code in the USA and it's corresponding State. I want to be able to read...

Hi all! Is there any way that I can repeat the same page about 100 times with a header reflecting the page number? I need to print out one page 100 times, but...

I have several people that share files. I need to set each person up to be able to view and edit only the data partaining to them with out seeing other peoples...

is there any way to show only Distinct values in the column i.e in the column Dept. IT Finance Accountants Adminstrations Finance IT THE result shoud be IT

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

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

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

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

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

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

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

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

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

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

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

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

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