Column number
Faby wrote:
How can I retrieve the column number of a cell in a specific row.
ie i want to get the column number of a cell in row 3 that holds the
value "successful" for instance
Thanks
Faby
If you are searching the row for a specific value then use the MATCH
worksheet function using the row itself as the lokup array. The MATCH
function will return the offset at which the value was found.
|