If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Using VBA, how do I find the Max value in a table column, based on values in another column?

Thread starter M McAllister
Start date Mar 18, 2015
Tags

count lookup userforms vba

M McAllister

New Member

Mar 18, 2015

First, thanks for the help. I tried to research the answer first, but I don't think I was phrasing my question correctly. I've looked at arrays, and worksheet funtions, and I'm not sure how to proceed.

Using Excel 2010.

I have a table with many columns, but for this I'm only using 3 columns: Measure Name, Period, Result Date.

(There are many Measures in the table, with many results. Period is the number of the result (this is the nth result). There is 1 result per result date.

I have a userform which allows the user to select the Measure Name. Based on the Measure name, I want to return the following:

Max Period
Period Count (as verification. It should match max period)
Max Result date

Any guidance is appreciated.

Thank you,
Mathew