Hi, I have a pivot table with 2 fields in 'row'. 1st is Job Role, 2nd is Payscale (there are many payscales for each job role). 'Data' is suming the total...

Hey! I´m having a little problem generating a few random numbers. The thing is this: I have a huge list of people and I need to assign a random number...

Can someone tell why this formula returns a negitive =IF((((F6-G6)+(I6-J6))*24)8,8,((F6-G6)+(I6-J6))*24) The cells f6 g6 i6 j6 are formated for time...

Anyone know if his is possible? THANKS Robin

Any method of keyboard remapping In Excel? THANKS Robin

I received a template by email. The template is in Excel 2007. My Excel is 2003. Everytime I enter data in a cell the convverson process takes place. How...

I have a column with repeating labels, and a second column with values. Example: Column A Column B Label1 Value1 Label2 Value2 Label3 ...

Using excel 2003 I have a workbook that I will be using to calculate stumpage and payroll. To get the data moved from the load sheet to the stumpage sheet, I...

How do I consolidate several spreadsheets into one spreadsheet with each spreadsheet on a different tab in the new spreadsheet? How do I do this with the...

Using Excel 3. I am trying to assign ABC codes to long list of products based on % of sales. A10 is part #, B10 is %. In C10, need formula to pick a code...

I want to merge a column of names to a column of 10 digit mobile numbers; but in doing so I need to delete "0" (the first digit) before adding "44" to the...

Hi, I'm trying to design a spin box function which pulls in data from monthly tabs, the month being determined by a spin box. I have monthly tabs Jan-10 to...

I have a workbook with different worksheets that tracks different types of trainings a person has taken. Is there a formula that can pull data identifying...

I need to calculate 'unreconciled amount' in my check register by looking at column B (deposit or withdrawal), column E (check amount), column F (bank...

Sorry guys but I've tried searching and this question must be so dumb it isn't even worthy of a prior post. Anyway, I'm fiddling with data (question to be...

I have a spreadsheet of 400 names consisting of first name, middle initial and surname (e.g. Joe x Blogs) and want to create a new column that just gives me...

how to have multiple print area on the same worksheet and print one that needed only? I have a spreadsheet with 5 sections. I need to have 5 different print...

Hey! I´m having a little problem generating a few random numbers. The thing is this: I have a huge list of people and I need to assign a random number...

Hey! I´m having a little problem generating a few random numbers. The thing is this: I have a huge list of people and I need to assign a random number...

I work for a builder. I need to manage the portable restrooms used on 27 different communites. I would like to have a source worksheet with each portable...