![]() In the original data, that column contains an expression. One thing you might not notice right away is that the Commission values in the filtered set are literal values. As a rule, I don’t recommend deleting data, even if you think you’ll never refer to it again, but that’s up to you. At this point, you can replace the original data with the filtered list if you want to remove duplicates. The filtered list is short two records because this Excel feature removed duplicates.Įxcel will copy a filtered list of unique records ( Figure C) to the range you specified in Step 5. Be sure to select the Check Unique Records Only option.įigure C Image: Susan Harkins/TechRepublic. These Microsoft Excel records have two duplicates in the Table.įigure B Image: Susan Harkins/TechRepublic.
0 Comments
Leave a Reply. |