目前分類:title (3013)
- Aug 14 Mon 2006 20:09
Leap year date problem
- Aug 14 Mon 2006 20:09
Can you do an IF function whether a cell has a fill color of Rose
I want to get a 1 returned when I quere a cell if the fill color is Rose
(colorindex=38). Do you use the IF function or is there another way to do
- Aug 14 Mon 2006 20:09
How do I count differert items in a column only if the date in an.
I would like to be able to count the number of different iteams in one column
whose dates are less than 30 days older than the current date in another
- Aug 14 Mon 2006 20:09
Draging horozontal
- Aug 14 Mon 2006 20:09
Matching
- Aug 14 Mon 2006 20:09
How do globally clear pre-marked cells
I have data sheets which I fill out annually. The outline stays the same;
however, the data fields change. Is there a way I can clear all of the data
- Aug 14 Mon 2006 20:09
Excel
I would like to take information that is one column but over 2000 rows and
move it into the A1 cell, but separated by commas. So instead of separation
- Aug 14 Mon 2006 20:09
Macro to open workbook and copy and paste values in to orig workbo
I am trying to do four things via a marco:
1) Open a time report based on a file path AND a file name contained in a
- Aug 14 Mon 2006 20:09
index?lookup?match?if?
- Aug 14 Mon 2006 20:09
How do I make a particular column required in Excel?
Our NPO is in the process of creating a reimbursement chart for our employees
and we're trying to make it so that if they do not fill in a particular
- Aug 14 Mon 2006 20:09
Cell Word Alphabetization
- Aug 14 Mon 2006 20:09
Dget Function
Hi,
I have two tables, one of them contents database of received material amp;
- Aug 14 Mon 2006 20:09
Full path in title bar
This seems to me a good way to do it.
- Aug 14 Mon 2006 20:09
Removing a Row based on a cell value
- Aug 14 Mon 2006 20:09
I want to fill the cell color based upon the other cell condition
Hi,
Im trying to fill the cell color based upon the other cell conditions. Is
- Aug 14 Mon 2006 20:09
'magnifying' the top end of a stacked column chart
This may be a FAQ, but I cannot find/figure it out.
- Aug 14 Mon 2006 20:09
can i get a cell to countdown with the computer clock in excel
i am in iraq and would like to create a countdown calendar to track the
minutes hours and seconds i have left in IRAQ. i want to try to link it to
- Aug 14 Mon 2006 20:09
Suggested new functionalities for Filters, Pivots and other issues
Although I like a lot the way that Excel handles data analysis (and
especially the Pivot Tables) I think that there is still significant quot;roomquot;
- Aug 14 Mon 2006 20:09
Help with Macro
Hi i'm not to hot on Macro's but can anyone tell me if its possible to write
a macro in excel to do the following?
- Aug 14 Mon 2006 20:09
Conditional Formatting error
I was kindly given the following formula for checking duplicate entries in a
spreadsheet, =IF(COUNTIF(Range1, ??)gt;1,TRUE,FALSE)