How to find column position, if the position is dynamic with every output

I have excel whose output is dynamic, how to find out the column position? i want to use it in Read Range, Range input.

Hi @sudeep_kumar

Welcome to Community!

Could you elaborate your Query by giving Input and Expected output Screenshots?


I have output here in “E” Column, next output will be in “H” column and it is dynamic every output, i want to find the column position whether it’s E or H…
Sorry, i can’t able to attach excel sheet, as it says new user cannot attach excel sheet

Hi @sudeep_kumar

Use the below expression to find the last column position!




thank you very much.


Apology for asking! you have marked your reply as solution, please mark solution to my reply.


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.