Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2020, 06:49 AM
Mukapa Mukapa is offline Filling different cells at a time Windows XP Filling different cells at a time Office 2003
Novice
Filling different cells at a time
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default Filling different cells at a time

Greetings,


I have been given a large document containing blank cells which, I wish I could fill with the text at the starting of each blank space. For more clarification kindly find on attachment a sample of my document and what I wish to do.
Your help would very welcome
Attached Files
File Type: xlsx New Microsoft Office Excel Worksheet (2).xlsx (10.4 KB, 9 views)
Reply With Quote
  #2  
Old 02-18-2020, 08:28 AM
DJ0691 DJ0691 is offline Filling different cells at a time Windows 10 Filling different cells at a time Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default one possible solution

See attached; basically simply adding three new columns with formulas that give you what I think you want. If you want to replace the original columns, then you could do a copy>paste special>values on the three new columns and delete the original three columns.
Attached Files
File Type: xlsx New Microsoft Office Excel Worksheet 3.xlsx (11.0 KB, 9 views)
Reply With Quote
  #3  
Old 02-18-2020, 10:15 AM
Mukapa Mukapa is offline Filling different cells at a time Windows XP Filling different cells at a time Office 2003
Novice
Filling different cells at a time
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default

Thank you very much DJ0691, the formula works. But could you please explain a bit more the magic of it? I don't understand
Reply With Quote
  #4  
Old 02-18-2020, 10:31 AM
DJ0691 DJ0691 is offline Filling different cells at a time Windows 10 Filling different cells at a time Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default

Sure: Your original data starts in cell A2 (student ID). In cell E2 you'll see the formula: =IF(A2<>"",A2,E1) which means "if cell A2 is not blank, then display whatever is in A2; If it is blank then display whatever is in the cell directly above it". In this way the data is displayed correctly as you copy the formula on down to the bottom. Same method in cell F2. Cell G2 is simply whatever is in cell C2. That help?
Reply With Quote
  #5  
Old 02-18-2020, 10:40 AM
Mukapa Mukapa is offline Filling different cells at a time Windows XP Filling different cells at a time Office 2003
Novice
Filling different cells at a time
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default

Thank you again. What I din't understand is to write the formula of "if a cell is not blank" (<>"" ). This is new to me. I tried to search it in google but I didn't find a such a formula which say "if a cell is not blank". I realize it is the opposite of "equal to" written as =""
Thank you very much
Reply With Quote
  #6  
Old 02-18-2020, 12:35 PM
p45cal's Avatar
p45cal p45cal is offline Filling different cells at a time Windows 10 Filling different cells at a time Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

In your file, select the cells A1:C7
Press F5 (function key) on the keyboard,

click Special…
choose Blanks, click OK
Now don't touch anything except:
press the = sign on the keyboard, followed by the up-arrow (cursor key) then
hold down the Ctrl key and briefly press the Enter key.
(Your blanks should be populated now)
Convert the formulae to plain values by copy/paste-special|Values in situ.
Reply With Quote
  #7  
Old 02-18-2020, 01:09 PM
DJ0691 DJ0691 is offline Filling different cells at a time Windows 10 Filling different cells at a time Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default

..now THAT was magic
Reply With Quote
  #8  
Old 02-19-2020, 01:11 AM
Mukapa Mukapa is offline Filling different cells at a time Windows XP Filling different cells at a time Office 2003
Novice
Filling different cells at a time
 
Join Date: Jan 2016
Posts: 10
Mukapa is on a distinguished road
Default

Thank you lol, thank you all
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Filling in cells based on 2 other cells data Dawindle Excel 4 11-10-2018 07:40 AM
Filling different cells at a time Cells automatically filling in otuatail Excel 3 08-17-2017 11:31 PM
filling in blank cells with data from cell above RayK Excel 1 01-12-2017 04:14 PM
Filling cells with random numbers using loops? (VBA) Sajj Excel Programming 4 04-10-2013 02:29 PM
Filling different cells at a time filling multiple cells whislt using Filter VinceO Excel 1 05-09-2011 06:38 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft