MS Excel help or anything close to it

gunn.enterprise

gunn.enterprise

Banned
May 22, 2012
553
3
0
back in 642
hey brahs!

Need your help once more, All about excel. So here's my situtation, I got a software that harvest like shit and I think it will not stop in 6 months.

Day 1
Harvest High PR links with low OBL, cleaned the list and stuff and cleaned the results of the software.

Day 2
Another set of harvested links. but the problem is there's some duplicates here that is already in Day 1.


  • Now what I need to is remove the Duplicates from Day2 without touching Day1 or without combining the 2 list of URL's.
Like the master is day 01 and just compare both the list and Day 02 will be the one removing the duplicates found on day 01 and also Day 01 would not remove anything at all. How can I do this in excel?

​
Now Day 03 comes..
Another shitty fuckhole. I need now to Compare results from day "01 & 02" without touching them and only removing the duplicate list on Day 03... How can I do this? and I cannot do this manually as software produces 200-300 daily..

Thanks brahs! appreciate all those who can help out!
 


so it spits out a list per day... you need to scrub each day's new list of any items that are on the list of URLs from previous days, then add the scrubbed URL list to the master & repeat tomorrow... right?
 
drave said:
so it spits out a list per day... you need to scrub each day's new list of any items that are on the list of URLs from previous days, then add the scrubbed URL list to the master & repeat tomorrow... right?
Click to expand...

Quite close to it. but not in the part where I need to add it in the master list... It will be separate files I just need to get rid of every duplicates it has on day 1 and day 2 and day 3..

but the final results is that I'll have 3 notepads with all unique URL's.. I'd like to make it simple but I cannot cause on day 1 we will use the Days data already. and do not want to duplicate the URL's by not checking the duplicates..

Thanks!
 
Not sure how automated you wanted it, but this is the easiest manual way that I found in Excel 2007/2010.

Before you get freaked out by the detailed instructions, let me just give you the short version so you can see how easy it is:

conditional format -> filter -> del -> un-filter -> sort

It'll literally take you less than a minute per day. Here's the details:

1)
Top row in Excel contains heading Eg. day1, day2, day3, etc
So each column will contain one daily list.
In this example, imagine you already have day1 and day2
And tomorrow you'll add a third column (day3)

2)
highlight the two columns - day1 and day2
home -> conditional formatting -> highlight cells rules -> duplicate values
So now all the dupes in the two columns are light red.

3)
highlight column two so you can delete the dupes.
(You don't want to delete the dupes in column one).
data tab -> filter
The heading day2 now has a drop down menu
menu -> filter by color -> choose light red
No all the uniques have disappeared, and the list is only red
Select this red list (not the heading though) and press 'del' (not backspace)
data tab -> filter (to turn the filter off)

4)
Your dupes in day2 are gone, and you are left with the uniques, but they have spaces between them.
The easiest way to get rid of the spaces is...
select the day2 column again (but not the day2 heading)
data tab -> click the SMALL sort A-Z button
It asks whether to expand the selection - choose 'continue with current selection' (ie. don't expand)

Finished - you've got rid of the dupes without doing anything to the day1 list.

5)
Next day you add the day3 list into column three.
Highlight all three columns.
home -> conditional formatting -> highlight cells rules -> duplicate values
So now all the dupes in all three columns are light red.

Now you want to repeat from step 3), except work on the third column this time...
filter by color -> del -> sort -> done!

Of course the next day, you'll highlight all four columns for the conditional formatting, and so on.
Hope that solves your problem, until you get an automated solution.
 
gunn.enterprise said:
Quite close to it. but not in the part where I need to add it in the master list... It will be separate files I just need to get rid of every duplicates it has on day 1 and day 2 and day 3..

but the final results is that I'll have 3 notepads with all unique URL's.. I'd like to make it simple but I cannot cause on day 1 we will use the Days data already. and do not want to duplicate the URL's by not checking the duplicates..

Thanks!
Click to expand...

chianti's solution will work. another manual way that would take basically no time each day would be to use the 'if' & 'vlookup' functions to compare the current day's output to a compiled list of previous days scrubbed output. if the current URLs are found in the list of prior URLs, have the IF statement return "duplicate"; if not, "unique", then sort by that & delete the dupes. add the 'uniques' to the running list of previous output, rinse & repeat tomorrow.
 
Chianti said:
Not sure how automated you wanted it, but this is the easiest manual way that I found in Excel 2007/2010.

Before you get freaked out by the detailed instructions, let me just give you the short version so you can see how easy it is:

conditional format -> filter -> del -> un-filter -> sort

It'll literally take you less than a minute per day. Here's the details:

1)
Top row in Excel contains heading Eg. day1, day2, day3, etc
So each column will contain one daily list.
In this example, imagine you already have day1 and day2
And tomorrow you'll add a third column (day3)

2)
highlight the two columns - day1 and day2
home -> conditional formatting -> highlight cells rules -> duplicate values
So now all the dupes in the two columns are light red.

3)
highlight column two so you can delete the dupes.
(You don't want to delete the dupes in column one).
data tab -> filter
The heading day2 now has a drop down menu
menu -> filter by color -> choose light red
No all the uniques have disappeared, and the list is only red
Select this red list (not the heading though) and press 'del' (not backspace)
data tab -> filter (to turn the filter off)

4)
Your dupes in day2 are gone, and you are left with the uniques, but they have spaces between them.
The easiest way to get rid of the spaces is...
select the day2 column again (but not the day2 heading)
data tab -> click the SMALL sort A-Z button
It asks whether to expand the selection - choose 'continue with current selection' (ie. don't expand)

Finished - you've got rid of the dupes without doing anything to the day1 list.

5)
Next day you add the day3 list into column three.
Highlight all three columns.
home -> conditional formatting -> highlight cells rules -> duplicate values
So now all the dupes in all three columns are light red.

Now you want to repeat from step 3), except work on the third column this time...
filter by color -> del -> sort -> done!

Of course the next day, you'll highlight all four columns for the conditional formatting, and so on.
Hope that solves your problem, until you get an automated solution.
Click to expand...

Damn this worked like charm! Took me 5 minutes to try it out but will take me like 10 seconds daily to do this! Damn bro Thanks a lot! PM sent as well! Thanks a lot for taking time and answering my damn ass question man! Get 1 free order from my sig bro, my way of saying thanks! :D


drave said:
chianti's solution will work. another manual way that would take basically no time each day would be to use the 'if' & 'vlookup' functions to compare the current day's output to a compiled list of previous days scrubbed output. if the current URLs are found in the list of prior URLs, have the IF statement return "duplicate"; if not, "unique", then sort by that & delete the dupes. add the 'uniques' to the running list of previous output, rinse & repeat tomorrow.
Click to expand...
I think Chianti's solution will be much easier as I need to click 3 times and everything is set! But anyways thanks for trying to help man appreciate it! Choose 1 pack on my sig you get 1 free as a thank you from me man!
 
Hey..gunn

check your pm - pm'd you twice about an order from 3 weeks ago - no response - no report and your threads are closed??
 
patioman said:
Hey..gunn

check your pm - pm'd you twice about an order from 3 weeks ago - no response - no report and your threads are closed??
Click to expand...


PM sent man. The project was on scheduled dripped and was late by 5 days cause of some personal issues. But anyways the links are already available 5 days ago, only reporting isn't done and I'm back, sent you a PM and will get you the report in 12 hours.

Also I'm not making any excuses of fuck ass stuff like that. You get a free order cause of this delay and all other customers that has delay on whatever, like reporting, problems caused by me or updates, I mean whatever the reason is, Late reports will get free orders!
 
You must log in or register to reply here.
Top Bottom