- Dec 18 Thu 2008 20:48
VLookup on multiple columns
- Dec 18 Thu 2008 20:48
Worksheet tab in cell
Thanks to this forum, I have learned to use the MID(..Cell(..))
functions to display the worksheet part of a filename in a cell, which I
- Dec 18 Thu 2008 20:48
'close group' options greyed out
Upon opening multiple instances of excel xp\2003, the usual button appears on
the toolbar at the bottom of the screen with a number indicating how many
- Dec 18 Thu 2008 20:48
Error in formula !! and I can't see why
- Dec 18 Thu 2008 20:48
An XML mapping cannot be exported
How to you resolve this,
An XML mapping cannot be exported if the mapped element’s relationship with
- Dec 18 Thu 2008 20:48
can hlookup and vlookup be used in combination ?
can hlookup formula and vlookup formula be used in combination
use the worksheet function INDEX and combine with MATCH in this
- Dec 18 Thu 2008 20:48
How do I get an average for 5 when I need to skip cells?
I need to do a running average of the last five numbers, when some numbers is
a sequence can be changed. For example, for days 1 thru 6, I have numbers in
- Dec 18 Thu 2008 20:48
Protected modules
Is there any way I can unlock password protected macros in VBE, so that I can
remotely amend macros in a shared file without reissuing the published file
- Dec 18 Thu 2008 20:48
Automatic representation of cell values
HI,
here's the query:
- Dec 18 Thu 2008 20:48
Can I write an excel formula to display the file save date?
In Excel 2003 I often use the following formula to display the name (and
path) of the file: