I need excel formula written
- or -
Post a project like this2515
$$
- Posted:
- Proposals: 5
- Remote
- #1577674
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
I need to find data which is repeated in excel, or which is repeated except for parts of a string in one column. The data is across four columns, and where four columns match, (or nearly match [details in attachment]), I would like to format it (so that it can be reviewed, with the assumption it will be deleted. I would also like to retain the information about the varying final part, compiling it in the first "near-identical" row. Where the data is completely identical, the found results should also be formatted. I've written four problems into the attached sample - the last one is a real doozy!
I'd like the solution provided as excel formula please. I may find that I need to tweak them in the future, as I have a very large data set.
There may be more work coming down the line, but this particular enquiry is about programming that I'm very certain I can't solve on my own!
For the curious, this is about summarising the effects of legislation, and this dataset is similar to this information: http://www.legislation.gov.uk/changes/affected/asp/affecting/asp/2016. My job is to make it more legible, and up to now, this has been a manual process... can you help me make it faster, without losing valuable information?
I'm happy to run through an alpha, beta stage as I'm aware the subject matter is likely unfamiliar to people. However, I don't think that for an excel expert, the first 3 problems will be very many hours' work. Feel free to pitch for problems 1-3. I'm not sure is 4 is solvable, and it would be easy to fix manually.
I'd like the solution provided as excel formula please. I may find that I need to tweak them in the future, as I have a very large data set.
There may be more work coming down the line, but this particular enquiry is about programming that I'm very certain I can't solve on my own!
For the curious, this is about summarising the effects of legislation, and this dataset is similar to this information: http://www.legislation.gov.uk/changes/affected/asp/affecting/asp/2016. My job is to make it more legible, and up to now, this has been a manual process... can you help me make it faster, without losing valuable information?
I'm happy to run through an alpha, beta stage as I'm aware the subject matter is likely unfamiliar to people. However, I don't think that for an excel expert, the first 3 problems will be very many hours' work. Feel free to pitch for problems 1-3. I'm not sure is 4 is solvable, and it would be easy to fix manually.
Alice W.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
100%
Last project
9 Apr 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
This is an interesting challenge, one that I am not overly familiar with. It goes a step beyond splitting cells etc.
I am looking at options to make this work, if I fail to submit a proposal the only additional advice I would give you is: Choose your Freelancer carefully!!!!Alice W.19 May 2017thanks. Tony. I've selected a freelancer - wish us both luck!
421882
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies