exclude duplicates

Hi, I'm trying to count number of intake dates within a month but sometimes there will be mulitple intakes in one day so I just want to count each date once. The data is part of a bigger spreadsheet which I can't change and contains data from previous and subsequent months. In the sample...

Suppose a1,b1,c1,d1,e1 are elements of a row and a1,c1,e1,d1,b1 is some permutation of the elements of that row how to retain only one row among all such permutations in several rows and delete remaining I dont know VBA prograoming kind help.

Good Afternoon - I have a list of data and there is a set that is duplicated. I am trying to create a page the summarizes by person how many orders were generated. For example Person ABC 123456 Item 3 123456 Item 2 Person DEF 7891011 Item 1 12131415 Item...

Hi, I´m looking for a function that counts all nonblanks in a column, but excludes duplicates and hidden rows. Been trying for a while to solve this problem with sumproduct- and subtotal functions, but I can't get it to work in the end. I realized it was more difficult than it seemed. Example...

I have a spreadsheet set up where I have courses that a student has taken, their grades, etc. on one spreadsheet and a list of gen ed's on another sheet. Example: Sheet 1 <tbody> Course Grade Pts Credits PSY 101 2 3 SOC 101 4 3 BIO 101 3 3 JUS 101 .33 3 JUS 101 1 3 PSY 101 4 3...