• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

macro for excel

Hi,
on the link bellow Attaches is two excel files in rar format , names train and test, which I need macro for both of them to make filtering on the last column which is v43 (data class), so that I can export any numbers of records based on the v43 (data class),
There are 5 classes in the last column which are (Normal, DoS, Prob, R2L, U2R).
Check the attached picture of the outcome work.
http://www61.zippyshare.com/v/57880067/file.html

so
Thanks
what-i-need.png
0
reoroman
Asked:
reoroman
  • 9
  • 6
1 Solution
 
gowflowCommented:
Is this the remove Duplicate ?
gowflow
0
 
reoromanAuthor Commented:
no, another job now...that will be after this..it is the same as the previous work where the output was numbers, here the output is text.
0
 
gowflowCommented:
ok let me see it and will revert

I see here you want to sort by AP but still you have a column AQ that is also used, need to know if we also need to add an extra column to put Y when you transfer so it does not transfer the same record twice  ?
gowflow
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
reoromanAuthor Commented:
I want to sort by AQ only. and i need you to put additional column for Y so it does not transfer the same record twice. thanks
0
 
gowflowCommented:
ok here it is
I tested it with the file Test and it worked fine so I guess it should work also with the other file.

Take the attached file and do the following:
Insert your data file Test and then do the following
insert on first row a blank row
then label A1 V1 and drag it all the way to Col AR so you get A44

the goto sheet main and select in the class you will see drop down from where you can only choose the available class choose the one you want with the number of occurence and then run the produce output

Let me know if it works for you.

If you insert the other sheet you need to change the sheet name to match the new sheet. Anyway try the macro and if all ok I will tell you how to change it.

gowflow
Sort-by-AQ-NOData.xlsm
0
 
reoromanAuthor Commented:
works fine, but please delete the renumber classes icon.

I need two macro one for train and one for test, OR you teach me how to change the macro to read any file name i need it to.
0
 
reoromanAuthor Commented:
can i do it by going to

Set WSTR = Sheets("Test")

and change it to

Set WSTR = Sheets("Train")
0
 
gowflowCommented:
yes exactly. and for renumber jus delete the button renumber
to do this before activating macros u can delete the butotn
gowflow
0
 
reoromanAuthor Commented:
Professional work, As usual.
 Thanks a lot.
0
 
gowflowCommented:
Your welcome, my pleasure. Pls feel free to post a link here if you need anymore help.
Rgds/gowflow
0
 
reoromanAuthor Commented:
yes, sure thing
0
 
gowflowCommented:
By the way I have ready your previous request on duplicate rows if and when let me know.
Also I was very surprised to notice that the file which had some 500,000 records after running the macro came down to only 10% of it 50,000 is it normal that you had so much duplication ?
gowflow
0
 
reoromanAuthor Commented:
hi, i am posting the question now.. i will be back with the link.. Thanks
0
 
reoromanAuthor Commented:
gowflow, are you there ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 9
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now