i have a table in excell, Column A is the Date of the flight, Column B is the
mode (day, night, NVG) and column C is the number of hours flown.
i need the formula to find the most recent date that i flew night in one
cell and in another cell i need to find the most recent date ...

I am trying to write a macro to create a chart based on a large data table,
but each time I run the macro, the data table will be in the same relative
location but will be a different size.  How can I write the macro to select
an entire range each time even though it will be a ...

I am using Excl 2007. I'm not sure Excel can do what I need so I figured I
would come to the experts:
*Worksheet #1: Database of about 2000 names, addresses, etc.
*Worksheet #2: A form I created to pull in names from Worksheet #1

I have formulas in cells that return a #DIV/0 because there is no data to put
in dependent cells in the formula.  Someone show me, apparently way too long
ago, how to use ISERROR to cause the value to be "0" if an error was found
and to be the output of the formula if no errors ...

I have a list of shipping codes and descriptions that is referenced in a
template. I need to copy the list and descriptions and add text to the
beginning of the description. The formula ="Customer "&B2" does this but I
want Customer to be Bold and Red. I tried putting Customer in ...

I have excel 2003 and have not had any problems with it in the past.  Lately,
though, when I open excel, all I get is a gray screen until I View>Full
screen.  Then I get the grids, but no tabs for the sheets.  If I go to the
help tab on top and open the help file under tabs, it  ...

I am using Excel 2003, I was sent a excel document as an attachment with a
pivot table, the original data to which the pivot table was linked was not
attached, is there a way to get the data back to just coloumns, I don't care
about formatting.  I just need it out of the pivot ...

I have a chart positioned next to a data area; the data is used in the chart.
When I use the filters on the data, the rows that go away take the chart away.
Is there a setting to make the chart "float" above the worksheet, and not be
affected by the rows that are hidden by the ...

I work in a small office with 4 people and need to produce a graph which
shows when we have more than 1 person on the phone at the same time. The
spreadsheet shows when calls started, the time on the call and when the call
ended. It also shows when times overlap each other ...

I am importing data from an AS400 program and my dates are formated as 10107
for January 1, and would be 110107 for November 1.  Can anyone help me figure
out out to convert to 1/01/07 and 11/01/07?

Hi. I have set of Text Values in 2 Columns (eg A1 & B1), in A1 the value are
like (eg Pen, Pencil) & in B1 values are 'Yes' (in some cell) 'No' (in some
cell). I want to take Sum of 'Pen' which have 'Yes' in Coloumn B1, & Sum of
'Pencil' which have 'Yes' in Column B1, and same with ...

Under File, save as, tools, General options, there is an option to Always
create backup. Can someone explain the advantages and disadvantages to this
option?
Thank you!

In Ms. Word, I have written a Document of 20 pages with some 50 nos. of
Headings. now I want to automaticaly generate the Serial Nos. on those
Headings. is there any way to do this.....thanks...

1- I've used Cond 4Mat to color a whole bunch of cells in my sheet. I now
what to do a Find/Replace based on Finding the different colored cells, which
I can't do, because Find is color-blind to Cond4Mat colors.
When data's generated by formulas in cells, I can copy & paste text ...

I have the hours worked in Column A (i.e., 8:00 - 5:00) and the total hours
in Column B (8.0).  Is there a formula for Column B that will calculate that
for me, or will I have to use two columns for the hours worked (start time
and end time) AND use military time in order to do a ...