In Excel 2003, I have a row of 7 numbers and wish to find if any of those numbers is in a vertical list of 24 numbers and to highlight the numbers which are on...

I'm not sure what function I need to use to accomplish what I'm trying to do. I have a column that has a number of products listed: Column A Product...

Hi, Is there any way that I can create a "find" button on my excel spreadsheet? I have a lot of data for people that aren't familar with excel and I...

I am trying to find a way to express a fraction as a ratio 1:4, I have tried programming it simply to look like a fraction (using the format...

Is there any way to change the size of the font that appears in a ComboBox from the Forms toolbar when it has been used in an Excel spreadsheet? ..

In pivot, how do you refresh the list of options that comes up on dropdown? Seems like once a piece of data is there, even if removed from original list and...

Is there a way to ignore the lines that have errors, i.e. "#Value" and "####" when I create my pivot tables?

I have made a price spreadsheet that we use in the office, now my boss wants me change all the prices by adding 10% to all numbers. When I set up...

I have made a price spreadsheet that we use in the office, now my boss wants me change all the prices by adding 10% to all numbers. When I set up...

Wud like to create a button to jump from sheet to sheet in a workbook, can anyone help with this. I've gotten to inserting the button - and naming it, then...

I have labels in column A - 1.1, 1.2, 1.3 ... 2.1, 2.2....5.1, etc. Instead of the A2=A1+.11, is there an alternate formula that will allow for entering a new...

Is there a way to count formated cells like shaded cells and come up with a total. Countif doesn't work with formatting to my knowledge.

Hello there, I am working with an excel sheets that has over 3000 products in our inventory The first column contains the part number. Each part number has...

Hi, I have a COM add-in which has methods to a. invoke a form where a user may capture some data b. return a single value. I also have a VBA wrapper written...

In Excel 2000: I'm needing to simply count elements based on the Fill Color of a series of cells. I know I can use the countif() function but haven't been...

Someone has changed the column headers to numbers and the rows to letters .. how?

how do I correct broken cell boxed to look like a complete grid?

When opening a Cognos report in excel the word (grouped) appears next to the report title. Sort option on excel is then not available.

Hi all I could use some help with a Vlookup. I have a range name of 'rng' on sheet A. Column A 1 2 3 4 5 6