I need a report on how many pages and lines of information are being used in a current workbook and be able to also break that down into individual worksheets....

Hi to all, I am trying to convert a number to a hex number using the Hex() function in Excel but no luck !!!! I am always getting the same error 13 datatype...

Is there a way to enter dates before 1900 and format them so they look like and sort with dates after 1900?

I have an excel file that has four columns: account number, account description, Debit & Credit columns. The debit and credit columns are filled in...

I have a worksheet with two columns of data. How would I build a macro that, within a certain range, if the number is in column B, to multiply that cell by -1...

I need a formula to help me determine what values, in a given range, make up a specified sum. For example, if the sum is 1000 and the range of cells include...

I am running Windows XP Pro and Office 2000 Small Business. In Excel I can't find or don't have an XIRR function. Do they only put this function in the...

Hi All: Is it possible custom auto filter to find more than 2 objects? or Is it possible to conditional format more than three? I have a column which...

I need to create a new column and populate it based on the criteria of two other columns. Example: Col A Chicago Chicago New York Col B NAPS

Trying to write a formula to calculate this: $1 - 5000 30% $1500 5001 - 10000 24% ...

I wonder if it is possible to count a best sequence of Wins My spreadsheet has a column that I enter either Win, Loss or Draw. I would like to show the best...

how can I download and convert/format a list on the internet, such as yellow page listings to excel without manually formatting the text. Also html format to...

I need to sort a list on a 5-digit numeric code, but not in either true ascending or descending order. Rather it has to be sorted to match the order of a...

e-mail me and i can send you an example. there's some VB involved, but it works like a charm. Kevin McClement -----Original Message----- Firstly appreciate...

I am trying to use the COUNTIF function to determine the count of cells with date greater than today's date. I am using the following...

I have a reference in sheet2 to a list of cells in sheet1. Everytime I paste numbers into the referenced cell of sheet1, sheet2 gives me the #REF! error....

We are trying for consistency in editing and need to have the same macro on multiple (different) workstations. How do we get Excel to recognize a macro file...

I obtained a copy of a spreadsheet that performs the task of giving me a drop down list, through a combo box, of a list of vendors. When you select the vendor...

I'm trying to set up a time sheet at work using excel. I have set up my sheet to calculate each day of the week individually. (M, T, W, Th, F, Sa, Su). I...

How do I enter hours and minutes (54:45) and get the decimal equivalent? (i.e. 54.75)