Hi everyone,

I wonder if you'd be kind enough to help me-
I have a system that outputs into excel. It produces a table in which the first column gives positional information and the following columns provide amplitude information for each of 10 signals (10 columns) I need to find the position value relating to the maximum amplitude of each signal.

I use the max function to find the amplitude information but I can't work out how to then make it relate back to it's positional information in column A.

Any ideas?

I would appreciate any help that you may have,

Thanks

sam