function how to!

  • Thread starter Thread starter FoSi
  • Start date Start date
F

FoSi

hi all...
i dont know very much of excel... so im a really newbie on this...
but i need to know how do i do this..
so..
i have a table with books and their respectives prices!
like:
booka | 10.00
bookb | 50.00
bookc | 20.00
bookd | 12.00

and what i want to know! what is the function/formula so i can have a
cell with the maximum value/price (=max) but also with another cell
nexto to it with the respective name of book (bookb, in this case)

just like this:

highest price:
bookb | 50.00

how can i do this??
i know its very simple... well... it looks like!

prices:
booka 10
bookb 50
bookc 20
bookd 12

max price:
bookb 50


can someone please helpme?
 
=INDEX(A2:A100,MATCH(MAX(B2:B100),B2:B100,0))

is one way, of course if there are 2 books with same price it will return
the first occurrence

--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
try this where max finds the largest number and match finds the row and
index shows one to the left.
=INDEX(I1:J100,MATCH(MAX(J:J),J:J,0),1)
 
hmm...

im getting a error!

what im doing is this:
=indice(A1:A3,corresp(maximo(B1:B3),B1:B3,0),1)
or in english:
=index(A1:A3,match(max(B1:B3),B1:B3,0),1)

im gettin a error on here "A3,corresp" or "A3,match"

in both of the solutions you gave me
what seems to be the problem?

my table:
book | price
A1 | B1
A2 | B2
A3 | B
 
Are you using wrong delimiter? Try

=indice(A1:A3;corresp(maximo(B1:B3);B1:B3;0))




--
For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
Thank You all... for the help
it works... just well

:)

this last error... was becouse of the commas!

best regard
 
Back
Top