Forum Discussion
Is there a formula to auto fill down text?
I have Client names in Column A. In column B, I have various projects that take up multiple cells below. The client name is only on the line of the first project but then is blank until it gets to the next client.
Example:
Is there a way to auto fill down Client A until it gets to Client B, Client B until Client C, etc. without having to do this one client at a time? I have 500 + clients I need to do this for.
Thanks.
So I selected the range and did as you suggested. All of the correct blank cells were highlighted. I used the formula =A6.
Now, instead of '0' appearing in all the blanks, 'A6' is what appears.
I tried the IF function in the helper column, as suggested by adversi. The same thing happened and 'A6' is what appeared as a result.
Are there any settings I need to adjust for the cells?
Thanks.
15 Replies
KimLabenz365 You can also apply an IF function that can fill in the gaps as a helper column. Once you have the final result, just replace the original column as a text of the solution -- see example attached.
Hi KimLabenz365
If you'd like an automated solution my toolbar has a macro to do this automatically
It's free to download here https://aasolutions.sharepoint.com/:f:/g/AA_CPort/EtpJN66fRtVEg88ERyLSE9EBadMrjN79rT2bWPDoXbLUHA?e=yVzVZP
Wyn
MVP
UTC+8
My Linkedin Articles...https://www.linkedin.com/today/author/wynhopkins
- Wonderful
Select column A.
Press Ctrl+G to activate the Go To dialog.
Click Special...
Select Blanks, then click OK.
Enter the formula =A1 and confirm it with Ctrl+Enter to populate all selected cells.
Each of the steps seem to lead me in the right direction until I get to the last step of enter '=A1 and press enter.' All of the blank cells are highlighted but the data is not filling.
I do have column headings in Row 5 so my client data starts in A6. Rows 1 - 4 include a title/description of the report I am trying to create.
You should press Ctrl+Enter, as I wrote in my previous reply.
