If the cell contains..., do something
目前分類:title (3013)
- Jul 20 Thu 2006 20:08
If the cell contains..., do something
- Jul 20 Thu 2006 20:08
How do I count wildcard text meeting certain criteria in EXCEL?
I can't figure out how to count occurrences of a wildcard matching certain
criteria. For example, let's say I want to count the number of cells
- Jul 20 Thu 2006 20:08
y value vs x
In an xy scatter plot one can choose the type of line connecting the data
points (smooth, straight, etc.). Once this is done, Is there a simple way of
- Jul 20 Thu 2006 20:08
change cell size from page to page on the same worksheet
I'm trying to change the cell height and wideth on different pages within the
same worksheet. I have over 40 pages on the same worksheet and some need to
- Jul 20 Thu 2006 20:08
I messed up and need help
- Jul 20 Thu 2006 20:08
MUltiple functions on a same cell
- Jul 20 Thu 2006 20:08
Calendar conversions
- Jul 20 Thu 2006 20:08
Include a password in VB code.
Can anyone help please.
- Jul 20 Thu 2006 20:08
Single or Double Quotation Mark and it comes up twice
When in Excel and I try to enter a single of double quotation mart nothing
happens, and when I try again I get two single or double quotation marks.
- Jul 20 Thu 2006 20:08
Can't open an Excel file from Explorer, only from Excel
I have a strange problem that has just started. I am running Windows XP
and Office XP. If I click on an Excel file in my folders in explorer, it
- Jul 20 Thu 2006 20:08
Paste results consecutively within column (based off other worksheet)
I have a few worksheets that pull data from another worksheet. In the
third column of the main data is a number from 0 to 5, with many 0's.
- Jul 20 Thu 2006 20:08
filtering repeat data
i have a worksheet that contains a list of 46,000 phone numbers and I would
like to filter out the phone numbers that repeat more than 5 times but less
- Jul 20 Thu 2006 20:08
Is it possible to use 2 different fonts in 1 excel cell?
- Jul 20 Thu 2006 20:08
Automatically Refreshing Data at 12am
I want to refresh my data automatically at 12am every day. does
something like this make sence?
- Jul 20 Thu 2006 20:08
How do I show numbers in Excel as 48K instead of 48000?
I have large numbers in Excel, i.e. 48,760. I want to display it as 48. The
column heading will indicate the number is in thousands. I can't find a
- Jul 20 Thu 2006 20:08
Keyboard Shortcut
I have two Excel workbooks open, displayed side by side. I can't remember the
keyboard shortcut for moving the cursor back and forth between the two
- Jul 20 Thu 2006 20:08
triggering an email alert from within a spreadsheet based upon a d
This will sound like a silly question, but I would like to know if it can be
done just the same.
- Jul 20 Thu 2006 20:08
Charts different data sources
Hi,
- Jul 20 Thu 2006 20:08
Conditional Formatting
Is there anyway i can set up a condition or formula to change the color of 8
cells within a row if one of these cells have the word Holiday.
- Jul 20 Thu 2006 20:08
NPV calculations at the end of future years
Do I use the net present value function (PV) to get an answer of (negative)
-37,565 if we have a cash outflow of $50,000 at the end of the 3rd year at a