Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for Conditional Format
I have range A2:C10000 as
item--------------Supplier----------Price col A---------------Col B------------Col C pen ----------------Abb ------------1.90 pen ----------------Cad ------------2.00 pen ----------------Ham -----------1.95 Book---------------Cad -------------3.20 Book----------------Ham -----------4.50 Book ---------------Abb -----------3.50 Book ---------------Jal ------------3.10 Ink ----------------Abb------------21.50 Ink -----------------Bom-----------21.00 What formula is to be used in Conditional format to get lowest bid price of each item and the supplier(Col B & Col C) . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Date format changes to formula | Excel Discussion (Misc queries) | |||
Format Issue | Excel Worksheet Functions | |||
keeping cell format with formula | Excel Worksheet Functions | |||
Convert Excel 4 formula to Excel 2003 format | Excel Worksheet Functions |