"anzimark" wrote in message
...
As a new user of Excel, I seem to be having trouble finding a formula to
show
where the most positive or negative numbers (as in a string of values)
occurs
in a column. I don't need to count or sum the values, just show where the
most occurences are found in the data itself. I'm sure this is a simple
fix,
but I sure am struggling here! Thanks to anybody who can help.

Not sure what you are looking for, but if your data are in column A, you may
try this formula:

=ADDRESS(MATCH(MAX(A1:A10),A1:A10,0),COLUMN(A1))

Change the range A1:A10 to fit the size of your data.

It will give you the address to the cell with the maximum data.
If there are more than one cell with the maximum data, you will get the
addess of the first one.
Change MAX to MIN to get the address of the cell with minimum data.

Hope this helps / Lars-Åke