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 Chriss Miller 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
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

Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
520
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
458
SkipVought
S
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
310
combo
combo
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
885
bs6600
bs6600
arvarr
  • Locked
  • Question
Excel - getpivotdata function 2
Replies
3
Views
345
arvarr
arvarr

Part and Inventory Search

Sponsor

Back
Top