A list or set parameter iterates in the order the cell wrote it

All 4 scenarios hold

Both input columns hold the same elements in the same order.

expected outcome broken scenario
ScenarioList inputSet inputIteration order?
Written ascending
  • 1
  • 2
  • 3
  • 1
  • 2
  • 3
  • 1
  • 2
  • 3
Written descending
  • 3
  • 2
  • 1
  • 3
  • 2
  • 1
  • 3
  • 2
  • 1
Written unsorted
  • 3
  • 1
  • 2
  • 3
  • 1
  • 2
  • 3
  • 1
  • 2
Reverse alphabetical
  • c
  • b
  • a
  • c
  • b
  • a
  • c
  • b
  • a