0

I have an excel file with around 10.000 leads, categorized with Name, Email, Company name, Position, City, CheckedEmailAddress, Mail server Country Code, last one Mail server Country Code, there are 11 different Mail server Country Code, I need to take all 11 by 11 leads from all of them, that means 1 sheet 11 leads from 11 different mail servers, so, all sheets 11 leads from different Mail servers country code

Hope you understand me! Every sheet should have unique values from mail server category.

I started by removing duplicates and again and again but this process takes like forever.

Thank you

Improve this question
4
  • 1
    I don't understand. Are you able to provide a couple of pictures with an example of how it is now and what you want it to be? Even if you just make these up, it may help us :)
    – Dave
    Commented Jul 5, 2017 at 9:30
  • @Dave please check this video I just made, streamable.com/gjpr0
    – Edin Neziri
    Commented Jul 5, 2017 at 9:44
  • I am not sure I fully understand what you are trying to do, but I think what I would do is add a new column, then filter the country column and add 1, 2, 3.... to the new column. Repeat for each country. Then you can filter the new column for values "1", "2"... and copy and past each to a new sheet. Not the most efficient way of solving what I think is your problem but it will work, assuming I understood your goal.
    – Kevin Anthony Oppegaard Rose
    Commented Jul 5, 2017 at 10:50
  • @KevinAnthonyOppegaardRose thank you, but that will take time more than I'm doing right now, anyway thank you, I need something like macros script or something like that
    – Edin Neziri
    Commented Jul 5, 2017 at 10:59

1 Answer 1

Reset to default
0 
H1:  Count of MSCC
H2:  =COUNTIF($G$2:G2,G2)

Select H2 and fill down to the bottom. This will result in appropriate numbering for filtering.

Then Filter on each value and copy (visible cells) / Paste (do NOT cut or delete, or the numbering will change) to the new worksheet.

Or you can use the Advanced Filter selecting the option to paste results to a different location.

Or you could record a macro while doing the above, and then edit the macro to change the selection and destination criteria.

Improve this answer
6
  • I don't understand what are you saying but I put down below an excel file if you can try if that works, I really appreciate that. sendspace.com/file/g7mkft
    – Edin Neziri
    Commented Jul 5, 2017 at 11:54
  • @EdinNeziri What exactly is it that you don't understand? My first suggestion has you adding formula to a worksheet; filling it into a range, and then using a filter. If your knowledge of excel has not progressed to this level, you may be best off hiring a consultant for this task, and perhaps perusing some basic Excel teaching tutorials or books for the future.
    – Ron Rosenfeld
    Commented Jul 5, 2017 at 17:33
  • thank you for your answer, please if you can send me an excel with that formula I will understand it perfectly, thank you
    – Edin Neziri
    Commented Jul 6, 2017 at 6:05
  • @EdinNeziri Entering the formula on your Excel worksheet is your responsibility. I have provided you with the formula and a suggested cell address. Entering a formula in a cell is a very basic Excel task. Again, if you are unable to do this, you will need to hire someone, or perhaps find a site that will do your work for free.
    – Ron Rosenfeld
    Commented Jul 6, 2017 at 13:15
  • thank you, this is a demo I did what I'm trying to do, in this video a go with Domina category to filter unique, can you confirm that with your code I can do this faster, Demo >> streamable.com/r50pq Thank you for your time.
    – Edin Neziri
    Commented Jul 6, 2017 at 13:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .