I have got a range of cells 'lets as A1 to F6' all with text in them. I know it is possible to highlight cells based on the text that they have in them,...

This is a simplification but contains the problem. Worksheet #1 is customer detail, including a column named date_granted (column C, specifically). The value...

Hi, I'm working on the value of cent which return to the value of 0 or 5 cents. e.g. $0.03 = $0.05 or $0.08 = $0.10 etc. So use the following formula...

Hi, I have a problem with the Vlookup formula. It`s only works right on the first time when I entered the formula but the results don`t change when I am...

I am working in an Excel Worksheet (2003) and it has scrolled to the far right of the page and will not return to my data. Help!

In listing NYSE stock symbols, in a column, the stock symbol ACN is automatically changed to CAN by Excel.-- this is not a correct symbol. Have tried every...

How do I insert a drop down box into a worksheet. So tht I can choose 1 item from a list? -- joec

I want to make a budget analysis we I can input a dollar figure in one cell and multiply to times a range of cells. When I copy the formula excel correlates...

I have a list of food items in Column A. I want to convert these so that they become entries in Row 1 instead. Can anyone advise how to do...

Hi Any help? I have this formula in E8, f8,…to x8 sheet2: =IF(OR(ISNUMBER('sheet1'!E8);ISTEXT(' sheet1'!E8));' sheet1'!E8;"") In AH8 I have this formulae, as...

In worksheet 1, column A I have a long list (350K rows) of dates and times of an event (namely when an ambulance goes enroute to the hospital..) In...

Ericsson is distributing free laptops for their brand promotion. They hope to increase their popularity and sale by this campaign. All you need to do is send...

The following formula works great when each row of columns G and H contain...

Hello, I'm using Excel 2002 Analysis Toolpak to perform regression analysis. I've successfuly performed the regression analysis, with a 95% Confidence...

I have a worksheet that I'm trying to find the data from Column A that's not in Column B. i have almost 4000 records and it's a pain to go through each row....

I don't use cell locking much, but it seems to me I've seen a list of attributes you can lock individually so the font might be one of them. I'll let...

I'm curious to find out if I can eliminate the Range on the below macro I created? I want to it to not care what Range I select, as long as the Range...

to ignore #N/A being display, try changing to this =IF(ISNA(VLOOKUP(A5-Recovery_lag,$A$5:BA$364,21)),"",VLOOKUP(A5-Recovery_lag,$A$5:BA$364,21)) this will...

I have a column that has conditional formating applied and want to count the number of cells that are red or green or any color.

I have a problem that I know the brains in here will have a solution for. I have three variables: 1. item numbers 2. colors 3. qty of items sold note: not...