When I try to copy just the visible cells after I have subtotaled, it pastes all the details even when I paste special (just values). SOmeone told me there...

I am trying to write a SUMIF equation that will return a value between two values (eg) 15000 but 24999, and I don't know what command to use for the BUT. ...

Please see Logical Function question posted today. -- B. Davis

I have a pivot table that has employees names , showing course hours completed, needed, etc.. On this pivot table I also have the employees managers they...

I have a task. I just started working in an office and I've been instructed to remove about 2000 little pics from an excel sheet that have been copy and pasted...

I am creating a mileage chart in which I would like to enter the locations driven to as text in one cell. In the adjacent cell I woul d like the actual miles...

I have two columns of dates, a year and a month, non sequential, like this: 1994 Jan 1990 Jan 1993 May 1994 Apr 1994 Jan 1991 Nov Etc.

I dont remember what the formula for converting temperatures from farenheit to celsius?

Please post response as email use is bogus to prevent spam. Thank you. I am struggling with the following: I want to have a cell that looks up the date value...

If i have a '13.75' in a cell, I would like to display just the .75 in another cell. How do I do this?

How do I use one list box to let me select one item in the list and get Excel to display names related to this item in a second list box, i.e. choose the name...

Any idea why it say "Filter mode" instead of "X of Y records" in the bottom left hand corner after I've applied a filter? Thanks.

I have a column of dates that I need to sort through. At the moment I am using =COUNTIF(E8:E1000,"15/04/2005") to check dates that were before todays date....

I have two worksheets; One with the names (last, first) of last years employees, The second with the current employee list (last, first). I need to compare the...

The color gradient that looks like a sunset is available in the charts when they are added to a worksheet. I can't seem to find the same 'gradient' color...

I need to know how to calculate due dates automatically by enetering the date of invoice in one cell and correspondingly the due date should be...

I am trying to set up a code to change the cell color and font color depending on the entry in a particular cell. Example: If C2 is "John", then D2, E2, F2,...

I am using Excel 2002 in Windows XP Professional. While saving a file, I am always prompted to either "Save a copy" or "Overwrite changes". I find...

I have a worksheet with contains macros. I want to protect the worksheet, but allow the macros to run. When I protect the worksheet, the macros are no longer...

column A has peoples names and B has their phone numbers. if both b1 and b18 have the phone number 123456 I would like the C column (c1 and c18) to have a tick...