Copy data from two columns to third columns on a condition
Closed
tarek-kamel
Posts
1
Registration date
Tuesday April 8, 2014
Status
Member
Last seen
April 8, 2014
-
Apr 8, 2014 at 06:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 8, 2014 at 11:27 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 8, 2014 at 11:27 AM
Column A1 containing the current day =today()
From B4:B33 the dates from the beginning of the month till end of the month
From C4:C33 the first column i want to copy from it
From E4:E33 the second column i want to copy from it
What i need now if the date from B4:B33 is > Today to copy from Column C start from today till the end of the month including today & past it in column G
if the date from B4:B33 is < Today to copy from Column E start from the beginning of the month untill yesterday & past it in column G
From B4:B33 the dates from the beginning of the month till end of the month
From C4:C33 the first column i want to copy from it
From E4:E33 the second column i want to copy from it
What i need now if the date from B4:B33 is > Today to copy from Column C start from today till the end of the month including today & past it in column G
if the date from B4:B33 is < Today to copy from Column E start from the beginning of the month untill yesterday & past it in column G
Related:
- Copy data from two columns to third columns on a condition
- Display two columns in data validation list but return only one - Guide
- Tweetdeck larger columns - Guide
- How to delete columns in word - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 8, 2014 at 11:27 AM
Apr 8, 2014 at 11:27 AM
Hi Tarek-Kamel,
Not clear.
If Today must be bigger or smaller then the range B4:B33, then Today will never match any of the value in B4:B33, thus the ranges C4:C33 and E4:E33 will always be copied in it's entirety.
And that is not what you want, right?
Best regards,
Trowa
Not clear.
If Today must be bigger or smaller then the range B4:B33, then Today will never match any of the value in B4:B33, thus the ranges C4:C33 and E4:E33 will always be copied in it's entirety.
And that is not what you want, right?
Best regards,
Trowa
