In an assignment for college, we used the 3 flag icon set to conditionally format a column of revenues with $110,000 being the highest value. Any ideas why...

I have a spreadsheet that I use to calculate dates for inventory supplies. I have a formula that works great except for one function - I would like to be...

I have a formula for conditional format set up on columns H1 and J1. It works great for what I need. The problem is that I would like to fill-down the...

I am having trouble summing across multiple worksheets. I have a "Totaliser" sheet which has the relivant search info on it. eg Cells F5:F100 hold the...

I am trying to auto fill or copy down this formula, when I copy down Saturday shows up in every cell, even if the orginal cell blank How can I re-work the...

I need to look up a value in a table based on 2 different criteria. The first is the item code, and the second is the month. The "B", "C" and "D" column...

Currently Im trying to write a formula with 2 search criteria: 1. Write a month/yr (in a validation list), which searchs for this in another 12 month table...

Hi there, I have a vertical data array that begins in cell C5 and ends at cell C214. Each pair of consecutive lines contains data applicable to a single...

I have a data entry sheet were sheet 1 has the table array fromulas built down 25000 and accross about 12 columns. The table is about 500,000 rows of 12...

Hello; I did post this question earlier (with the same Subject) at MrExcel forum. A single respondent DaveMeade (who has put a considerable effort and still...

Suppose Sheet 1 looks like this: 1 2340 Cash Received Payment 2,000 3578 Accounts Pay Received Payment ...

I need a formula to do the following: If in column 3, a cell says "cash", I need that entire row that contains "cash" in column 3 to be transferred to...

Actually i have raised this query about 2 years back in same forum but still i have not got satisfactory solution. What i looking for is , I am having...

I have a spreadsheet with 12 columns. I'd like to sort on any one of those columns at one time or another. However, when I "Sort Data" on a column (it...

Sorry if this has been covered but I have a spreadsheet with shift A B or C in col A. A part number in col B and the quantity of each part in col C. Each shift...

I am trying to help out the office at work with this one but I seem to be missing something. First off they are using excel 2003. I know the first answer is...

I've been asked to find a simple way of decoding a numeric (integer) timestamp (representing date only) into native Excel date format, so that it can be...

DN SCH WEIGHT(kg/m) 10 80s ??? ??? to read from this table dn sch 5s 10s 40s 80s 6 0.00 0.28 0.36 0.48 8 0.00 0.51 0.64 0.80 10 0.00 0.64 0.86 1.12

I need to round currency to the nearest dollar amount