Hi I'm using Excel 2003 on Windows XP2003 I have been refreshing the same Pivot Tables for a couple of years - I have created these tables myself. In some...

I keep posting this but cant see it in the forum under my user name-Apologies if repeat? I have Excel file that when previewd it wants to print 1 of 1236...

Excel2003 ... Col H contains up to 100 unique values Col D contains Values L1, L2, L3 out to L50 (100 repeats of this set) In Col C ... I wish a formula to...

Is there any way of summing time expressed in minutes and seconds? For example, I may need the sum of a column containing 5'32'',0'45", 13'03" and so on.

Hi I am using Excel 2003. I want the formula that allows me to shift all the words in a cell 1 spacing to the left as I have some cells with a spacing...

I am using Excel 2003 SP3 on an XP workstation. Several times I have simple formulas (i.e., adding a few rows of numbers in a column), using whole numbers,...

Hi, I've been so lucky as to get new excel and am stuggling with two things I can't do anymore. 1. Remove getpivotdata - if I click in cell B5 I want the...

I have a set of data which is used to generate multiple pivots charts. Each set of pivot charts also runs from different data worksheets. However, for each...

I could send this to the Programing form I want to change the following macro to copy the list to the A column with formats (color or no color) to a new...

I wish to creat a senario that when certain names from a list are typed within a range of cells, that they appear in a given color

When using the Filter function, or when simply highlighting a range of numeric cells, I don't see the row count or sum in the status bar at the bottom. ...

G'day all I have been using Don Guillett's excellent code (copied below) to create a automatic Table of Contents. Is there any way to automatically include...

Hello I am looking to write a formula that gives me the difference in hours between a logged date and time and a closed date and time eg -27/11/2009...

I am trying to sum column D where column A starts with "61", column B is either ABC or DEF and column C = North. The result should be 2000 but I am only...

I have a worksheet with multiple row heights. When I do autofit some of the words are being cutoff in the rows. How can I adjust to a little extra space in...

Hi, I have a file named Inventory.xls which carries the records of all my stock items. List.xls is a short column list of item names whose identical data in...

In column "G" I have imported dates formatted as such...11/09/2009 9:58:00 AM I'm in accounting so we go by fiscal month i.e. 10/24/09 thru 11/27/09 is...

I am looking at showing the quarter a selective date is in i.e. 9-Dec-09 would be 4Qtr09.s Any code that can do this without having to go in to do it...

How to get the highest number repeted in a column which exist of numbers?

I have a set of qualifications linked to a name that need to be presented in a row A = Name B = Qual Type 1 C = Expiry Date (eg 29/01/12) D = Qual Type 2 E =...