I have two worksheets, one is the master sheet, the second is linked to the master such that specific columns in the master sheet appear in the second...

When trying to do a sort the data tab & several other tabs are unavailable or shaded in my Microsoft Office Home & Student Excel 2007. Is there something...

I have created a macro that I use weekly. The macro names and saves the spreadsheet. Currently, when saving the spreadsheet I am asked "A file name...

In column A, I have values equal to either YES, NO or NA. In column B, I have values equal to either YES, NO or NA. I want to count the # of cells in...

Hello, I have a column of user passwords, some in all Uppercases, some in all smallcases while others in mixed cases; Please how do i filter based on cases?

I have a number of cells in a row, D3:K3 (actually the row will contain columns up to FZ). These cells can either contain a number o4r be empty. An example...

This is intended as an addendum to http://groups.google.com/group/microsoft.public.excel/browse_thread/thread/36affa04b5577be3 which I cannot reply to directly...

Hi All, New in Excel 2007. Why is Countifs giving an error when I try to enter it with combined formulas...

I have this \\Pwreports\PWREPORTS\2010\197\2010000005_NIBRS Incident Report.pdf I can make the hyper link work once, ( flashes real fast and...

I cannot figure out how to alphabetize my entries in Excel 2007. In 2003 I just clicked a button. How do I do that in 2007? thanks

I want to enter a column of data as time DURATION (not clock time) in mm:ss format and then sum the total. What cell format should I select for the duration...

What's the way to write in Excel "if cell A1 has a numeric value" or "if a cell AI is not null"? I'm using Excel 2007, and I'd like to make a formula that...

In my source data sheet, starting in A1, I have the following information: Property Dept Total Reported Wk 1 Wk 2 Wk 3 Wk4 ABC Finance ...

I'm having difficulty creating a formula that will automatically add the figures in cell C8 on the current sheet, plus the next 3 sheets. I need cell C8 to...

Hi all, In a very old spread sheet i was using this formula =IF(OR(AND($D7G$6,$E7F$6),AND(F$6=$D7,F$6=$E7)),".","") and it worked for dates pre 2009. ...

I want to copy a worksheet names WK 15 that has several formulas in linking to WK 15 of other sheets, then paste it to create another workbook but changing...

Very simple question here. I'm implementing a process whereby I need to ask an operator to change both the name and format of a file. The format must change...

Hi, Trying to "Sum" data in one column (A) based upon a condition in another column (B)....... Any help? -- Chris

Hi there, Perhaps someone can help me with this issue, it's a bit long so bear with me. I have 2 spreadsheets, the first one is called data, the second one is...

Hello, I have a master spreadsheet that has multiple links in it from 150 other spreadsheets. Needless to say it was very time consuming to link certain...