Hi everyone,
I need help with the following:
I need to search a range and return the column letter if the value in the cell is greater than zero. it needs to return the first column letter (starting from column F to A in example below).
example:
A B C D E F
0 2 0 5 0 0
So if searching through the range, the result should return 'D'
this is my first contribution to the forum, your help is much appreciated,
thanks
Marwan
Bookmarks