DharmeshChauhan
New Member
- Joined
- Apr 25, 2022
- Messages
- 16
- Office Version
- 365
- Platform
- 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
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