Mr . RagDyer , please very much to allow me to send you an mail , I need strong to speak with you , if I'm not impolite ... My g-mail is ...

I have a set date to which I need to add a number of days, but holidays should not be counted. The cells of one of the columns in my spreadsheet holds the...

Hi All, I'm trying to format a cell based on the text content of another cell. The part I'm having problems with is that the referenced cell will "contain" a...

I need to calculate the Percentile of the data fields of a PivotTable in Excel. My PivotTable is constructed from columns called Region, Category, Month and...

HI, I am trying to have a row that references cells that are moving 1 down and 1 over. I want to caputure the last number in each column. Example A1 ...

How can I round time UP to the nearest 5 min. I need to have the report in numbers divisible by 5 and the time should always go up. 1:30, 1:35, 1:40,...

Hi! I need help with the PERCENTRANK excel function for my data set.... I have a data set of several physical abilities tasks, such as pushups, situps,...

-- Geoff "Alicia" wrote: I have created a list on a worksheet of 5 products. I want to create a drop down list in several fields that references this...

If I enter in A1 "1:10" and on A2 "1:20" and try to sum those two together, it won't give me an answer. How can I format the cells so that A3 can give me the...

Hello everyone, I am faced to an accounting problem that has emerged at the time of the 2009 budgeting process. I prepare the yearly budget in an Excel table...

Hi, I have a sheet with 3 columns. A is the list of 2500 references B is the list of 6500 lot numbers C is the quantity per lot per reference I would like to...

I have the following..... A B 1 ?????? Sum=(A1)*(-15%)+A1 To get net figure for sales Example ...

Can I fix the range of table array, so when I copy and paste vlookup formula, the table array can be kept in an original range.

Hi The data in my sheet is in the below mentioned format. Column B 1 Blank 2 Blank 3 Blank 4 Blank 5 Total 6 2

HI I have a puzzle - I wonder if anyone can assist. In cells D4,D6,D8,D12,D14 and D16 in have formula-based totals for the first 6 months of the year. In...

=SUMPRODUCT(--(MONTH('2008'!B3:B2000)=1),--(YEAR(B3:B2000)=2009)) Hi all, I am using the above, but am getting #VALUE! The format the date is typed in, in...

I have a very simple pivot table. However I am having a problem with one particular cell within the pivot table. The content of this one cell should be zero....

I hope someone can help me I have just started with a reasonably large homeless organisation where they collect large amounts of statistical data using...

I am working with a form that was created in Excel. Currently the data is manually entered into the form from a master Excel file. I only enter data into the...

my excel is like this Australia xxx 100 yyy 200 zzz 300 Australia total 600 UK xxx 400 ...