Excel MS Excel - MS Office 2010


Joined
Jul 11, 2016
Messages
1
Reaction score
0
I have a data gathering spreadsheet which has a collecting table/array. The data is collected at minute intervals (rows) and gathers 6 successive values (between 0.1 & 0.99) at 10 second intervals in columns (x rows by 6 columns). I need a formula that allows me to find the latest occurrence (minute) of a specific value. I have tried INDEX/MATCH which works with an individual column but not across the whole array. Anyone have a solution or an idea? Thanks
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top