Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every 'Nth' Item, 3 Formula Methods

See how to:
1. (00:37 min) INDEX and MATCH when we have a two fields (columns): Sample Number and Number To Be Averaged. Use MATCH to lookup first occurrence of each sample number with Exact Match, which only finds first item when there are duplicates.
2. (02:14 min) INDEX function and a "Fill Handle Copy" trick to increment the position of every third item.
3. (03:19 min) Dynamic Formula to look up Every "Nth" item using INDEX function and a formula element that creates sequential numbers based on a start position and the increment between lookup values. ROWS function for formula element that will create sequential numbers like: 1, 4, 7...

[excelisfun]

Excel Magic Trick 1116: Lookup Every Third Item or Lookup Every "Nth" Item, 3 Formula Methods 

See how to:
1. (00:37 min) INDEX and MATCH when we have a two fields (columns): Sample Number and Number To Be Averaged. Use MATCH to lookup first occurrence of each sample number with Exact Match, which only finds first item when there are duplicates.
2. (02:14 min) INDEX function and a “Fill Handle Copy” trick to increment the position of every third item.
3. (03:19 min) Dynamic Formula to look up Every “Nth” item using INDEX function and a formula element that creates sequential numbers based on a start position and the increment between lookup values. ROWS function for formula element that will create sequential numbers like: 1, 4, 7…

[kbasco]

Excellent video! Very interesting approach the 3rd example with ROW function. Could it work with COLUMN function as well?

[MANJEET]

U r No one on the planet can compete u, , , u r the game....

[ExploringExcelAmey]

Index match dynamic formula... that is awesome

[jer]

Using the position changing every nth time did not work. The second method doesnt seem to work on my excel.

[abel]

U could use and send it down, wen u have the support column insted of using index and match

[hizamshahrusmi]

Hi mate, I have one column with thousand of rows. the data was taken from cyclic testing. in one cycle, 10 data are recorded and it contained highest and lowest value (these data I want to extract). so every 10 data, I would like to copy/extract the data at 2nd and 7th. I don't have any idea to do it :(

[Jeffreycripe]

Is there a way to send you a problem and have you educate us on the solution. 
It has to do with the "Today" function.