I use filters in excel extensively, occasionally I do not realise I have a filter on a worksheet as the dark blue filter arrows are not destinctive enough to...

I have a workbook that has a sheet1 with product information, something like this Prod Length width Code A 10 20 001 B 5 ...

I am stuck with this one and was hoping someone could help. I am trying to figure out a formula that uses the date from a cell in the file reference. D2...

On sheet1 I complete all info displayed spread over other sheets of which many information is repeated. So I have a direct reference to sheet1 and only need to...

I am trying to set a cell in Excell to automatically increase in value everytime I open the worksheet. For example, it is an invoice, and I want the invoice...

Hello, I've looked for a post on this and in Excel help but drawing a blank. Hoping one of you might have an answer for me. Is there a formula that will...

IN WRITING IF TESTS IWOULD LIKE TO HAVE THE RESULT PRINT IN RED FOR NEGATIVE NUMBERS AND BLACK OR GREEN FOR POSITIVE. CAN THIS BE DONE.

This is my first attempt a using sumproduct and testing by rows and columns together. My goal is to: Sum all cells U10:DL30 if Row 7 = the current month if...

First would it be to send a excel file to get some assistance with my worksheet? -- Maria A Adams

Having used lotues1-2-3 for 8 years to prepare income tax repoerts, I am now using Excel for the first time. I copied my Lotus Workbook, to an Excel...

Test of post problem -- Lady

I am not sure how to accomplish what I need to accomplish, and I'm not sure it can be done in excel... It may need a VB code which I have no experience...

Hello, I have a code that is looking for a Vlookup. I know that some of the queries are N/A# and to have On Error Resume Next error handling. The code is...

I am using this formula in CG =IF(F11="mlf",C11*D11*E11/1000,IF(F11="RL",D11*E11,"")) I am using this formula in CE =I11/0.95 The formula in CE is causing the...

Column A contains #'s 1-1408 sequentially, Column E has #'s varying 80-33000 non-sequential. Now by using =if(e3:e1408,"27840") this finds this number and...

Please can someone help me - I have a spreadsheet which I have "inherited" and trying to add Conditional formatting to a cell, the CF menu selection is...

In a column I need to count how many rows from the start of the column are greater then zero. The trick is once the value is a 0 or a negative, it is to stop...

Hi to all, I got one for you: I have two workbooks, each with 14 worksheets. I would like to create LINKS from workbook to workbook, worksheet to worksheet....

how do i get the cells to change colour once they have gone over set parameters ie- a training schedule on a 12 month rota to automatically change to red...

Hi, I have data in 2 files. File A contains data in 2 columns and File B I have data in 1 column. The first cell in file B is validated. I have given the...