How to find Excel column last second row

  • 30 April 2022
  • 1 reply

Hi, I have Excel with five columns data with N number of records but we need to fetch each column last second row record we needs to fetch. Please do let me know how to find this.please suggest me thanks in advance.

1 reply

Userlevel 6
Badge +9

Hello @Naveen Kumar​ 


Thanks for writing us at the AA forum.


You can check the index values of the column in excel and then retrieve the value based on the column's index.


You can leverage the available bots in the botstore to get the use case function;post_type=product


For assistance through our Support Engineers, please reach us via Support case>


You can also check our Live Chat support option, for quick assistance from our engineers>


You can also search for available documentation in>


For more details, you are welcome to leverage our open source portal where multiple use case is available>