Could someone kindly give me some guidance on the below: I have two columns, one a list of dates, and the other which is supposed to show a 'Y' if the date in...

How do I calculate difference in days & hours between two dates excluding weekends and public holidays. Using excel 2002

I am working with several large excel sheets(stats, employees etc.). I am trying to tie all 4 of these sheets into 1 sheet that will pull data from the main...

I have created a payroll spreadsheet that calculates FICA and MEDICARE W/H. I formatted the cells to 2 places. The MEDICARE W/H formula calculates to...

Hi out there in cyberspace, I am trying to automate a workbook containing 14 sheets, each is a weight class used for wrestling tournaments. I want to be able...

Okay. Pretend I'm a totally idiot and and can't seem to get anything to work right! :) Now, I have done a few macros before (basically just recording them...

can the numbers in an IF statement be automatically programmed to change colors when number is negative(red for negative and blue for positive)

I have one column of over 100 cells that are either blank or contain a date. If I use the following, it doesn't add them up correctly. =COUNTIF(G2:G113,"*")...

Good day: I am using the following formula to make choices for conditional formatting in other cells. As it is, the "else" would be the result of an entry of a...

Hi! How can I make geomean(1+D2:D37) count ONLY the cells with numbers? I am trying =GEOMEAN(1+IF(ISNUMBER(D2:D37),D2:D37))^12-1 using array formula, its not...

Having a brain Fuzz……. What am I missing…..The following array should return “5� if cell A1 contains “ABC� and cell B1 contains “DEF� and...

Using Excel 2003 Using the following formula It works great Except that when the input cell is blank ( or "deleted"), a Zero is entered in cell "W?" This...

I would like my pivot table to use the fields down the first column. Pivot Tables default to usung the headings across the columns, but my headings are down...

When using the excel templates to do a gradebook, how would I adjust it so that I can drop a student's lowest grade.

Hi everyone I was wondering how I can rename a cell reference. For example I would like to rename cell A1 reference: "Mike". So if I put 20 in cell A1 and I...

I have to be an expert in pivot tables in 2 days from now..is there a crash course for a dummy! Thank you.

I have return streams going down colums B through I Dates are down column A I want colum J to give me the weighted return for the streams of returns. But it...

How Can I copy a sheet that has hidden rows without copying the hidden rows? Thanks

can a cell easily be made to hide &/or unhide the info typed in, without actually adjusting the row width to perform the hide/unhide for example: a1 =...

Hi there - I have 2 columns of data (numerical), I need to find how many values exist in both columns. Some type of lookup function should do it, but I tried...