Fill blank cells in a column?
Hello. I have a excel sheet with 25k rows.
As you can see in the screen shot on the first rows I need to fill the blank 3-4 rows with the article number just above te blanks. See the first Column A row 2-4. Thats how the entire 25k rows of column A need to look.
How can that be accomplished?
screenshot 2015-08-21 kl. 09.36.35.jpg
are there ALWAYS 2 blank rows?
Please attach a sample workbook. Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!
Click on GO ADVANCED and use the paperclip icon to open the upload window.
The paperclip icon
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Presuming that columns B & C have data in them all the way to the bottom of the data...
Please Login or Register to view this content.
Happy to help, if I did please Add Reputation
No reply... OK. Assuming that there are ALWAYS two blank rows, put this in A2 and copy down as far as needed:
=OFFSET($B$2,3*INT((ROWS($1:1)-1)/3),,,)
Thank you for helping, sorry Glenn I had to take care of a customer.
Here is a example workbook
no there are sometimes 2 and sometimes 3 blanks
OK. Put this in a spare column, row 2. Copy down as far as needed. Then select all values, copy them and paste values back into column A. delete the content of the spare column.
Done??
=IF(A2="",D1,A2)
Thank you. I put it in column E 2:nd row but nothing happens. Im using Excel 2011 on a mac, would that be a problem with special symbols?
Where are you (that's why we ask for this information to be shown in your profile)? If you're in mainland Europe, you may use ; instead of , As you can see it worked here.
Re: Fill blank cells in a column?
Yes, i am in Europe, Sweden. Exel usually suggests a change of thos special characters but not this time. Ill try change them...
That seem to do the trick. BIG thanks to you Glenn!!
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks