How to do the following:
1) Return the cell reference of the cell
eg:
Type this formula in cell A1:

I have a spreadsheet with one column of employee's job titles.  One of the
other columns shows if they work full time or part time.  There are several
employees with the same title who work either full time or part time.  I need
a formula which calculates how many employees with ...

Is there a user defined function in excel which can get the share quotes
over the internet from Yahoo Finance website?
Thanks
Mukesh

Hi, I would like to move a range of data within a row from one sheet to
anouther sheet automatically when the data in a cell within the range
that would be moved, is greater than zero. Is there a formula that will
do this?

I need a formula that references a cell (say C2) of one of the worksheets
called U3, U4, V3, V4, etc.
However, the worksheet to use depends on the value of two other cells (A1
and B1). For example, if the value of A1 is U, the value of B1 is 3, then

I need to replace/delete the " >"  character at the end of a number...
when the data was brought into the excel 1234> was the number that cam
it happens in about 7000 lines
any suggestions on  how to replace it with a blank??

I have a function that will pull data from a cell on another sheet:
=RIGHT(Sheet1!$B$1,LEN(Sheet1!$B$1)-FIND(":",Sheet1!$B$1,1))
the problem is that I want to pull the same cell data from hundreds of
sheets (sheets 1 to 200) and list the cell data in a column.

=COUNTIF(B6,{">0","<5"})
When I type a value which is larger than 1, it always returns the count as 1.
When I type a value which is 0 or lower, it always return the count as 0.
What's wrong?

Hello,  as you can see by the title, I am pretty annoyed at excel
copy/paste clipbaord that keeps popping up everytime I copy a cell.
BEFORE YOU ANSWER...please do this quick easy exersice in EXCEL 2002.
You need to do this to understand what I am talking about....so try i

Thanks again for all the help.  I've got another question though.
How to I hide an entire row (A16) if A17 - A23 ALL have vaules that = 0 (Not
null but the number zero).
Thanks again,

I have a workbook with 20 sheets. All these sheets have the same coloumns.
To make a pivot table, I want to merge all these sheets into a single
sheet.Is there a quick way?
Thanks in advance

I'd like to compare two sets and report a result that shows how one data
set would plot if related to the other set (sorry, I know that's poorly
worded). Here's an example:
Sample #1               Sample #2

   Back again with another Q.  Is it possible to create a macro or
something so that when you print, it will autmoatically hide rows within a
certain rage when a column's value = 0 (the number zero not null)
Example.

Please post response as email is bogus to prevent spam.
I am using Excel 2003.
I am filtering information and want to count the number of instances
(rows) returned by the filtering.

I have classwork to perfoerm on EXCEL, but I am unable to use the Chart
Wizard because it is grayed out, and unavailable. I have made certain that I
have selected ranges with data in them, so what do I do next???