I have a data with stocks (shares)  purchased date and sold date
Along with a price.  I want to calculate my daily amount invested in
stock market can someone tell me how can I see :
bought      entry $      sold         price $

I have a sheet with 8 columns that records the courses that people in the
company go on. The heading are: Rec ID, Name,  Dept,  Team,  Course,  Cost,
Status, budget.
Each row is unqiue and probably reach 100. (I understand to use match that I

I cannot get color fill in excel to show on the screen. I can see it in the
preview page only

I am trying to create a course catalog for online learning. I have created a
matrix where I have courses listed down the left hand side and job titles
accross the top. I want to be able to click in the boxes under the job titles
to assign courses and have the information for each ...

I have a football pool spreadsheet that has 20 'sheets', 1 for each person in
the pool.  The 1st sheet has a combined summary of who has bet on what teams.
This will be hidden and seen only by me, since I am updating the final
scores.  The rest of the sheets need to be protected ...

Sorry to do this as i think its a very basic formula its just i dont use them
often..
I need to calculate Z5 - X5 but not if Z5 is blank (or zero). Any help would
be great or where exactly i should look as ive tried a few different formulas

hi - I want to report a fixed value of '1' if the term 'defect raised'
appears in a range of cells, regardless of frequency.
the current formula I have is =COUNTIF(D49:M52,"defect raised")
but this reports the frequency instead of the value 1.

I need to know how can I get excel to record System time in excel when I
press a combination of keys

In my worksheet I have a list of scores in column B, and in column A the
corresponding question.  What I'd like to do is show a list in another
worksheet of the top 3 scoring questions in decending order.
Example: data sheet (comma seperated)

Where do I enter a string in the "worksheet code" to automatically
alphabetize my worksheet by the names in the A column.  I have the string, I
just don't know how to access the worksheet code???
Private Sub Worksheet_Change(ByVal Target As Range)

I have a table for Cancer Treatment and I would like to autofill a particular
field.  To determine the data to place in the desired field, it must check
four values (set up now as drop down lists).  What I would like to see is
that once the four values are chosen, it will ...

Hello from Steved
The below formula will find the last day off each month
My question is please What Formula would I use to find a individual day, for
example 6th off June

I am using the spreadsheet as a tracking mechanism, how do I format a cell so
it will only take a certain entry.  For example, the formula is set to only
count s1 or s2 or s4.  If someone hits s5 one data entry, I want the cell to
reject it.

Gurus,
Hope you can help me out once again.  You guys/gals ROCK!
I have a worksheet that contains survey results and in one column there are
the results of a ranking exercise.  The survey respondant enters a list of

Hi, I am bit of a novice so please be gentle.
Would like to create a worksheet to keep track of Baseball Standings.
So if Score in cell C2>C4 then G2=B2
and of course