Formula/VB to populate column based on rules
- or -
Post a project like this1289
£75(approx. $94)
- Posted:
- Proposals: 14
- Remote
- #3019284
- Completed
Data scraping / data mining / data extraction / web scraping / scraping / data conversion / General admin support and more
Kent
Virtual Assistant | Web Research Specialist | Excel | Fillable / Editable PDF |Data Mining Specialist |Data Extraction | & Project Coordinator
Cairo
Excel Expert |WordPress| Google Sheets |VBA & Google App Script | Woocommerce
Jhelum
Wordpress |Web developer|Graphic Designer |Logo Designer | Scrapping |Excel VBA |Data Scientist
Rawalpindi
24785851256321390581901146498651354228147667917115861788290278297729287464613570
Description
Experience Level: Entry
Hi everyone. I need a formula creating in excel that populates data in a column based on the previous column. It is, hopefully, quite simple but I have not tackled something like this before and need some assistance.
Please see the attached file 'sample data'. This data is anonymised log files exported from a VoIP system (Zoom). The data is not well constructed for analysis in excel.:
- Row 2 contains header data, with row 3 a subset of data for row 2.
- Row 5 contains header data, with rows 6-8 a subset
- Row 9 contains header data, with rows 10-24 a subset
- Row 25 contains header data, with rows 26-28 a subset
You should now see the pattern of how this works. The actual data I need to analyse has 6000 rows per month so it's not possible to edit it manually.
What I need:
1. See column E as an example of the output I want from the formula.
- If there is data in column D, display this data in the same row in column E.
- If there is no data in column D, look in the above rows to find the last entry and copy that instead.
2. I also want to be able to use this formula in other locations in the document where the same rules apply.
Any questions please let me know :). If I can find a good analyst to work with on this who is efficient and capable, I will be happy to push more work your way!
Thanks,
Chris.
Please see the attached file 'sample data'. This data is anonymised log files exported from a VoIP system (Zoom). The data is not well constructed for analysis in excel.:
- Row 2 contains header data, with row 3 a subset of data for row 2.
- Row 5 contains header data, with rows 6-8 a subset
- Row 9 contains header data, with rows 10-24 a subset
- Row 25 contains header data, with rows 26-28 a subset
You should now see the pattern of how this works. The actual data I need to analyse has 6000 rows per month so it's not possible to edit it manually.
What I need:
1. See column E as an example of the output I want from the formula.
- If there is data in column D, display this data in the same row in column E.
- If there is no data in column D, look in the above rows to find the last entry and copy that instead.
2. I also want to be able to use this formula in other locations in the document where the same rules apply.
Any questions please let me know :). If I can find a good analyst to work with on this who is efficient and capable, I will be happy to push more work your way!
Thanks,
Chris.
Chris C.
100% (5)Projects Completed
6
Freelancers worked with
5
Projects awarded
67%
Last project
12 Oct 2023
Greece
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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