Need help with an index formula

[maryren]

I need to be able to look up the highest value in one cell and the lowest number in another cell from a column of information. For example:
[INDENT]Part[INDENT]Reading[INDENT]A[INDENT]100[INDENT]A[INDENT]105[INDENT]A[INDENT]110[INDENT]B[INDENT]90[INDENT]B[INDENT]100[INDENT]B[INDENT]105

For Part A, I would like one cell to populate 100 for the lowest value and another cell to populate with 110 for the highest value.

I assume I can use the MIN and MAX formula, and tried the formula below, but it does not work when there are multiple entries of the same Part #. Any suggestions?

The formula I tried to use was:

=INDEX(A1:A6,MATCH(MIN($B1:$B6),$B1:$B6,0))

[Rambo4711]

I need to be able to look up the highest value in one cell and the lowest number in another cell from a column of information. For example:
[INDENT]Part[INDENT]Reading[INDENT]A[INDENT]100[INDENT]A[INDENT]105[INDENT]A[INDENT]110[INDENT]B[INDENT]90[INDENT]B[INDENT]100[INDENT]B[INDENT]105

Is all data above in one singel textstring? Can you post a sample workbook and show the expected results?

[hemesh]

Is all data above in one singel textstring? Can you post a sample workbook and show the expected results?

You should update the data you are trying to work with as suggested by Rambo. And one more thing are you changing the reference for index and match???

[maryren]

I've attached a sample file. Thanks for your help.

[SDCh]

Try this on C24

Please Login or Register  to view this content.

on C25

Please Login or Register  to view this content.

on D24

Please Login or Register  to view this content.

on D25

Please Login or Register  to view this content.

Note: Array formula, use Ctrl + Shift + Enter

[maryren]

Thanks! This works perfect!