Hi, I'm reposting this question, and I've tried to make the problem clearer, with a new work book,
The problem remains the same I have grouped data where there is a tie, and want to extract the values from the 'groped ' 'All Rows',
I've made a copy of each query as I've added each step and named them as to what they are trying to achieve,
the last query has a list of names, but there are duplicates, this is what I'm trying to get rid of I only want a disctinct list of the names.
Richard
Bookmarks