I have an Excel sheet with over 100 dates as column names and hundreds of locations as row names.
There are numbers (could be any number) somewhere in each row that indicate that an event will occur in that location on that date.
I am trying to add a column that locates the first occurance of any number in each row so that it tells me the first date (column) that an event will occur in each building.
I cant provide a file but I can create a set up example if needed. Thanks!