目前分類:title (5957)
- Nov 21 Wed 2007 20:40
Cell data format
- Nov 21 Wed 2007 20:40
if statement with #N/A
Hi,
I need help to write a formula in excel. I want to use vookup to look up a
- Nov 21 Wed 2007 20:40
Retrieving data from the web
- Nov 21 Wed 2007 20:40
Tabbing
Hi Danny, (navigation after a change event via macro)
Thanks for sending the worksheet. (reply posted to misc)
- Nov 21 Wed 2007 20:40
microsoft.public.excel.worksheet.functions
Looking for a way to make the cells in column B based on the contents
of cells in colum A (text string) show as below please?
- Nov 21 Wed 2007 20:40
dropdown list
- Nov 21 Wed 2007 20:40
Copying records to another sheet
- Nov 21 Wed 2007 20:40
Can someone tell me what VBA means? (Macro and VBA)
- Nov 21 Wed 2007 20:40
What does ^ do in this formula =B8*(1 $C$1)^(($C$3-$C$2)/365)-B8
I was sent a spreadsheet that is supposed to calculate interest earned. It
has a character in the middle of the formula that I have not seen before.
- Nov 21 Wed 2007 20:40
NA()
Actually I have 1 more question ;-). Let's say that in cell A1 I can have
values quot;yesquot;, quot;noquot; and quot;#N/Aquot;. I wanna set up a formula which will say that
- Nov 21 Wed 2007 20:40
Counting multiple criteria involving dates
Hey everyone,
- Nov 21 Wed 2007 20:40
Custom Filter not functioning
I have a large workbook with several similar versions of data. On the most
current sheet I cannot filter a column of numbers with the custom gt; and lt;
- Nov 21 Wed 2007 20:40
format a cell to accept a date or a whole number
I need the cell to accept a whole number as an age or date of birth
- Nov 21 Wed 2007 20:40
find exact values of SQRT
I am attempting to find a value using a series of repeditive formulas. I am
getting an #NUM error, which I know is wrong.
- Nov 21 Wed 2007 20:40
Conditionally formatting highest valued cell?
I have 7 rows in the same column of type percentage. I'd like to turn
the text of the highest valued cell red. How exactly is that done with
- Nov 21 Wed 2007 20:40
key board short cut for insert cut cells
I use a solid black row as a book mark/visual reference. As I reconcile I
move the black row down the page.
- Nov 21 Wed 2007 20:40
get rid of page 1 watermark
I like the way that Page Break Preview blocks out in grey the rest of the
worksheet that you're not using.
- Nov 21 Wed 2007 20:40
Adding Values from Formulas
I'm sure there is a very easy way to do this, but right about now my brain is
fried.\
- Nov 21 Wed 2007 20:40
how to change font size of datalabels of two charts in a sheet
- Nov 21 Wed 2007 20:40
How do I run dates consecqutively for appointment pages?
I'm trying to create a yearly (one page for each day of the year) appointment
calendar. How do I create the formula to carry through the year attached to