Excel MS Excel - MS Office 2010

N

NickCee

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
 
Back
Top