Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some function problems
1) What function would i need to look down a list and bring back a name that corresponds to the highest number next to it. E.g. finding the highest attendance and bringing back the name next to it? I have done a max function then done a vlookup connected to that but this has not worked correctly. 2) I have a combo box displaying the names of products in a shop and a scroll bar which displays numbers, both have been linked to cells and i have done the appropriate vlookup to bring back the name of the stock in the cell below. What I would like to do is run a macro that will add the number of stock sold indicated by the scroll bar for the product selected by the combo box to the "No. of Stock Needed" on another sheet. How would I do this? (I know how to record macros etc. its just the formula/functions/how to get the round the problem that I dont know. Please help as this is coursework in for Friday! Thanks, Tim -- timmyc ------------------------------------------------------------------------ timmyc's Profile: http://www.excelforum.com/member.php...o&userid=31198 View this thread: http://www.excelforum.com/showthread...hreadid=509422 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Some function problems
A1:A10 has names; b1:B10 has numbers
=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) find the name associated with the max number Max finds value of maximum; MATCH find what row that value is in; INDEX looks up a specific entry in an given array best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "timmyc" wrote in message ... 1) What function would i need to look down a list and bring back a name that corresponds to the highest number next to it. E.g. finding the highest attendance and bringing back the name next to it? I have done a max function then done a vlookup connected to that but this has not worked correctly. 2) I have a combo box displaying the names of products in a shop and a scroll bar which displays numbers, both have been linked to cells and i have done the appropriate vlookup to bring back the name of the stock in the cell below. What I would like to do is run a macro that will add the number of stock sold indicated by the scroll bar for the product selected by the combo box to the "No. of Stock Needed" on another sheet. How would I do this? (I know how to record macros etc. its just the formula/functions/how to get the round the problem that I dont know. Please help as this is coursework in for Friday! Thanks, Tim -- timmyc ------------------------------------------------------------------------ timmyc's Profile: http://www.excelforum.com/member.php...o&userid=31198 View this thread: http://www.excelforum.com/showthread...hreadid=509422 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linest function: data selection problems | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
opening up an english excel sheet onto a french verions - problems with edate function | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |