Tenspeed39355
06-02-2010, 06:27 AM
Hi Dude I have looked over the web for the answer but I cannot find what I need so here goes. I am in Sheet2 it blank and A2 is highlighted. I want to go to Sheet1 and find the Maximum value of G2:G24. The return is a percent. I want to bring that number and the Symbol from sheet1! The symbols are in Sheet1 column A2:A24. I would like the symbol to be in Sheet2 A2 and the number in Sheet2 B2.
Can you help me with this. I have tried using the Max, match commands but no good. Thanks again for your help. By the way I gave the previous problem five stars.
Max
Can you help me with this. I have tried using the Max, match commands but no good. Thanks again for your help. By the way I gave the previous problem five stars.
Max