Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
66
Views
Topic starter
I am trying to create a formula to take text from 2 different columns and extract the text only and create one single list in another column. I can get one column to work with:
=IFERROR(INDEX($B$5:$B$23,SMALL(IF(ISTEXT($B$5:$B$23),ROW($B$1:$B$19),""),ROW(A1))),"")
I want to take the date in B5:B19 and D5:D19 and place in a single column H27:H44.
Is this possible?
Posted : 03/09/2018 3:26 pm
Hi Robert,
When checking the file it is empty for me.
Br,
Anders
Posted : 05/09/2018 12:04 pm
Topic starter
Hi Anders...
Somehow I finally figured out a formula to make it do what I want. Thank you for looking at it though!
Robert
Posted : 05/09/2018 5:06 pm
