Can you attached a file as example.
For the closest enter somewhere =MIN(IF(A1:A81>0,A1:A81)) with CONTROL +SHIFT + ENTER
Can someone help me to make a code where I choose the number closest to zero (it has to be above zero and not zero). I have cells from B2 to S81 with number close to zero. But I am actually interested in cells from A2 to A81 for my work so I need a coupling between these cells.
Cells with connections are: example A2-I2, A13-P13 to A75-C75
Thank you for your help
I need something like this http://www.ozgrid.com/forum/showthread.php?t=42000
but not for a row of numbers but for a square of numbers (sorry for my bad use of word )
There are currently 1 users browsing this thread. (0 members and 1 guests)