Pasting a Date into cells that have data in only

[DharmeshChauhan]

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

 

[DharmeshChauhan]

_CECG Individual Exposure Form (QF 104) Version 3 (For Health Partner - With Diageo Recall Structure).xlsx
	AD	AE	AF	AG	AH	AI	AJ	AK	AL
1	Working at Height	Last Working at Height (Date)	Lone Worker	Last Lone Worker (Date)	Driver	Last Driver (Date)	Role Shunter Driver	Last Shunter Driver (Date)	Earliest Date
2
3	01-04-2022				29-05-2018				29-05-2018
4									20-01-2022
5
6
7
8									12-03-2021
9	13-01-2020		13-01-2020		13-01-2018				13-01-2018
10	20-12-2021		20-12-2021		30-10-2019				30-10-2019
11
12			31-01-2020		20-03-2018				20-03-2018
13									14-02-2022
14			29-10-2019						29-10-2019
15									12-02-2020
16	23-06-2019								23-06-2019
Full List

 

[DharmeshChauhan]

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

 

[Fluff]

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.

 

[DharmeshChauhan]

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