I currently have an excel spreadsheet which contains a lot of data. I am
then manipulating this data to find root cause. I am graphing the data in
- Apr 21 Sat 2007 20:36
Moving excel data into a pivot table
- Apr 21 Sat 2007 20:36
Help with function/cond. formatting
- Apr 21 Sat 2007 20:36
Excel conditional sum
I have a two colums with values, A contains numbers from 1 to 10, B contains
numerique values. Now I would like to make the sum of the values in B
- Apr 21 Sat 2007 20:36
MEDIAN, STDEV of a range IF another range = specific value
I want to get the MEDIAN of the values in F2:Q107 only if the value in
D2107 = D111, how do I do this. I want to do the same thing with MEDIAN.
- Apr 21 Sat 2007 20:36
Advanced Filter criteria (formula)
I was using the following formula when filtering a sheet of data:
- Apr 21 Sat 2007 20:36
Sumproduct doesn't work with columns... alternatives?
- Apr 21 Sat 2007 20:36
address help (similar to trim or transpose)
I need to convert data in an excel file from:
- Apr 21 Sat 2007 20:36
Save As quot;value in defined cellquot;
In a workbook, on worksheet Sheet 1, in Cell A1 I have a value. Let's say
the value is the word quot;timesheetquot;. How do I save the workbook with the
- Apr 21 Sat 2007 20:36
average function
How do I average a column of numbers and exclude cells with zero values?
- Apr 21 Sat 2007 20:36
vlookup display
I have a list of sales invoices in column B with a associated sales territory
in column A. Can vlookup display more than one invoice #. If so, how?