I dont have much experience programming with excel and was wondering if this is possible, and if so how?
I have several (3000+) lists. They are set up like a table with the first line being the headings, and the rest of the lines being objects. What i want is to filter these objects based on one of their values and then look at another value (true/false) and take the highest of a third value for all true and the lowest of that same third value for false... I can import them one at a time but do all of this by hand but it would take like 45 years, so i was wondering if there was a way to do any of this with a macro or via c# or something
Thanks for any help
Hi....
could post your spreadsheet?
here is the workbook from the data import along with one text file. Again, i have thousands of these text files so manually importing them and then sorting would not be idealTrash.xlsxEveryshore-Gas Cloud Harvester II-2012.01.05 213005.txtTrash.xlsxEveryshore-Gas Cloud Harvester II-2012.01.05 213005.txt
You want to filter using what criteria?
Point one by one.
keystyles,
welcome to the forum. Please have a look at the forum rules and the come up with a thread title that describes your issue.
thanks,
so im trying to filter via "station id" and then for the bid == false return the lowest "price" and for bid == true return the highest price. but again, if the only way to do it would be to manually import each .txt and then run a macro on it i will have to look for a solution via .net because manually importing over 1000 files every week and then running a macro on all of them would kill both me and my comp.
sorry, how do i change the name? If you have to do it i suppose "if then statement with filter?"
Last edited by keystyles; 01-06-2012 at 01:27 PM.
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
I didn't ignore anything.
See post #5 by Teylyn, one of our Moderators. There is also a link to the forum rules in my signature below.
Editing your post to try & make us look in the wrong!
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks