I have a several tables that refer to one another. I'd like to sort some of them, but doing so while keeping the formulas as relative references messes up...

How do I keep Excel from truncating leading zeros in cells? For example how do I keep 0000304 from becoming 304?

I posted a question on the Excel Worksheet Functions forum the other day and received a formula that works just fine. However, I don't understand why it does...

Hi Dennis! If the "values" are in fact numeric numbers formatted to include the leading zeros: =MAX(IF(A1:A6=201,B1:B6)) If the "values" are actually text...

Hello, I have a spreadsheet with several tabs of data. Each month I have to copy and paste the data to powerpoint so that it looks more presentable. What I...

My data appears as such: 1/2/2004 It must stay in this format. The information I need is how many referrals were made only for the month of July using this...

This is a very basic question, but has me stumped nonetheless. I have one worksheet which contains a list of my "master data", while several other worksheets...

Well, I don't know much about Pivot Tables. I have this data (sample): Date PerCent Date PerCent Apr 2001 13% May 2001 34% Jun 2001 31% Jul 2001 34%

I created a PivotTable with Dynamic data source. When update my database and refresh the PivotTable, it worrks. However, the data is not sorted. I do not want...

How do I gain access to the expense statement's linked data sheet? When I make changes to this downloaded template, are these changes automatically linked...

I have a problem on a Windows 98 OS machine whereas the imported Excel image in sketches by the user is not being displayed. If printed, the image does show...

I want to find out, on average, how many of my clients were successful with B5:B32 containing data. if n= s/u/na (successful, unsuccessful, not...

I have a user on a Windows 2000 machine with user rights. The user is also running office 97. When he opens a excel speedsheet and Enable's Macros, he gets the...

please respond as to i need help in creating a formula to calculate hours in excel for my business -morphius

I have a rather large spreadsheet and need to reduce the file size. I have compressed the pictures in the file, but the size is not getting any smaller. It...

Hi folks Am looking to calculate hours: mins into decimal hours and am struggling big-time. Can anyone point me to an URL that details this (I have had a good...

I am trying to raise a formula that gives me a sum of two cells when there is a positive value present and the following appears to satisfy...

Am typing a document in a table format, two columns.Two questions. In column 1 Last Names are typed, It is a conversation between two people. Their names are...

Hello, I created a Pivot Table in an Excel file sent to me by a co-worker. She sends a updated file each month with the same layout, and I use the Move/Copy...

I've encountered the following error when using the pivot table. Microsoft Excel cannot make this change because there are too many row or column items. Drag...