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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: johnbezzina
- Order by date
-
How to extract unique distinct values of a column using a formula
Yes, I know about that Blue Horizons... works fine if you have a handfull of columns to work with but I have over a 100!! Thanks Guys!- johnbezzina
- Post #12
- Forum: Microsoft: Office
-
How to extract unique distinct values of a column using a formula
THANKS!!!! it worked just fine now.- johnbezzina
- Post #10
- Forum: Microsoft: Office
-
How to extract unique distinct values of a column using a formula
I just noticed that you get a zero when you place the formula in column B (as was suggested) if you place the formula someplace else and change the range after the COUNTIF so that it will not be in the same column as the formula you get a result but only the first entry. I have included an...- johnbezzina
- Post #8
- Forum: Microsoft: Office
-
How to extract unique distinct values of a column using a formula
Thanks Guys. I opted to try the formula sent by arthurbr ince it looks simple enough but I am getting a list of zeros. BTW... my list is made up of text entries not numbers- johnbezzina
- Post #5
- Forum: Microsoft: Office
-
How to extract unique distinct values of a column using a formula
How to extract unique distinct values of a column using a formula (NOT a filter) Is there an easy way to do this? I have been looking high and low and I simply cannot find an easy to use formula. My needs are quite simple.. I have a list of around 500 items and a good number of these are...- johnbezzina
- Thread
- Replies: 12
- Forum: Microsoft: Office
