Oct 24, 2001 #1 DaveLL Technical User Sep 27, 2000 18 0 0 CA in a dynamic cross table, i want to "distinct" data. is it possible with excel?
Oct 24, 2001 #2 ETID Programmer Jul 6, 2001 1,867 0 0 US I'm built too low....what do you mean by distinct, as in sql select distinct? Also have you tried the Filter or Pivot table tools? Upvote 0 Downvote
I'm built too low....what do you mean by distinct, as in sql select distinct? Also have you tried the Filter or Pivot table tools?
Oct 24, 2001 #3 mscallisto Technical User Jun 14, 2001 2,990 0 36 US I agree with ETID can you be a bit more specific? If you want to see uniqueness of data, From your open spreadsheet: Data Filter Advanced Check the Unique box etc. If you wish to count permutations of data I'll be happy to supply the formula. Upvote 0 Downvote
I agree with ETID can you be a bit more specific? If you want to see uniqueness of data, From your open spreadsheet: Data Filter Advanced Check the Unique box etc. If you wish to count permutations of data I'll be happy to supply the formula.