Hello community ppl,
I have a small quastion that will require some special VB knowledge which I
don't master.
I would like to make a treeview in excel, where each sub folder comes one

I'm fairly new to Excel and am trying to replicate a spreadsheet I used to
use at work.
Basically, in column B I have a date some time in the future. What I am
trying to get in column A is a formula that will update every day to tell me

I have inherited a spreadsheet that uses conditional formatting to show by
color when a time is a little over and a lot over.  Some how they converted
the time to a decimal point, but it does'nt make sense.  Unfortunately, it
does'nt seem to transfer from different pages in the ...

Dear Sir,
I wish to extract the last 6 characters if a cell in column A has 13
characters, otherwise only extract the last 3 characters.
Illustration:

I had a doubt on how to add a new filed in page area of pivot table, but
that filed is not existed in source data.
In other words, I wanted to place new filed called 'MONTHS' in page area of
the pivot table. when the user clicks on dropdown list it has to allow to

Many here are saying to just "save as" the older file format .xls.  Why is it
that we've (us users) accepted this as the only solution?  It doesn't seem to
make much sense to me that this is the accepted solution.  It seems pointless
to buy/use new software only to have to save ...

I don't see a way to make a negative percentage (-29%) show up in red.
Do I have to use conditonal formatting, or is there an easier way?

This formula is not working.  Can you please help me correct it?
=IF(AND('Employee Attendance'!3:3>DATEVALUE("4/1/08"),'Employee
Attendance'!3:3<DATEVALUE("4/31/08")),"","Yes")
If any cell in the line has a date of 4/1/08-4/31/08 entered, then I need it

This is probably something that should be easy to do, but I am having a
block...
I am a track coach, and I want to be able to have my alphabetical roster
displayed to post for a meet with the events the kids are entered in listed

What I am trying to do is create a drop down list where the department is
shown in the list (Art, Style, Photography) but once the name is selected,
the department number shows up.  For example, if someone chose Art, I want
the department number to show up in the cell (1000).  

I am a pool league team captain with 5 players.  The problem is that not all
of the players have showed up to play each week, but yet at the end of the
season they are wanting their equal share of the prize money awarded.  I am
not going to give a player that has only been there ...

I need help with a formula for a project I am working on...  A sample of what
I need is below.
                     Accept          Decline        Sponsor
Alicia                  x                                 Cathryn

In a Excel 2007 file I have 1A,1B,2A,2B,3A,3B..... If I sort the file
10A,10B,11A,11B sorts in this order. How to make sort in 1A,1B,2A,2B,3A,3B
order?
Thanks for any replies.

I use the Journal facility in outlook to record Excel, Word & Emails from
selected contacts.  I went in today to find something and for some reason
entries fro Excel and Word appear to have stopped in November 07 event,
though emails have been recorded since then.  The settings ...

Im working on an assignment and i've been asked to explain the term " Cross
Totalling"