MyTechSupport.ca :: Your Computer Technical Resource Headquarters! MyTechSupport.ca :: Your Computer Technical Resource Headquarters!
HOME FORUMS RESOURCES & TOOLS ARTICLES ONLINE STORE ABOUT US
Computer Support Forums arrow Software Support arrow Operating Systems : Microsoft arrow Topic: excel - counting duplicate cells (not!)
July 23, 2019, 07:16:48 PM
 

Home Forum Rules Help Search Mobile Version Login Register

Welcome, Guest. Please login or register.
Did you miss your activation email?
July 23, 2019, 07:16:48 PM

Login with username, password and session length
 
News
New  We now offer MyTechSupport.ca Merchandise! Every purchase goes towards maintaining our site.
Thank you for supporting MyTechSupport.ca!
  0 Members and 1 Guest are viewing this topic.
Pages: [1] Go Down Print
Author Topic: excel - counting duplicate cells (not!)  (Read 711 times)
learning05
Newbie
*

Karma: +0/-0
Offline Offline

Gender: Female
Posts: 1


Bookmark and Share

View Profile
« on: August 30, 2003, 11:38:52 AM »

PLEASE SUPPLY RELEVANT INFORMATION:
Operating System Version: Windows 98
Problem Application Name & Version: Microsoft Excel 97
Problem Hardware Make & Model:
Error Messages:



I am going insane!  I have a column with a list of names - some of which are repeated.  I only want to count each name once, regardless of how many times it appears in the column.  No-one at work can help and I am now driving them insane too.  Less of a problem but can anyone answer this one:  What if 2 people have the same name and I want to link to date of birth to make sure I get everyone.

I hate computers!!!!!!  (couldn't even post this message to the right forum on my first attempt)
Sad

Louise
Logged

Louise
Admin
Administrator
Hero Member
*****

Karma: +4/-0
Offline Offline

Gender: Male
Posts: 4898



Bookmark and Share

View Profile
« Reply #1 on: September 02, 2003, 01:27:11 PM »

Hi,

I am running Excel 2000 so I am not sure if Excel 97 has this feature but...

Data > Filter > Advanced Filters
Select "Unique Records Only"

To undo:
Data > Filter > Show All
Logged

Sylvain Amyot
http://www.mytechsupport.ca

If you like to concept of this site and want to help, click here to find out how.
Pages: [1] Go Up Print 
 
Jump to:  

Powered by MySQL Powered by PHP

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines

Valid XHTML 1.0! Valid CSS!

Disclaimer
This site is NOT responsible for any damage that the information on this site may cause to your system. Everything you try, whether inspired by the response given from this site or not, is entirely at your own risk. All product names and company names used herein are for identification purpose only and may be trademarks or registered trademarks of their respective owners. We are in no way affiliated or representing any of the companies on this site unless specified.
Back to Top
Stop Spam Harvesters, Join Project Honey Pot Fight Back Against Spammers! Get Firefox! Get Thunderbird! View Sylvain Amyots profile on LinkedIn
Back to Top
Google visited last this page September 22, 2017, 03:19:24 AM