Posted to microsoft.public.excel.misc

Fanny

external usenet poster

Posts: 21

look for text not using vlookup and sum if

Dear Helpers,

I have a long listing below for checking

Name Score
Peter 70
Anna 120
Sam 50
........

I use Max to find the highest score is 120 and I want to use the highest
score to look for the name who gets the highest score.

How to do so,

thanks a lot for your help.

Fanny

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VLOOKUP (with text)	Woody13	Excel Discussion (Misc queries)	3	January 24th 06 07:20 PM
Using VLOOKUP and text	Tara C.	Excel Discussion (Misc queries)	1	December 17th 05 04:40 PM
Vlookup using text	gersumabat	Excel Worksheet Functions	2	November 1st 05 09:18 PM
Vlookup text values	[email protected]	Excel Worksheet Functions	3	July 23rd 05 01:58 PM
Vlookup a value and text	raboone	Excel Discussion (Misc queries)	1	June 8th 05 08:04 PM

All times are GMT +1. The time now is 11:52 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us