answersLogoWhite

0

Duplicates in a excel spreadsheets

User Avatar

Anonymous

14y ago
Updated: 8/16/2019

I) To prevent duplicate values (from A2 to A10) when entering data:

1) Select the range (eg: A2 to A10)

2) Data -> Validation -> Settings -> Custom -> Formula:

=countif($A$2:$A$10,A2)=1

II) To find duplicate items in combine column:

To check whether the data in column C is Duplicate or Unique:-

Firstly enter values in column C,

then enter the formula in column D:

=if(countif($C$1:C1,C1)>1, "Duplicate", "Unique")

then copy the formula downwards.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

What does Excel produce?

Spreadsheets.


What is tab in spreadsheets excel?

The tabs at the bottom of the screen identify individual spreadsheets.


Why MS-Excel is used?

ms excel is used to create spreadsheets.


What is the file excel?

Excel is not a file, but a computer program that makes spreadsheets.


What application software do you use for spreadsheets?

The Microsoft Excel program is a common program for spreadsheets.


Why does excel spreadsheets save in word?

don't


Are work book different from a spreadsheet?

A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.A workbook contains worksheets, which are Excel's name for spreadsheets. A workbook normally has at least three worksheets in it, though more can be added or some can be removed. So in Excel, a workbook is the name of the file and it contains individual spreadsheets or worksheets.


Can electronics formulas be programed into Excel spreadsheets?

Yes.


What is Excel known for?

It is known as a program for creating spreadsheets.


What is the name of the software that is for creating spreadsheets?

Excel or Access


What would you use the Excel Viewer for?

Microsoft Excel Viewer is a program that lets one view and print spreadsheets that were created in Microsoft Excel. The beauty of this program is that one can view the spreadsheets without having to have Microsoft Excel installed on one's computer.


How do you draw a nomogram in Excel?

You can not draw shapes or objects in Excel. Excel is used for spreadsheets and organizing many forms of data.