View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fespin fespin is offline
external usenet poster
 
Posts: 1
Default how to transform numbers to excell worksheet coordinates

I need to average some electival events and for that I need to align them.
The data is in text format where one column is time and the other corresponds
to the amplitude of a signal that varies according to presence of the events.
I have the time flags corresponding to the start of each event and would like
to convert those numbers to coordinates of a worksheet. For example: if
column A is time, column B is the signal and there are 3 events (time flags
7,25 and 93 in columns D, E and F) I want to use those time flags as
coordinates to go an retrieve the ampliude of the signal (in column B),
where, when converted, the formula in columns D, E and F shoud read: =b7,
=B25 and =B93.


Thank you for your help