0
How do you find duplicate numbers in a worksheet with ten thousand data rows?
Wiki User
∙ 14y ago
In Excel 2007,
- Copy data to another column.
- Click on the column letter to select the column.
- On the data tab, in the data tools section, click on Remove Duplicates.
- Click OK.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Can a worksheet contain data such as numbers and formulas?
yes
Can Worksheet cells only contain numbers?
No. A worksheet can hold all sorts of data, like text, dates, number, logical values and formulas.
What is the chart that is a representation of the data in a worksheet?
What is the visual representation of worksheet data?
What allows data easy to summarize and charted in excel?
An Excel worksheet or spreadsheet allows data to be easily summed and charted.
Duplicate data in multiple data files is?
Data backups
What kind of data functions manipulate quantitative data in a worksheet?
Mathematical and Trigonometric and statistical functions manipulate quantitative data in a worksheet.
What are the four kind of data you can enter in a worksheet?
numbers, text, images, and imbedded objectsUtilities, repairs, phone bills, etc.
Is not a method for copying data to another part of the worksheet?
Printing is not a method for copying data to another part of the worksheet.
Are embedded charts updated when the worksheet data changes?
Ye, embedded charts are updated when the data in the worksheet is changed.
Can a chart be saved on the same worksheet as the data or on a separate worksheet?
A chart can be saved on the same worksheet or on a separate worksheet in Excel. The easiest way to put a chart on a separate worksheet is to create your chart on the same worksheet as your data. After you create your chart, just cut and past to the worksheet where you want it to show.
What is the difference between sheet tabs and worksheets?
A worksheet contains columns, rows and cells and is where you do your work. Each worksheet has a name. You can have more than one worksheet in a workbook. Each worksheet has a tab at the bottom of the screen, with its name on it. This is a sheet tab. It allows you to identify the different worksheets and by clicking on a sheet tab, you can change from one worksheet to another.
Where is data stored in an Excel worksheet?
The data is stored in cells on the worksheet. Sometimes they are arranged like a table, but some data may not be organised like that.
