Excel Formula
Closed
Barb
-
Oct 22, 2009 at 12:02 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 22, 2009 at 10:15 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 22, 2009 at 10:15 PM
Related:
- Excel Formula
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Transfer data from one excel worksheet to another automatically formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 22, 2009 at 10:15 PM
Oct 22, 2009 at 10:15 PM
INE2 type this formula
=INDIRECT(ADDRESS(1,MATCH(MIN(A2:C2),A2:C2,0)))
copy E2 down
It happens that the minimum in each row of your data is in col. 3
try with this data
Co A Co B Co C
$4.44 $3.75 $2.31
$25.00 $44.31 $36.43
$55.44 $42.00 $44.29
D2 will have formula
=min(A2:C2)
E2 will have above formula
copy D2 and E2 down.
=INDIRECT(ADDRESS(1,MATCH(MIN(A2:C2),A2:C2,0)))
copy E2 down
It happens that the minimum in each row of your data is in col. 3
try with this data
Co A Co B Co C
$4.44 $3.75 $2.31
$25.00 $44.31 $36.43
$55.44 $42.00 $44.29
D2 will have formula
=min(A2:C2)
E2 will have above formula
copy D2 and E2 down.
