Auto fill in the blanks in Excel

0 votes
In my Excel spreadsheet, I have 3 columns of data: Business Unit (column 1), Item (column 2), and Cost (column 3). All rows of columns 2 and 3 include data, but column 1 only has a single business unit before being blank until the business changes. For each business unit, I can just drag the data and control down to the empty ones, but what if I have thousands of rows and numerous business units? I'll need a lifetime to complete that. Is there a quicker way to complete this task?
Oct 27, 2022 in Others by Kithuzzz
• 38,000 points
723 views

1 answer to this question.

0 votes

Considering the information below: Step 1: Choose a cell from A2 through A31 (all the data rows under the Unit column) Step 2: Select Find & Select from the home tab. Choose Go to Special in step three. Step 4: Click OK after selecting Blanks. Step 5: Enter =A2 (which equals the cell above the blank) in the first cell, then press CTRL+ENTER.

enter image description here

answered Oct 27, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

What are the RGB and HEX codes of the 3 color conditional format in Excel?

In Excel 2016 at least the colors ...READ MORE

answered Sep 24, 2022 in Others by narikkadan
• 63,600 points
8,686 views
0 votes
1 answer
0 votes
1 answer

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,600 points
908 views
0 votes
1 answer

Change the size of one cell in excel 2016

I'm sorry, but it's not feasible. A ...READ MORE

answered Oct 8, 2022 in Others by narikkadan
• 63,600 points
556 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
4,042 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,999 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
980 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,693 views
0 votes
1 answer

Excel vba auto log in to hdfc bank and downloading the bank statement

That page has a bunch of nested ...READ MORE

answered Jan 6, 2023 in Others by narikkadan
• 63,600 points
651 views
0 votes
1 answer

Extract unique value from the range in Excel

The portability of spreadsheet functions like UNIQUE() ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
1,275 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP