Forum Discussion

LukeReds's avatar
LukeReds
Helper II
2 years ago
Solved

How to extract elemens from a list using List.Alternate

Hi to everyone, i have this list, numbers from 1 to 12 {1..12},  for extracting 1,4,7,10 i use = List.Alternate(Source,2,1,1)  for extracting 3,6,9,12 i use = List.Alternate(Source,2,1,0)   How ...
Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    = pls try this code

    = List.Alternate(List.Range({1..12},1),2,1,1)

     

LukeReds's avatar
LukeReds
Helper II
2 years ago

hi dufoq3  thank you for your answer, i tried it but i got 1,2,5,8,11

Have i to add a step that exclude the first number? I need only 2,5,8,11

 

  • dufoq3's avatar
    dufoq3
    Community Champion
    2 years ago

    I'm not sure what are you talking about. There is also screenshot with correct result...