Pasting a Date into cells that have data in only

DharmeshChauhan

New Member
Joined
Apr 25, 2022
Messages
16
Office Version
  1. 365
Platform
  1. Windows
Hi

I have a numbers of rows with dates, some of the cells are blank in these rows

My manager asked to to find the earliest date in each row (used formula =SMALL(A1:D7,1) this returned me the earliest date from the row

I need to paste this result (earliest date) into all the cells that have a date and avoid the blank cells for each row

Thanks

Dharmesh
 

Attachments

  • Capture - Earliest Date.PNG
    Capture - Earliest Date.PNG
    22.5 KB · Views: 21

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
_CECG Individual Exposure Form (QF 104) Version 3 (For Health Partner - With Diageo Recall Structure).xlsx
ADAEAFAGAHAIAJAKAL
1Working at Height Last Working at Height (Date)Lone Worker Last Lone Worker (Date)DriverLast Driver (Date)Role Shunter DriverLast Shunter Driver (Date)Earliest Date
2
301-04-202229-05-201829-05-2018
420-01-2022
5
6
7
812-03-2021
913-01-202013-01-202013-01-201813-01-2018
1020-12-202120-12-202130-10-201930-10-2019
11
1231-01-202020-03-201820-03-2018
1314-02-2022
1429-10-201929-10-2019
1512-02-2020
1623-06-201923-06-2019
Full List
 
Upvote 0
Hi

Using row 3 as an example

I have worked out the earliest dates (Column AL) for each row, i need this date pasting in the all the cells that have dates in already in row 3, and the blank cells staying blank
 
Upvote 0
Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Pasting a Date into cells that have data in only
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.
 
Upvote 0
Hi

Sorry, I posted my query here and then on the other forum I left the link there, I thought I did it all correctly

Thanks
 
Upvote 0

Forum statistics

Threads
1,223,885
Messages
6,175,183
Members
452,615
Latest member
bogeys2birdies

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
Back
Top