I am wondering iif I can get Excel to give me the sum of just the last twelve months in a tabel that contains multiple years. Example he Month/Year Days...

I am working with multi-dimensional data storage and want to lookup values in a pivot table. See attachment for basic setup of my table. I need a way to get...

Hi, I have problem in macro codes. I have recorded macro for rows formatting. For recording a macro I have chosen line no.22. After recording a macro I want to...

I have an excel spreadsheet which I use each month to record work done, each entry has a date and a value in £'s associated with it. What i'd like to be able...

I am using the sumif formula and noticed that it doesn't pick up all the data. I tried using trim to clear out all spaces in the criteria but still no luck. ...

I would like to know if there is a way to have a cell automatically change colors; here is my scenario. I track dates of several training sessions that are a...

When I try to edit a macro that has been stored in personal.xls, it tells me to unhide the workbook first, then I will be able to edit the macro, however I can...

In cell A1 I have entered the time as 11:00 am and in cell A2 I have entered the time as 11:25 am. In Cell A3, I want the time span between the cell A2 and...

I'm trying to save a template so that others can access it through a shared network but am having trouble trying to open the template on other's computer's....

I have a workbook that has some cells locked/hidden and the worksheets protected, because I don't want my formula's messed with. However there are other cells...

In my spreadsheet I have the cells in column F referencing from cells in column C. The original content in the cells in column C have spaces in them. What I...

Ok here is whats going on, 227.82 227 0.75 0.05 0.02 227.82 False inputed 227.82 then sum 227+.75+.05+.02=227.82 then the last cell is an IF THEN...

Hi to all, I'm using Excel 97 SR-2 with Win XP SP2 on a home computer that's linked to another computer, and experiencing an intermittent problem for which I...

I need to be able to do a vlookup to extract data that can be in 3 different lists on 3 sheets... is this possible? BTW I cannot combine the data into...

I have been given the script below by Ron De Bruin - and I can't thank him enough, however I'm still scratching my head as it doesn't EXACTLY what I want. I...

Hi. I would like to perform vlookup over several columns. f a 1 5 e 9 13 b 2 6 f 10 14 c 3 7 g 11 15 d 4 8 h 12 16 My intent is to lookup A1="f", over the...

Hi I am trying to set up the speedometer chart from http://peltiertech.com/Excel/Charts/Speedometer.html. I have made the donut chart and also the scatter...

I have a need for a reminder when particular data is enterd into a cell of a certain column. In a previous posting I found exactly what I need except for one...

I am trying to reduce a column of data from ~8200 rows to ~1200 rows. I have 2 spin buttons that control the upper and lower limit the user desires. Is there...

I have a personal finance sheet that has basic formulas which I update monthly. However, if I change a data cell, the other cell which has a formula linked to...