column number

Given this array {0,1,0,0;0,1,0,0} I would like to return the number 2 for the column number where both rows contain a 1. I tried XMATCH(1,{0,1,0,0;0,1,0,0},0) and even XMATCH({1;1},{0,1,0,0;0,1,0,0},0) but none of them worked. Any help would be appreciated

File: Dynamic Column Identifier Formula.xlsm I created this formula to dynamically return the column name based on the corresponding column number. That said, it works intermittently once you get to Column AA. I could understand if it was broken completely at Column AA and beyond, but I cannot...

I am looking for a way to find the column number where a value can be found in a single row range. For example in range F3:Q3, a single value can be found in L3. I need the formula to return the number 7. I would then copy this formula down so I can perform the same calculation throughout the...

This is probably quite a common question but I can't find a suitable answer on the internet. Every time I create an array of probabilities I need to record the row and column number of the max value. An example of such an array is below: <tbody> 11 7 3 1 0 17 11 4 1 0 13 9 3 1 0 7 4 2 0...

Folks: How can I get the column letter corresponding to the column number derived from a match formula? I used the formula: =MATCH(F7,'Headcount'!A1:Z1,0) Note: F7 is the column header name. The cost I'm pulling is under that header in the lookup array. I want to use the column letter to...