Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In excel, how do I omit duplacates when sorting new info.
I am using Microsoft Excel 2003. I would like to know when imputtiing new
data into a spreadsheet that already exsits, how do I omit duplacates? |
#2
|
|||
|
|||
If your data is in range, say A1:A10, I would, in cell B1, type
"=COUNTIF($A$1:$A$10;A1)". And copy the formula down in B1:B10. This way, if you read anything higher than 1 in the B cell, it means the value already exists in the range. "Blaine Fray" wrote: I am using Microsoft Excel 2003. I would like to know when imputtiing new data into a spreadsheet that already exsits, how do I omit duplacates? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
In Excel, sorting columns automatically by clicking column title | Excel Discussion (Misc queries) | |||
Sorting in Excel | Excel Discussion (Misc queries) | |||
Excel :sorting lists? | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |