I am sending a sample of contents I have in the cells. I am trying to erase everything but the URL address. How can I do it? I have in one line when I copied...

I have this formular: =SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes")) but it is showing as an error. Iknow...

I post this before and implemented the suggestions, to no avail, so I am asking for further ideas. This is Excel 2003 and I have a workbook with 15 tabs,...

Hi, group, I'm interested in knowing the lowest count of non-zero numbers in any column on my sheet. Columns are from B through I. Actually, I want to add 1...

Using data validation you can create a drop down list using information that is already on a spreadsheet, however, when I try to get information from sheet 2...

When I want to delete a single or multiple cell my drop down screen on allows me to populate the 'entire row or column? the shift cell left or up won't allow...

Hello all, Workbook has multiple tabs (4-25+). All the tabs are setup in the same format and layout. User will put an X in column N, O or P as a data...

In excel 2003 we created an htm page by clicking on create a web page and then publishing it when the screen came up. I don't see that option in 2007. I...

I have an order number embeeded in the title of an email. For example, the order number below is 09-11111 " 09-11111 sent to customer Jones" The...

when i filter data, the number of responses no longer appears in the bottom left corner of the screen. how do i know how many items meet my filter criteria?

An order number is embedded in an email title, e.g., order number in the email below is 09-11111 “ 09-11111 for Customer Jones� The order number is...

I have some large data tables that I need to rearrange in a differenct way. I would like to be able to reference a cell from a different worksheet which are...

spell check is not working - using trial office 2007 - is that why?

When I try to enter a project number such as 10-9-09 it replaces the project number with a date. How do I turn off this feature?

Is it possible to have 2 workbooks open with Automatic calculation for one and manual calculation for the other? Thanks.

Is there an easy way to sumif row entries based on dates, without having to create an additional column for an additional formula? (i.e. month()) In other...

Is there a way to copy and paste cells from one open window to another? I opened two excel windows and can only paste an image, etc. Why doesn't excel...

We have an application that downloads data into Excel. The project numbers are in this format: 10-14-09. When the download is executed, the project number...

When I open several books at a time, sometimes it stacks the book tabs under the Excel tab, instead of spreading out the names. I have not checked the...

Is there any way to get a .mht file to open in Excel 2007? I need to be able to view this file in Excel format for daily reports I get for work. I just...