Hi all,
I have input that looks like this:
A B 1 Date Note 2 12/02/2017 Do this 3 21/02/2017 And that 4 2/02/2017 and maybe this 5 3/01/2017 But not this 6 31/01/2017 leave this out 7 10/02/2017 lets add this too
And the output to end up in a single cell like this:
Desired Output 2/2/2017 - and maybe this
10/2/2017 - lets add this too
12/2/2017 - Do this
21/02/2017 - And that
Anyone have any ideas on this?
In column C =Concatenate(A2,"-",B2) and then copy down.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I want only the May items and outputted to a single cell
And the output to end up in a single cell like this:
Desired Output
2/2/2017 - and maybe this
10/2/2017 - lets add this too
12/2/2017 - Do this
21/02/2017 - And that
output to end up in a single cell?
DO YOU MEANS SINGLE COLUMN & 4 ROWS?
OR SINGLE COLUMN & SINGLE ROW?
CAN DATE IN COLUMN A BE FILTERED & SORTED?
Hi,
I'm looking for a formula that'll pick out those dates in May and then print the strings and the associated dates in a SINGLE CELL.
The reason is I want to have this displayed in a tiled report.
I know it's possible but not easy necessarily.
FYI, those dates are in February, not in May ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hahaha. right you are.... shows how dumb I am :DOriginally Posted by AliGW
FYI, those dates are in February, not in May ...
try this if suite your requirement(Note: After filtered and sorted date for February) :
=CONCATENATE(CONCATENATE(TEXT(A4,"dd-mm-yy"),"-",B4),"/",CONCATENATE(TEXT(A5,"dd-mm-yy"),"-",B5),"/",CONCATENATE(TEXT(A6,"dd-mm-yy"),"-",B6),"/",CONCATENATE(TEXT(A7,"dd-mm-yy"),"-",B7))
Hi there,
I kind of can't have any manual steps to filter and sort, that part I can manage. I am hoping to actually pick out what I need by formula to automate a summary.
The picking out multiple dates and returning multiple strings without a macro is where I am stuck.
There is a user defined function called CONCATALL found here:
http://www.excelforum.com/tips-and-t...ml#post3096647
Here is the code:
Install the code in the VBA editor. The output is done for you in the attached.
Please Login or Register to view this content.
Then this array entered formula.
If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.Formula:
Please Login or Register to view this content.
The CHAR(10) separator creates a new line. You may have to format Alignment for Word wrap and then adjust the height.
The output looks like this:
21/02/2017 - And that
2/02/2017 - and maybe this
10/02/2017 - lets add this too
Dave
Any ideas anyone?
Looks like we posted at the same time. LOL
@FlameRetiredLooks like we posted at the same time. LOL
Mate that is exactly what I was trying to achieve. Thank you so much for that.
I thought it might have to do with an array formula but I'm very rusty with excel so this is a welcome helping hand.
You are welcome. Thank you for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks