High level - I need to be able to parse an excel spreadsheet and pull records that match a range of values.
Details- attached is an example report. Each "record" will span a variable number of rows, based on the number of entries in the "property code" column. Each entry in the "user" column, along with all following rows until the next "user" entry, and extending to the "property codes" column, constitutes a "record". In the example report, the first record is 1 row, while the second record is 24 rows.
I need a solution that will, when given a number range, copy any records that contain a matching property code in the range to a results file. If a record has multiple matching codes it should only be copied once, and the entire record should be copied.
As an example, if given the range 85000-85999, the results file would include the records for rjohnson (1 row) and ebarbezat (156 rows).
It would be beneficial to be able to specify the name of the results file when specifying the number range. If we can provide multiple names/number ranges at once, that would be ideal.
I understand that this is not a standard usage for excel, but the input file format cannot be changed. If you have any questions, please ask prior to bidding. This solution will be tested thoroughly prior to acceptance, so if we can work out any confusion ahead of time that would be greatly preferred.
hello,
I'd be glad to implement the record file parsing tool for you. i suggest using python for this which is a very well known and powerful language for such tasks.
Looking forward to chat with you soon for more details.
Best regards,
$250 USD om 3 dager
5,0 (29 omtaler)
5,7
5,7
14 frilansere byr i gjennomsnitt $442 USD for denne jobben
Hello, I have read what you exactly need, however I would like to ask you a few questions. I do work smart and do not rest until I get the job done. Please feel free to ping me anytime so we can have a detailed discussion and finalize our budget and timeline. I will deliver in best possible way. Thank you.
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros.
Check my reviews. They speak for themselves.
Best regards
Hi: I have a few questions: In your brief you mentioned that the script should allow you to enter multiple range and a file name. So, I wanted to confirm whether you want a functionality where one set of ranges goes to one file and the other set to another file? Given that each record has multiple property codes, should the script select that record even if there is only match (with property code) in that record? Please note that over 80% of my completed jobs are related to Excel and Automation. Moreover, I have ~100% completion rate and 5-star feedback on projects. Please connect with me to discuss your requirements in detail.
My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & experience that are required to complete this project. I can show you some examples of my work. Please contact me to discuss your project.
Let me have the required data in order to send you an example. I have the required expertise for developing your project. Check my developed projects and reviews of my portafolio.