software

I am preparing a presentation in Powerpoint. My slides contain line charts.
I want the dataset to be shown and reflect actual units and the graph to

Im trying to link the cells within my workbook so that if I enter a value
into a quot;masterquot; sheet then, if I need it to, the same value will

Hi ...

I have this fairly large dataset with two kinds of missing values (NA):

I have posted my spreadsheets to my email address but when I try to open them
they it tells me that they cannot locate the file and tells and to search on

Hi All,

What formula do I use to get a sum for all values from collum quot;Dquot; only if
there is a particular word (out of a few words)in columm quot;Bquot; of the same row?

In Excel
Datagt;Subtotals screen make it possible to select more than one column in the

I have an equation where I am subtract time based on 24 hours. For example,

My customer has a WS, with a pivot table. In the WS he has a button
with a macro which sorts the pivot data into suppliers, and make a view

I am trying to limit the amount of numbers that are in a cell. For example I
have a cell that has this sort of number 1220H123456, and I only want to have

I am attempting to create a cross reference between 2 spreadsheets. I am
currently using the quot;VLOOKUPquot; function to obtain my results. The problem

I cant work out what expression i would use to make a DSUM function

Dear all

I am working with inventory evaluations. I download a report from another
source and put it into excel. I want to do a number of evaluations and the

I am trying to figure out a way to make a cell change colors if a certain
condition is met. For example, if cell f4 is 192.27 or above, then the cell

=MAX(IF(AND($U11=0,$V11=0),MROUND($S11-$X11,4),IF($X11=0,MROUND($W11-$N11,4),MROUND($W11-$X11,4))))

All of my macros to date are for formatting, so I'm running into a bit of a
problem for a formula macro. I tend to use this formula often when using

In Excel 2002, I want to combine three cells (City, State, and Postal Code)
into a single cell. I know this string will work for putting a space in

I have a spread sheet with lots of data. The top row of each column looks for
the max number in that column. Is there a way for excel to warn me when