| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare two cells with same name
Hi,
I would like to Compare two cells with the same name ie. I1A215 and put "LP" against the lower number but not compare two different names ie. IA219 with IA227 as shown below. I1A215 7567.16 LP I1A215 9324.94 I1A219 5372.08 LP I1A219 7127.87 LP I1A227 7130.59 LP I1A227 8307.19 I1A233 1983.48 LP I1A233 3404.38 Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare two cells with same name
You can use this array* formula, adjusting ranges as needed:
=IF(B1=MIN(IF($A$1:$A$8=A1,$B$1:$B$8)),"LP","") *Confirm formula using Ctrl+Shift+Enter, not just enter. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Hamps hump" wrote: Hi, I would like to Compare two cells with the same name ie. I1A215 and put "LP" against the lower number but not compare two different names ie. IA219 with IA227 as shown below. I1A215 7567.16 LP I1A215 9324.94 I1A219 5372.08 LP I1A219 7127.87 LP I1A227 7130.59 LP I1A227 8307.19 I1A233 1983.48 LP I1A233 3404.38 Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare cells in a row | Excel Discussion (Misc queries) | |||
| CAn IF compare two cells? | Excel Worksheet Functions | |||
| Compare 400 cells to one | Excel Worksheet Functions | |||
| How do I compare cells and if FALSE compare to next cell in EXCEL | Excel Worksheet Functions | |||
| Compare two cells from reference cells | Excel Worksheet Functions | |||
Linear Mode
