# Select by lowest cell value & group by column

Solved/Closed
Related:

- Select by lowest cell value & group by column
- Vba select case like - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- Count if cell contains number - Excel Forum
- Run macro when cell value changes by formula - Excel Forum
- If cell contains date then return value ✓ - Excel Forum

## 5 responses

I don't know if this would help...but if you have Microsoft Excel, this would help a little mathematical wise...other than I'm not so sure....Excel can be helpful...

Yes Raenae, I am using Excel for this. I can workout min value using mathematical function (min), which is okay but once the min value is worked out I would like to copy that information on another sheet matching min value and supplier for that item. Let me know, if you could help me with this. May be you can think of macro or functions witihn Excel. Many Thanks. Cheers, Shital

venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811

Mar 23, 2010 at 11:32 PM

Mar 23, 2010 at 11:32 PM

there is no need for a second sheet.

see the file in this web page

https://authentification.site/files/21590705/shital.xls

first

The formula in L2 is

=MIN(D2:J2)

copy L2 down

THEN the formula in K2 is

=(OFFSET($A$1,0,MATCH(L2,A2:J2,0)-1,1,1))

copy K2 down

you get the needed results.

confirm it is ok

see the file in this web page

https://authentification.site/files/21590705/shital.xls

first

The formula in L2 is

=MIN(D2:J2)

copy L2 down

THEN the formula in K2 is

=(OFFSET($A$1,0,MATCH(L2,A2:J2,0)-1,1,1))

copy K2 down

you get the needed results.

confirm it is ok

Didn't find the answer you are looking for?

Ask a question