G
Guest
Hi,
I'm trying to find out how i can use excel to search through a list of names
and numbers, to find and extract a number that would fit to my criterea.
for example, below is a basic version of my data.
name number
bob 1
mary 2
frank 8
judith 3
now what i would like to do is create some kind of formula that would return
to me, say, the highest number and their name, so it would return:
judith 9
im using it to sort through quite a large list of figures, and i need it to
extract the top 10 figures and names for me.
thanks,
matt
I'm trying to find out how i can use excel to search through a list of names
and numbers, to find and extract a number that would fit to my criterea.
for example, below is a basic version of my data.
name number
bob 1
mary 2
frank 8
judith 3
now what i would like to do is create some kind of formula that would return
to me, say, the highest number and their name, so it would return:
judith 9
im using it to sort through quite a large list of figures, and i need it to
extract the top 10 figures and names for me.
thanks,
matt