Searching Function

[Ather]

Categories Jul-23
Card Loading Problem 15
Coverage Complaint Indoor 24
Coverage Complaint Out Door 64
Coverage_Call Drop 5
Gsm Network Congestion Complaint 15
Hi Tunes Info/Complaint 23
IDD Complaints 1
Silent Call 3
SMS Message Not Sent 8
Value Added Services Complaint 17
Grand Total 175
Total Complaint Day Wise 578
Percentage 30.3

*please any on help about

Actually, this is a complete sheet with day wise data of complaints I
want to know the greater complaints another cell for each day. I use
max to find the maximum number but how to find the complaint
description against that because vlookup only works for the left
side .

Thanks in advance

rana

 

[Pete_UK]

You use an INDEX/MATCH combination - MATCH finds the location (row) of
the maximum and you use that within INDEX to extract the category.

Hope this helps.

Pete

 

[Earl Kiosterud]

Ather,

One oft-used solution is to sort the table, descending, on the second column. That puts the
highest complaints at the top, and works its way down.

--
Earl Kiosterud
www.smokeylake.com

Note: Top-posting has been the norm here.
Some folks prefer bottom-posting.
But if you bottom-post to a reply that's
already top-posted, the thread gets messy.
When in Rome...

 

[Ather]

Thanks but any one help what is the proceedure (syntax) about index/
match functions. could any one tell me the logic/back ground of these
functions.

regards,
Sohail Ather

 

[Dave Peterson]

I think...

=index(a2:a999,match(max(b2:b999),b2:b999,0))

Take a look at Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions03.html