Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"distinct" function in excel

Status
Not open for further replies.
DaveLL

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?
 
Sort by date Sort by votes
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 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
Status
Not open for further replies.

Similar threads

arvarr
  • Locked
  • Question
Excel - getpivotdata function 2
Replies
3
Views
109
arvarr
arvarr
Bijugate
  • Question
Excel update question
Replies
0
Views
235
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
236
combo
combo
shytott
  • Question
Excel - Toggle Button Code 1
Replies
10
Views
736
shytott
shytott
ladyck3
  • Locked
  • Question
Excel 365: I'm new to Tables - Configuring Font & "Get Data from Table/Range" 2
Replies
4
Views
129
ladyck3
ladyck3

Part and Inventory Search

Sponsor

Back
Top