I am trying to figure out the formula I need to use to bring back the price
grouping.
Sheet 1                          A3
A1           A2                  List     Dist.     Mark Up     New List    

I've got a workbook with two sheets - one is a list of names, and another is
a two-column array in which every name has multiple entries, and each entry
consists of the name and a percentage.
On the first sheet, I'm trying to create a tally next to each name of how

Hello, how can i round a number to the closest tenth?
i would really be happy if someone answered....!

I want to create a user-friendly grade sheet for an exercise within a course.
Each of 4 days of student work is considered separately for this score and
all days are rated on a Likert scale.  The check boxes seem appealing as an
option to make this form as simple as possible for ...

I am trying to get a note on a workbook like when I put my cursor on the
workbook before I even open it I want it to have a note pop up with the last
modified date.

can "real time" from your computer be linked to a cell as a function?

How can I check for #Value! in a cell?  ie If(c4 = #Value!, 0, 1).
Alternatively, is there a way of looking for the maximum value in a column
based upon a second column meeting a certain criteria?
The example is

Where do i find the numbering add ins for Excel 2000?  I receive a message
every time I open a document that says:  I must load them for optimal
numbering and toolbar behavior.   I have looked in the add ins by going to
add remove program, selecting Microsoft office, then change, ...

Perhaps this is a silly question, but i just can't figure out how to
format this worksheet. The problem is that a lot of the cells have
numbers in them with negative signs in the back instead of in the front
(ie. 23-) and i was wondering if anyone knew of a macro/formula i could

Hey all,
I have a workbook which contains allot of data which is all brought
together on a front sheet via a drop down box and this formula:
=INDEX(Data2!$C$2:$C$325,MATCH(INDEX(Reference!$B$2:$B$7,Reference!$C$9,1),IF(Data2!$B$2:$B$325=

Hello Experts!
I usually post for help in the programming section.
I'm looking for a formula that looks at a range of cells (say A1:A20)
and retrieves the value within that range.

I have a long formula that I have applied in multiple cell once it is in
the cell I need this formula to be absolute.
Is there an easy way or do i have to go into each cell and add the $??
=IF(AND('1'!$A70="yes",'1'!$AP70="yes",'1'!$AT70="Express",'1'!$D70="yes"),0.5 ...

Another user helped me with some of the functions in this file, and the
problem is that I have one bug I can't fix. There are four sheets. The
first two sheets contain different types of scores.
The fourth sheet ranks each of the different types of scores on both

I don't know much about coding macros and was hoping someone might provide
some advice. I have a workbook, with 50 or so worksheets querying 50
different URLs from one company. The company has changed their URLs from
http://www.ntn.com/hospitality_tech/players_corner/site.asp?id= ...