Sorry for the OT, I have 5732 lines of Excel to search for part #s entered twice. Been doing manual
01-10-2002, 05:30 AM
#1
Junior Member
Thread Starter
Join Date: Jul 2000
Posts: 923
Likes: 0
Received 0 Likes
on
0 Posts
Sorry for the OT, I have 5732 lines of Excel to search for part #s entered twice. Been doing manual
sort by part number then scan down line by line looking for doubles. (same #, now next to one another due to the sort). What is a better way! I have to do this five times a week, min. For two diff. lists, so min of ten times. This stuff is going to make me blind!
01-10-2002, 05:37 AM
#2
Use the sort function...
to list numbers in columns - look for dupes this way. Sort in Descending order using the column wherin the dupes may exist.
You can then re-sort by the proper column when complete.
BTW, sort functionality is accessed by going to the Data hierarchy, and then finding the Sort menu.
Make sense...
You can then re-sort by the proper column when complete.
BTW, sort functionality is accessed by going to the Data hierarchy, and then finding the Sort menu.
Make sense...
01-10-2002, 05:48 AM
#5
Junior Member
Thread Starter
Join Date: Jul 2000
Posts: 923
Likes: 0
Received 0 Likes
on
0 Posts
I am doing that now, but I want to find a way not to have to scroll through all 5732 every time. A
command that would clump doubles or triples at the top? Some sort of if/then/null combo thing. I could do it in Fortran....
01-10-2002, 06:03 AM
#7
AudiWorld Senior Member
Join Date: Mar 2001
Posts: 921
Likes: 0
Received 0 Likes
on
0 Posts
Use HELP
If you know FORTRAN, you know how to write a loop. Excel has some very good online help. Look in the index for "Macro". Also you can buy one of those "Idiot's Guide to Excel" books (not being facetious). Really not that hard to do.
Trending Topics
01-10-2002, 06:49 AM
#9
AudiWorld Senior Member
Join Date: Oct 2000
Posts: 1,133
Likes: 0
Received 0 Likes
on
0 Posts
Re: create a column, use COUNTIF(range,valuematch)
for example, part# are stored in column A1:A5732.
COUNTIF(A1:A5732,A1) would count how many time the value in A1 cell occurs in the entire column (A1 thru A5732). A quick and easy visual of duplicates. It's then just a matter of using FIND command to look for the duplicates. Copy the function for the length of the column.
COUNTIF(A1:A5732,A1) would count how many time the value in A1 cell occurs in the entire column (A1 thru A5732). A quick and easy visual of duplicates. It's then just a matter of using FIND command to look for the duplicates. Copy the function for the length of the column.
