Excel function to provide distinct value from a cell

Search Close

Account Information

Reset password

An email has been sent to you with instructions on how to reset your password.

Back to TechRepublic

Welcome to TechRepublic!

By registering, you agree to the Terms of Use and acknowledge the data practices outlined in the Privacy Policy.

You will also receive a complimentary subscription to TechRepublic's News and Special Offers newsletter and the Top Story of the Day newsletter. You may unsubscribe from these newsletters at any time.

All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).

General discussion

Creator

Topic
August 9, 2011 at 11:47 am #2210965

Excel function to provide distinct value from a cell

Locked

by ravi_verma · about 11 years, 3 months ago

Hi All,
I need an excel function to derive distinct value from a cell. Suppose i write in column A1 ” Ravi Verma Ravi Ravi Verma Mumbai” hence the result should be “Mumbai” as its the only distinct value.
Thanks
Ravi Verma

This conversation is currently closed to new comments.
Creator

Topic

All Comments

Start or Search

Start New Discussion

Password-driven security may not be the perfect solution, but the alternatives haven’t gained much traction. This policy defines best practices that will make password protection as strong and manageable as possible. From the policy: Employee passwords are the first line of defense in securing the organization from inappropriate or malicious access to data and services. ...

Recruiting candidates with advanced software engineering experience and a least some familiarity with applied blockchain technology will take time and effort. This hiring kit provides a workable framework you can use to find, recruit, and ultimately hire the best candidate for Blockchain Engineer in your organization. From the Hiring kit INTRODUCTION Moving well-beyond its cryptocurrency ...

This policy provides guidelines for secure and effective cloud computing operations to ensure the integrity and privacy of company-owned information. From the policy: The list of advantages to cloud computing includes lowered operational costs, greater technological flexibility, and the ability to rapidly implement new systems or services. Gains in business continuity are an especially noteworthy ...

Due to scheduled maintenance, the ability to log in to your account and make purchases will be disabled December 1 - 2.

Software

General discussion

Excel function to provide distinct value from a cell

All Comments

Password management policy

Hiring kit: Blockchain Engineer

Cloud computing policy

Payroll services comparison tool