Array using MIN

J

Jatiro

Hello -
Im trying to pull an employees start ang end logouts from a timecard text
file that is being converted into excel. Sheet 1 looks like the following:
A B C
1 ID Start End
2 30008 11:06 AM 12:47 PM
3 30008 1:16 PM 2:46 PM
4 30008 3:01 PM 4:23 PM
5 30015 7:54 AM 9:12 AM
6 30015 9:20 AM 9:53 AM
7 30015 10:10 AM 11:40 AM
8...

Sheet 2 column A has all the ID's in it and then Column B is where I want to
list their times. Yes - easy way is vlookup, but I'm trying to avoid that due
to another reason.

What I thought would work is the following formula... but I'm wrongo - my
greatest thanks for any suggestions in advance.

{=if($A1=Sheet1!$A$2:$A$500,min($B$2:$B$500),""))}
 
J

JMB

Details on what you want to do are vague, but guessing from your formula, try:

=min(if(Sheet1!$A$2:$A$500=$A1,$B$2:$B$500))

array entered w/Cntrl+Shift+Enter
 
T

Teethless mama

Try this:

=MIN(IF($A1=Sheet1!$A$2:$A$500,$B$2:$B$500))

ctrl+shift+enter, not just enter
 
J

Jatiro

Thank you both - Tetthless and JMB - quick response and accurate info - works
like tomato soup... hehe - It's late, I'm tired. Thanks again!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top