Help
Aaron,
Try:
At P6 : =min(c5:p5)
At C6: =if(c5=min($c$5:$p$5),1,0) and copy this to D6:P6
"JE McGimpsey" wrote:
One way:
C6: =--(C5=MIN($C$5:$P$5))
Copy over to P6.
In article ,
Aaron wrote:
I need to find the lowest number in a particular row. For instance, my range
is from cells C5:P5. I want to find the lowest number in this range, then in
the row directly below it, I want to put a "1" underneath the cell with the
lowest number, and a "0" into every other cell with a number above it. I am
not sure how to do this. Any help would be appreciated...Thanks
|