A colleage has Excel2003 which contains a function "=mround". How do I get that into Excel2002?

Hello best excellers. I have a sheet for my empolyees with the days on which they should work. I want to change the color of the cell automatically to blue...

Hello excellers, I seek a solution for my problem and you are the only ones who can help. I have a year-list of employees for each day ( 100 persons ). Daily...

I just shared a excel document on my server to test it out and found all the insert commands greyed out. I need to find a way to insert pictures. I then...

Helping someone out with a worksheet that figures time (in military time) for use at weekend race tracks. Generally they have two days so it was easy with 2...

I am trying to figure out the syntax for a subtotal formula that subtotals non-contiguous cells. I am using Excel 2003. If I use the Sum function as in the...

I'm trying to create a workbook that uses a list to record each report. A separate worksheet (called report) would serve as the report template. Each variable...

I have a worksheet that has numerous duplicate values in a column. I'd like to do the equivalent of a SQL "select distinct" but don't know how to do this in...

AIG Policy # State WC Code DOUBLE HOUR OVER Grand Total WC 968-5711 AZ 8810 11,797 50 11,847 9040 435,558 18,577 454,135 CO...

I'm linking cells from another worksheet and I have two questions which are somewhat related. 1. When I link the cell using ='Worksheet2'A2 the cell that I'm...

Help! I can get a simple HLookup fundtion working.. see example below: (table and the Hlookup formula extracts the number 0.65 Counter GIL SYNF FRC ...

Working in Excel 2000. Trying to use the HYPERLINK Worksheet Function to Hyperlink from one sheet to a Cell on another Sheet. I can get it to work easily by...

ALL of the postings with attachments you are currently seeing in the Excel newsgroups ALL have viruses -- DO NOT OPEN. Be suspicious of any posting that is ...

Hi Andy, HTML will show borders but your gridlines will be ignored even if you have checked Print gridlines on your setup, sheets it has nothing to do...

Hi Paul, This is not provided for in Excel. It can get quite messy trying to create such feature. How about a running balance instead. G22: ...

Hi Michael, I really don't have any idea what your two columns of data represents, but a char(217) in the wingdings font would be a star. So maybe take a...

http://google.com/groups?threadm=e4FqF7hvCHA.2600%40TK2MSFTNGP11 -- --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: ...

Hi Vinny, Conditional Formatting is certainly the easiest to use and it does not matter how the value changed, but the limitation of 3 formatting choices per...

"Single word subjects and anonymous posters" sure takes any enjoyment out of trying to find solutions and posting replies. You can get a free email address...

Hi There, I've got a tricky one here, and I'm not sure if anything can be done about it. Here's the situation... I've got a workbook that I use to track the...