Question description:
This user has given permission to use the problem statement for this
blog.
Two columns of data, trying to fill in the blanks in the second column. Example:
A = B
A = Blank
A = B
C = D
C = D
C = Blank
C = D
Solved by S. Q. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
07/06/2018 - 05:13
Hello
User
07/06/2018 - 05:13
Hi
Excelchat Expert
07/06/2018 - 05:13
Welcome to excelchat
Excelchat Expert
07/06/2018 - 05:14
I want to understand the problem clearly, can you please explain it once again by showing some sample data in the preview window?
User
07/06/2018 - 05:14
I can't show example due to the confidential nature of the data, but I will try to explain using the window
User
07/06/2018 - 05:15
Trying to fill in the blanks with the missing data
Excelchat Expert
07/06/2018 - 05:16
Meaning Bob Smith will be filled with 12345 in B3?
User
07/06/2018 - 05:16
Right
User
07/06/2018 - 05:16
Susan will be filled in with 34567
Excelchat Expert
07/06/2018 - 05:17
Okay, understood.
Excelchat Expert
07/06/2018 - 05:17
For this, the data need to be in sorted order.
User
07/06/2018 - 05:17
Column A is already sorted in alphabetical order
Excelchat Expert
07/06/2018 - 05:18
Great.
Excelchat Expert
07/06/2018 - 05:18
Please see column C.
Excelchat Expert
07/06/2018 - 05:19
In C1, the formula is =B1. This is the first row.
Excelchat Expert
07/06/2018 - 05:19
Then in C2 the formula is =IF(B2="",C1,B2)
Excelchat Expert
07/06/2018 - 05:19
We can drag this formula down to fill in the empty cells.
Excelchat Expert
07/06/2018 - 05:20
Please let me know if you have any question.
User
07/06/2018 - 05:21
Trying it now
Excelchat Expert
07/06/2018 - 05:21
Okay, I'm here if you need me.
User
07/06/2018 - 05:22
Wow, I think that worked!
Excelchat Expert
07/06/2018 - 05:22
Great.
Excelchat Expert
07/06/2018 - 05:22
Anything else?
User
07/06/2018 - 05:23
I don't think so. Thank you so much
Excelchat Expert
07/06/2018 - 05:23
In that case, the session will end in 9 minutes unless you opt to end it now.
User
07/06/2018 - 05:24
I think we're good. Thanks again
Excelchat Expert
07/06/2018 - 05:24
Thanks for visiting excelchat, have a great day.
User
07/06/2018 - 05:24
You too
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.