I have data that is refreshed every day and i want a formula or function that will pull back a specific number from the latest date generated by hospital.
here is the data i am working with:
i want to be able to select hospital 116's latest date and pull the percentage on the right.
ive tried dmax and sumif and countif, but not sure how to use this as there are multiple entries for 116. any help would be greatly appreciated!
HospitalDatePercentage
VAHOSPVACSMPVAAVPCTS
11611/19/2010 6:342.72
12811/19/2010 6:240.15
37011/19/2010 4:330.11
15411/18/2010 14:300
15311/18/2010 10:584.03
11611/18/2010 7:173.03
12811/18/2010 6:440.42
11611/18/2010 6:383.87
37011/18/2010 4:480.52
13811/17/2010 14:122.13
12811/17/2010 10:0350.01
12811/17/2010 7:1320.68
15411/17/2010 5:521.29
37011/17/2010 4:440.03
13811/16/2010 12:425.8
13911/16/2010 8:240.87
13911/16/2010 7:560.16
12811/16/2010 6:500.89
15411/16/2010 5:511.6
37011/16/2010 4:540.09
13811/15/2010 12:235.12
13911/15/2010 7:590.4
37011/15/2010 5:360.34
15311/12/2010 10:380.89
37011/12/2010 4:350
13811/11/2010 13:182.59
13911/11/2010 9:040.07
13911/11/2010 8:240.21
12811/11/2010 6:420.16
11611/11/2010 6:390.67
15411/11/2010 6:202.07
15411/11/2010 5:430.91
37011/11/2010 4:490.08
15411/10/2010 14:360
13911/10/2010 9:230.06
13911/10/2010 8:390.53
15411/10/2010 5:482.58
37011/10/2010 4:510.03
11611/9/2010 14:143.08
13811/9/2010 14:021.85
13911/9/2010 7:550.02
12811/9/2010 7:327.56
15411/9/2010 5:591.33
37011/9/2010 4:450.07
37011/9/2010 4:330.01
13811/8/2010 13:471.25
11611/8/2010 10:204.06
11611/8/2010 9:484.33
12811/8/2010 9:34100
11611/5/2010 14:142.75
11611/5/2010 13:334.57
15311/4/2010 14:410.13
13811/4/2010 13:124.19
12811/4/2010 7:010.51
11611/4/2010 6:371.13
15411/4/2010 5:411.41
11611/3/2010 14:483.76
11611/3/2010 14:061.5
13911/3/2010 7:570.2
11611/3/2010 6:311
here is the data i am working with:
i want to be able to select hospital 116's latest date and pull the percentage on the right.
ive tried dmax and sumif and countif, but not sure how to use this as there are multiple entries for 116. any help would be greatly appreciated!
HospitalDatePercentage
VAHOSPVACSMPVAAVPCTS
11611/19/2010 6:342.72
12811/19/2010 6:240.15
37011/19/2010 4:330.11
15411/18/2010 14:300
15311/18/2010 10:584.03
11611/18/2010 7:173.03
12811/18/2010 6:440.42
11611/18/2010 6:383.87
37011/18/2010 4:480.52
13811/17/2010 14:122.13
12811/17/2010 10:0350.01
12811/17/2010 7:1320.68
15411/17/2010 5:521.29
37011/17/2010 4:440.03
13811/16/2010 12:425.8
13911/16/2010 8:240.87
13911/16/2010 7:560.16
12811/16/2010 6:500.89
15411/16/2010 5:511.6
37011/16/2010 4:540.09
13811/15/2010 12:235.12
13911/15/2010 7:590.4
37011/15/2010 5:360.34
15311/12/2010 10:380.89
37011/12/2010 4:350
13811/11/2010 13:182.59
13911/11/2010 9:040.07
13911/11/2010 8:240.21
12811/11/2010 6:420.16
11611/11/2010 6:390.67
15411/11/2010 6:202.07
15411/11/2010 5:430.91
37011/11/2010 4:490.08
15411/10/2010 14:360
13911/10/2010 9:230.06
13911/10/2010 8:390.53
15411/10/2010 5:482.58
37011/10/2010 4:510.03
11611/9/2010 14:143.08
13811/9/2010 14:021.85
13911/9/2010 7:550.02
12811/9/2010 7:327.56
15411/9/2010 5:591.33
37011/9/2010 4:450.07
37011/9/2010 4:330.01
13811/8/2010 13:471.25
11611/8/2010 10:204.06
11611/8/2010 9:484.33
12811/8/2010 9:34100
11611/5/2010 14:142.75
11611/5/2010 13:334.57
15311/4/2010 14:410.13
13811/4/2010 13:124.19
12811/4/2010 7:010.51
11611/4/2010 6:371.13
15411/4/2010 5:411.41
11611/3/2010 14:483.76
11611/3/2010 14:061.5
13911/3/2010 7:570.2
11611/3/2010 6:311