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 can i extract 2,5,8,11?

 

Thank you!

Need Help
  • Ahmedx's avatar
    Ahmedx
    2 years ago

    = pls try this code

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

     

6 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    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...

  • LukeReds's avatar
    LukeReds
    Helper II
    2 years ago

    ts correct i was searching a way for using onlyList.Alternate, but its not possible