Forum Home
Press F1
Thread ID: 6975	2000-12-20 02:26:00	Excel worksheet	Guest (0)	Press F1

Post ID	Timestamp	Content	User
7667	2000-12-20 02:26:00	In Excel, I have data consisting of two columns - one being name of outlets and the other percentage productivity values. Ina cell in the next sheet, I have used the function MAX to return the highest value of productivity from range of percentages in the previous sheet. Next to this cell I want to return the name of the outlet corresponding to this value from the other sheet. Could you please suggest what function or macro I need to set up or use. Thanks	Guest (0)
1