Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to calculate the min value in col A subject to text in column B ie;
A B 1 Product Price 2 pen $0.50 3 paper $0.70 4 pen $0.20 I cannot use DMIN because I need to do this calc in a different list, and i am batteling with the criteria section of this function as I cannot refer to two rows for header and criteria, I would like to specify criteria as - "product"=A2 - for instance. Please Help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
SUMPRODUCT vs Text??? | Excel Worksheet Functions | |||
Autofitting a row | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |