am using Excel 2003 and I have a formula to randomly select employees for a mandatory drug screen. I have 15 employees and I use the formula...

Excel Pivot Table How to Sort data as Percent of Row In Excel 2003 you could display data in a pivot table as percent of row then sort the percentage. In...

Hi Ed, Are you referring to multiple sheets? Or are there multiple records in the same row? Justin

I have a spreadsheet that is updated throughout the month and a column that presents a summary of data entered-to-date. Is there a nested IF formula that...

I need a formula to issue 1 day every four month starting with the month already in a cell, Can you help. KK

This is going to be easy peasy I know, but it's got me stumped. I need to copy a cells contents and format (not conditional) into a frontsheet. Using simple...

Hello. I read all of the COUNTIF , AND threads but did not find a solution to my problem. - I have a column of dates on one worklsheet - I'm trying to...

i have a 6 page document that has a daily date change which i must do manually. I would like to have this document change the date on a daily basis.

I'm trying to write a fomula that will look in column A for any text that contains the text "LOA". If TRUE, I want to apply some conditional formatting to a...

Hi all, I've been working on a nice spreadsheet for over a week, now that I'm close to finalizing a nice looking sheet which will safe the colleques a lot of...

I was wondering if it would be possible to format cells semi automatic. See attached picture for example. I have a standard workbook to help collegues...

I would like to rename the columns in excel 2003, for example instead of A showing up in the top column, I would like it to be name. Or I would like to add a...

I'm trying to sort the list below based upon the results displayed in the last two columns. I tried to sort the data but it did not display what I was...

Hi, Ive created a macro and assigned it to a button. when I run the macro, it works perfectly, however, at completion of the macro, the button dissapears. ...

i have a spreadsheet with 52 rows of data relating to properties, i.e. 52 properties. in column B i have the information to which office location it belongs...

Hi all I'm busy capturing a staff survey. I need to calculate the number of times the staff members answered "Agree, Disagree, etc" to questions 1 - 26 from...

Hi, I have a macro for protecting sheets & the ability to run the macro is password protected. Is there any way i can program it so that when i type in the...

I have created a spreadsheet with 10 years plus of monthly energy consumption and cost data. I am now trying to create a pivot table which will allow me to...

Another IF challange. I have the following formula (shematic): A + B + 0,57C + D - 0,5r - 2,57d Got the formula working nicely, even with the follwing...

I am using this formula =IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=YES,F12/11,IF(VLOOKUP(C12,REFERENCE!$H$1:$I$65,2,FALSE)=MIXED,"ENTER",0)) in coulmn "g"...