Hello,
I have two fields in my query first is month
Field 1
201010
201109
201007
etc...
Field 2
XYZ
ABC
DEF
XYZ
etc...
I want to make a query that will count only once Field 2 values and match the MAX value in field 1.....
is that possible ??
Hello,
I have two fields in my query first is month
Field 1
201010
201109
201007
etc...
Field 2
XYZ
ABC
DEF
XYZ
etc...
I want to make a query that will count only once Field 2 values and match the MAX value in field 1.....
is that possible ??
See my response here
http://www.mrexcel.com/forum/forumdisplay.php?f=18
Crosspost
http://www.excelguru.ca/content.php?184