Dear All
I have a data layout like below.
Cell A1, C1, E1, G1....... coloumn header "UNIT"
Cell B1,D1,F1,H1 ...... Column Header "Amount"
Data starts from A2
in Cell S2 I want the minimum unit value for the range A2:R2
Help me to find the minimum unit value, ignoring the Amount column.
.
I have a data layout like below.
Cell A1, C1, E1, G1....... coloumn header "UNIT"
Cell B1,D1,F1,H1 ...... Column Header "Amount"
Data starts from A2
in Cell S2 I want the minimum unit value for the range A2:R2
Help me to find the minimum unit value, ignoring the Amount column.
.