Hello all,
I have a data set with SSN and demographic data for people on a plan. In most cases its a subscriber and dependents. The dependents all have different SSN but I need to fill in the Subscriber SSN. I have a fake data set attached and the cells in yellow I need the Subscriber SSN essentially to fill down until the next new value. In my dataset I would need A2 to populate to A5 then A6 to populate to A10. Any guidance would be appreciated.
Solved! Go to Solution.
Hi @bvolles ,
A multirow Formula should do this for you.
Please find attached an example with the file you had provided.
Hope this helps.
Best,
Jagdeesh
Thank you all very much it worked perfectly!
User | Count |
---|---|
59 | |
26 | |
24 | |
22 | |
21 |