I am using the following formula to retrieve data that matches two specific criteria. =INDEX(C2:C80,MATCH(1,(A2:A80="Liverpool")*(B2:B80="January"),0)) using...

Is it possible to link specific rows in a source workbook to update the same information in individual client workbooks using the same information, saving time...

I have a workbook that contains 1,000 rows. The workbook has months accross (from Jan-01 to present). There are 'Sumif' formulas in every cell for every...

I have a workbook that contains 1,000 rows. The workbook has months accross (from Jan-01 to present). There are 'Sumif' formulas in every cell for every...

How can I get the Row SubTotals to not display in a PivotTable?

ok that worked, but I cant seem to do anything with the # in that cell. I cant say use the # inside the cell with text & #s in a formula in another cell. It...

Good day everyone. Is there a way to deselect multiple items from a field that was dragged into the Pivot Table? I have some fields that have 100 choices and...

hi there, kindly let me have a solution for selecting all the even\odd rows or columns in an excel sheet, regards

Is there a feature of Excel or a macro that I could write to disable the save as?

HELP Once again I am driving myself insane. We need to format cells in our worksheet to show significant figures. We need to post lab results using the...

when ever I try to email an excel worksheet from within excel, it starts the Internet connection wizard like it wants to connect to outside email instead of my...

I need a workbook to save as filename (cell a3) and automatically save (without prompting if possible) when any cell in a4:iv4 is populated. Does anyone know...

Hey Ron (or anyone else), To expand on this, I'm trying to fill the column down with the dates for that month and it not include any days from the same month,...

Hi, Hope someone can help me. I have weird printing problem that I can't seem to fix! Here's the story ... I am using Windows XP and Office 2003. I link excel...

I have a column of cells that each have a comment attached to the cell. Is there a way to take those comments, and keep them attached to the record of data...

If I install ms excel by using the option "run from network " at the time of installation, does it use microsotf license for each machine or use only...

I have a sheet that needs to save everytime a certain range of cells is populated. whenever something is typed in a4:iv4, I would like it to save without...

I have an excel file containing data separated by lot number. There are several rows and columns of data for each lot number (there are a set number of...

Hi. I am charting test yields by date. Sample data is: 6/17 -- 100% 6/18 -- 95% 6/21 -- 96% 6/22 -- 83% Is there a way to have the line chart ignore...

Hi. If I am creating a line chart with the following data, is there a way that I can get the line chart to skip the date with no data (6/10 in this case). I...