Help with a find function

[samM]

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

[bhofsetz]

Sam,

Are you wanting to do this with VBA code or with worksheet formulas? What method are you currently using to find the max for each signal? Post an example of how you are doing it now and we can help modify that to return the positional information.

HTH

[samM]

Hi

I've attached a file as an example.
I'm a pleb so I am recording macros. I'm just using the max function over a range eg, =max(B$2:B$601) to find the peak amplitudes. For each signal (column) They'll be 3-4 peaks where I need to find the max amplitude and associated column A value (position)

I've had to cut a load of data off the file as it is huge and can't be uploaded, but hopefully given you an idea of what the output looks like
Hope I've explained well enough....

Thanks