I need a little help. How do you add up the values of numbers in a column which has letters next to the numbers. I have a column of numbers, but the letters...

I have a budget with a master worksheet and each month as a separate worksheet all within one workbook. As I posted befo I am trying to get a buget with...

I want to convert a list of month abbreviations (Nov, Dec, Jan, Feb, etc...) into their respective month numbers (11, 12, 1, 2, etc). anyone have a function or...

Have created a schedule with time slots,ie: 1;03 pm, 1:12 PM thru 6:25PM in 9 minute intervals. I am using the following formula, =+c3+9/(24*60). I have...

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

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

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

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

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

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

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

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

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

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%

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

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

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