LinkBack URL
About LinkBacks
Hello, i have a problem. I need to return cell address of MIN value:
example:
A B C
1 5 2 7
2 4 9 3
3 10 1 5
Result = B3
My function:
=ADDRESS(MIN(IF(A1:C3=MIN(A1:C3),ROW(A1:C3);""));COLUMN(A1:C3))
it return #VALUE
Where is a mistake?
Hello, i have a problem. I need to return cell address of MIN value:
example:
A B C
1 5 2 7
2 4 9 3
3 10 1 5
Result = B3
My function:
=ADDRESS(MIN(IF(A1:C3=MIN(A1:C3),ROW(A1:C3);""));COLUMN(A1:C3))
it return #VALUE
Where is a mistake?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks