Excel formula for filling another cell
Closed
ejeruratyuuga

Mar 12, 2022 at 09:46 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022  Apr 7, 2022 at 11:26 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022  Apr 7, 2022 at 11:26 AM
Related:
 Excel formula for filling another cell
 Date formula in excel dd/mm/yyyy  Guide
 Position formula in excel  Office Software Forum
 Number to words in excel formula  Guide
 Excel formula if cell contains text then return value in another cell ✓  Excel Forum
 Excel marksheet formula  Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Apr 7, 2022 at 11:26 AM
Apr 7, 2022 at 11:26 AM
Hi ejeruratyuuga,
How about you put this formula in D2:
=IF(B2="Sunday","Sunday",IF(B2="Saturday","Saturday",""))
Drag the formula down as far as needed and when a cell in column D is empty, you will know to enter an Activity there.
Best regards,
Trowa
How about you put this formula in D2:
=IF(B2="Sunday","Sunday",IF(B2="Saturday","Saturday",""))
Drag the formula down as far as needed and when a cell in column D is empty, you will know to enter an Activity there.
Best regards,
Trowa