[ excel ] max date depends on one column

using DMAX

http://stackoverflow.com/questions/10755207/how-to-get-max-date-from-one-column-and-match-with-other-column-in-excel

better to use the formular with Array function, see example

http://newtonexcelbach.wordpress.com/2009/09/09/using-the-dmax-function/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s