I am working on a spreadsheet to analyze data during different periods of time. I am having difficulting creating a formula (tried imbeded if, and, then...

I'm trying to setup an IF function so that it searches for a value, then if Value is found (TRUE), to offset from the cell within which it was found. Ex: With...

I have an inventory list with inventory tag #'s associated with it. I would like Excel to indicate when a # in the sequence is missing.

I have a macro that has hit a snag. On one of the pages of the workbook, I have a list of product codes. Some are copied over and sort fine. Others, the same...

To report numbers in significant figures, Excel Help gives the following formula and states that it is valid for numbers above...

Hi, This may be obvious, but not to me... I want to prevent a few specific words from being entered in a column, but except for these exclusions, anything...

I have a simple formula that doesn't seem to work. In fact it gives me the opposite answer I expect. Cell G43 has been named "Fy_Deck". I've typed a value...

I am creating a spreadsheet and need to add links to Word documents. How do I do that?

I have not been able to find the answer after a while searching for it so here is my question: I am using the sumproduct function for calculating subtotals in...

I want to be able to click on B7 on the species OID sheet and it take me to E3 on example ID sheet. and vis-ver-sa OR if im on the species OID sheet and my...

i want to click on one cell in a worksheet and it take me to the other worksheet cell on a different sheet. AND if there is currently nothing in that cell i...

I am trying to put together a spread sheet that will allow me to type a specific letter and a 9 digit code will appear once I enter the letter.

I have a column of data which is dates, entered as dd/mm/yy, and formated to display mmm-yy. I would like to set up another column that will assign a number...

I have programmed a worksheet in English, which is being used by someone who has set his keyboard to French on his pc. The problem here is that I...

I was wondering if there is a way to mix text and a formula in a cell. I'd like to embed today's date (using the function =TODAY()) in the middle of...

Hello. In a spreadsheet, I want to count how many rows meet the following conditions: column D=apple and (column E=5 or column E=6 or column E=7 or column...

Column A contains a date, entered as 21/04/05, which is formated to display as Apr-05. I would like to have Column B display "April" or even "Apr", a text...

Hello. This is what I want to do: I want it to look at two columns in a spreadsheet. If Column S=Jane, I want it to count each time Column D='apple'. So it...

Hello. I am trying to format one cell based on the contents of another. Specifically, I have a drop-down menu in D11, there are about 10 different text lines...

Ok. I need to have a formula which would look at a number of columns and tell me now many 'consecutive' months someone has been in the top 33% of the numbers...