Why ExcelAdvanced:Go to cell(end of column of current cell) goes to 1831.row even though there are 641 rows? only

Hi @Semih 3318 ,

The excel you are currently using might had data till 1841 and later on you might have just deleted the data not the whole rows. 

Please find below two approaches: 

• Manually remove the blank rows.
• Apply If condition on a specific column for not blank condition inside the excel loop:
  • Loop(excel rows){
    • If ( CurrentRow{“column name”} =! blank){
      • Increment RowCounter
      • }
    • }
  • After the loop has finished you can use the RowCounter as number of rows.
• Let me know whether the condition works or not