Column A           Column B
    em                   5
    mm                   6
    tnk                   7

I hope the format for this post works
I'm new to this newsgroup and newsgroups in general and I hope its ok to add
snapshots to posts....
I created a sheet a while back part of which showed a monthly snapshot of

currently i have a formula (thanks to this NG) that calculates how
many days there are in a month. is there a way to extend this formula
to calculate the number of work days (mon-fri) there are in that
month?

I work in a school which is introducing a new software system for the
teachers (Konosys)
Some of the pages are displayed using Excel and can be printed out but only
if the teacher has Excel (there is an Excel icon and it opens Excel when we

I am trying to enter a formula as below, but it is not accepted.
=IF(G3>0 'AND' g3<251,G3*1.2,0)
Can anyone help with where I am going wrong. With Thanks.

Hi to All,
can anyone please tell me how to remove a drop-down menu from a cell
or column?
Thank you,

I have a spreadsheet that's a membership list for our neighborhood
organization. It has columns listing years in which dues have been paid,
street number, street address, etc.
I now need a clean version of this spreadsheet so I can import a "send

I want to sort from cell a1 to a10 by selecting them and choose sort
ascending.  However, only the cell a2-a10 are sorted, and cell a1 is leaving
out every time I do this.  Is there is bug in my excel or something?

I've created two lists, but when I select a value in one the other
opens and viceversa. I'd like to create two independent lists where
both stay close showing me only the value I select.
Thanks

All of a sudden my dates are change the slash direction.... Why?  And how do
I fix this?????

I would like to have an auto update of all external links each time i open
my excel document.
What is the exact VBA code to use?
thank you,

I am working with 2 sheets and need to be able find a data match on one sheet
and display multiple results on another sheet - here's a simplified version.
sheet 1 named Activities, sheet 2 named Calendar  
Activities sheet will list 100+ activities which will all have a start date. ...

Is it possible to have a summary worksheet in an Excel spreadsheet and then
copy this worksheet on its own to another document but with the numerical
values only?
I have a worksheet which is a summary of various other Excel documents

I'm trying to retrieve a date (in column A) that corresponds with a
Min and Max amount (in columns B:D). Basically I need to know when my
amounts hit their Highs and Lows. Can someone help me with this
please?

An odd issue popped up a couple weeks ago and I have no idea if I changed
something.
Copy something to the clipboard
Open Excel 2007