Log In
Register
Home
August 25, 2017
Offline
I am not sure what is best a vlookup or macro.
Basically, I have a list of names in column A. The names will repeat based on entries described in Column B and Column C.
I would like to have the name listed only once in Column A. Column B and Column C are good. Result Expected: To have one row for each name, with user actions and time stamped going across (placed in columns). The names are to be sorted in alphabetical order. The users action to be placed in time stamped order with the earliest time listed first.
I hope this helps.
July 16, 2010
Offline
I'd like to suggest another option. First, the timestamp in your dataset is text and needs to be converted to a proper date time serial number before it can be sorted in any order.
In the attached file I used Power Query to fix the timestamp and then split it into date and time components. I also added a Boolean column for Status based on whether they joined or left the meeting.
This enables you to use a PivotTable to visualise the joining and leaving of the meeting. IMO it's better to see this on a timeline rather than have the timestamps in a single column starting/ending at different times. It's much harder to interpret the layout you had because it requires reading of every time and creating your own visual picture, whereas my PivotTable approach makes it much easier to compare people across a common timeline.
Hope that helps.
Mynda
August 25, 2017
Offline
Mynda
I love the format, you are right much easier to understand.
The Power Query is new to me. So can you tell me what the "0" and "1" mean?
More importantly, how do I create the file? I am so impressed and love learning something new. Can you so to speak, walk me through the steps, because I have several of these to do?
Wonderful way to start my day!!!
Thank you so very much.
1 Guest(s)
