| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Should I use INDEX?
Hello,
I am thinking of using INDEX function, but not quite sure how to approach it. Here is my sample data. I need to produce the last column with a formula. Any ideas? If Column A is the same then what is the lowest value in Column C then the answer is in Column B. Results needed 9876 ABC Divison 145 Smart Move 9876 Smart Move 112 Smart Move 1234 Textile Co. 456 MMM Inc. 1234 MMM Inc. 78 MMM Inc. 1234 YAM 345 MMM Inc. 1234 Bee Corp. 154 MMM Inc. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use INDEX?
One way is to sort them by Col A x Col C
then enter this in D1 (assuming no header row) =A1 then this in D2 =IF(A2=A1,D1,B2) and copy it down... "MrRJ" wrote: Hello, I am thinking of using INDEX function, but not quite sure how to approach it. Here is my sample data. I need to produce the last column with a formula. Any ideas? If Column A is the same then what is the lowest value in Column C then the answer is in Column B. Results needed 9876 ABC Divison 145 Smart Move 9876 Smart Move 112 Smart Move 1234 Textile Co. 456 MMM Inc. 1234 MMM Inc. 78 MMM Inc. 1234 YAM 345 MMM Inc. 1234 Bee Corp. 154 MMM Inc. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Should I use INDEX?
Sheeloo,
Not sure if this works for me. Is there a way to utilize INDEX and LOOKUP features? I tried this and it did not work. MrRJ "Sheeloo" wrote: One way is to sort them by Col A x Col C then enter this in D1 (assuming no header row) =A1 then this in D2 =IF(A2=A1,D1,B2) and copy it down... "MrRJ" wrote: Hello, I am thinking of using INDEX function, but not quite sure how to approach it. Here is my sample data. I need to produce the last column with a formula. Any ideas? If Column A is the same then what is the lowest value in Column C then the answer is in Column B. Results needed 9876 ABC Divison 145 Smart Move 9876 Smart Move 112 Smart Move 1234 Textile Co. 456 MMM Inc. 1234 MMM Inc. 78 MMM Inc. 1234 YAM 345 MMM Inc. 1234 Bee Corp. 154 MMM Inc. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| How do I pull the col. index value as well as row index value | Excel Discussion (Misc queries) | |||
| Index and Row | Excel Worksheet Functions | |||
| Index Row | Excel Worksheet Functions | |||
| Using Index(A:A,.........) | Excel Worksheet Functions | |||
Hybrid Mode
