Formula to fill cell in with the day of the week

suprsnipes

Active Member
Joined
Apr 26, 2009
Messages
428
I have a sheet with the following data in column A beginning from row 2.

Mon
blank
blank
blank
blank
blank
Tue
blank
blank
Wed
blank
blank
blank
blank
Thu
blank
blank
Fri
blank
blank
blank
Sat
blank

What I want to do is fill in the blank cells with the same day as the bold day above it using a formula that allows for the days and blanks to be in different rows as the above data is linked to another sheet.

How could I achieve the above?

Thank you in advance,
suprsnipes
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Hilghlight the column
Click Edit - Goto - Special - Blanks - OK.
Press =
Press UP Arrow
Press CTRL + ENTER


Hope that helps.
 

anglais428

Well-known Member
Joined
Nov 23, 2009
Messages
634
Office Version
  1. 2016
Platform
  1. Windows
To fill as the same as the bold cells, highlight the cells, CTRL + click on A2, CTRL G, special, highlight blanks, enter "=" and press the up arrow key, click CTRL + Enter
 

suprsnipes

Active Member
Joined
Apr 26, 2009
Messages
428
I actually want to fill the blank cells in using a formula. The blank cells contain a basic formula already that references the same cell id on another sheet so perhaps what I need is a formula that can be placed in column B that can fill in the blanks?

I am using Excel 2000.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,126,949
Messages
5,621,781
Members
415,856
Latest member
jimb2k

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top