Hello All,
I'm a newbie here so please don't be too harsh with me
I apologise if this has been covered somewhere before, but I can't find any information on what I'm looking to achieve.
Here goes,
I'll have a Master sheet that I will populate with ID numbers, names, dates and number of days etc, so it will be updated with new data frequently. The problem being there will be duplicate ID numbers and names appearing all the time.
Ideally, what I would like it to do is auto populate a separate sheet with it pulling the ID number and name through (only once, so I'd like it to automatically remove duplicates in the process), whilst adding up the number of days associated with these multiple lines of ID numbers.
Hopefully I make sense
I thought I was good at excel but I can't put my finger on the best way to approach it and actually feel a bit silly asking this question which is probably a walk in the park for most of you.
Thank you for taking the time to read this.
I'm a newbie here so please don't be too harsh with me
I apologise if this has been covered somewhere before, but I can't find any information on what I'm looking to achieve.Here goes,
I'll have a Master sheet that I will populate with ID numbers, names, dates and number of days etc, so it will be updated with new data frequently. The problem being there will be duplicate ID numbers and names appearing all the time.
Ideally, what I would like it to do is auto populate a separate sheet with it pulling the ID number and name through (only once, so I'd like it to automatically remove duplicates in the process), whilst adding up the number of days associated with these multiple lines of ID numbers.
Hopefully I make sense
I thought I was good at excel but I can't put my finger on the best way to approach it and actually feel a bit silly asking this question which is probably a walk in the park for most of you.Thank you for taking the time to read this.
