Need Help Comparing Cells

M

Matt H

Hi all,
here's my dilema. I have about 4000 entyries in a table that gives peoples'
id number as well times. Is there a way for excel to compare the id numbers
and take the earliest time from any id numbers that are the same?
 
P

Peo Sjoblom

=MIN(IF(A2:A4000="ID_Number",B2:B4000))


entered with ctrl + shift & enter


remove the quotations if the id number is numerical and not a text number


--


Regards,


Peo Sjoblom
 
M

Matt H

I'm a little confused so just to make sure everyone gets it

A B C
ID NUMBER Times
1 10:00 AM--->
2 10:10 AM--->
3 10:30 AM
3 10:20 AM--->
3 10:31 AM
4 12:05 PM---->
4 12:09PM

In Column C i would like to get the selected values into column c and if no
value get transfered into column c, the cell will just be blank.



Also, what does
"enterd with ctrl+alt+shift mean"

Thanks for all your time and effort.

-Matt
 
I

Ian Grega

Matt

It is entered with ctrl + shift & enter not "ctrl+alt+shift" and it means
that you are entering an array formula. Simply hold down the Ctrl and Shift
key and press the Enter key. Excel puts squigly brackets around it to
indicate that it is an array formula. Every time it is edited it must be
entered this way, you cannot type the brackets in yourself. Read up on array
formulas if you need to know more.

Peo's elegant equation will enter the minimum time for each ID No in column
C, if you only want an entry in Col C where that row is the minimum time then
the following variation will do this, again it must be entered with
Ctrl+Shift & Enter

=IF(MIN(IF(A$2:A$4000=A2,B$2:B$4000))=B2,MIN(IF(A$2:A$4000=A2,B$2:B$4000)),"")
 
M

Matt H

Thanks so much

Ian Grega said:
Matt

It is entered with ctrl + shift & enter not "ctrl+alt+shift" and it means
that you are entering an array formula. Simply hold down the Ctrl and Shift
key and press the Enter key. Excel puts squigly brackets around it to
indicate that it is an array formula. Every time it is edited it must be
entered this way, you cannot type the brackets in yourself. Read up on array
formulas if you need to know more.

Peo's elegant equation will enter the minimum time for each ID No in column
C, if you only want an entry in Col C where that row is the minimum time then
the following variation will do this, again it must be entered with
Ctrl+Shift & Enter

=IF(MIN(IF(A$2:A$4000=A2,B$2:B$4000))=B2,MIN(IF(A$2:A$4000=A2,B$2:B$4000)),"")
Click to expand...
 
Top