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.
