Question

Does Index number start from 0 or 1??

  • 2 March 2022
  • 2 replies
  • 18 views

Novice question here, 

 

Got an IF action in my bot which is looking at an excel row, for the index value I want it to always be a certain column (in this instance it's column G)

 

My question is, would the index number be 6 (suggesting that column A and the index starts from 0) or would it be 7 (suggesting that column A and the index starts from 1)?

 

Thanks

Jonny


2 replies

Userlevel 3
Badge +7

Hi @Jonathan Hart​ ,

 

Index Refers to Column Numbers but Index starts from 0 and Name refers to the Header of the Column

Thanks for this, so in my instance where the value I'm looking at is in column G (the 7th column) my source value in the IF string condition source value would be: $CurrentExcelRow[6]$ ?

Reply