Hello
I'm having a problem with getting the right formula in excel 2010. I've got a table with few columns, but i'm only going to use data for 2 of them. In one of them, i've got NAMES, in another - DATES (in a format of YYYYMMDD). In another sheet i use a field, where i put the NAME, and i want to get the last (most recent) date for that name (so, as it's a number, i can just get the MAX out of it). The number of the name occurance varies, sometimes it's none (where it'll show that there's none, but that's a simple function), sometimes it can get to couple dozens.
I know, how to make it in SQL, more or less. It'd be something like:
SELECT MAX(date_column) FROM table WHERE NAME = C5;
C5 being the field, where i put the NAME for search.
Bookmarks