Sheriff
02-07-2010, 07:11 AM
I've been messing around in Excel for a while for some work I have to do for a class. I can't find how to do the following, so if someone know how to do it, I'd like to know how it works.
Say you have a table with three columns. First one is a Distance, second one is some value, say Force1, third column would be Force2. The sheet calculates the value of each force for each distance. Then, I have to output the maximum force, and the distance at which it occurs in another place. I have no problem outputting the max. force, but I can't find how to make Excel find the associated distance.
I use Excel 2007 if it makes any difference.
Say you have a table with three columns. First one is a Distance, second one is some value, say Force1, third column would be Force2. The sheet calculates the value of each force for each distance. Then, I have to output the maximum force, and the distance at which it occurs in another place. I have no problem outputting the max. force, but I can't find how to make Excel find the associated distance.
I use Excel 2007 if it makes any difference.