Find Column number in Excel/Sheets/Numbers

[Buchholdt]

Hi guys,

 

I use spreadsheets quite a bit, and would love to be able to lookup e.g. column BQ and see that it equals column number 69.

 

Today I have a browser tab open with this, that helps me calculate the column to a number.

 

Have any of you seen a workflow that can look this up, or how would you create a workflow like this?

 

Best regards,
René

[giovanni]

try this!

!col followed by the column name

 

[Buchholdt]

WOW giovanni,

This is so cool!

I have looked into you code, and see that I would not have been able to put this together. You have really but some thoughts into how the workflow is from a user perspective😀 and making it better then my "mental version" was.

 

Thank you very much for the help here, I will use this tool every day.