Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Transform csv to qif or ofx format? | Excel Discussion (Misc queries) | |||
How do I transform numbers (different ranges) to text (diff. range | Excel Worksheet Functions | |||
How can I use a worksheet to plot polar coordinates? | Charts and Charting in Excel | |||
Using Air Coordinates in a Worksheet | Excel Worksheet Functions | |||
How do I convert numbers into words in excell worksheet? | Excel Worksheet Functions |