ExcelBanter - obtaining data from a table

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - obtaining data from a table (https://www.excelbanter.com/excel-worksheet-functions/257191-obtaining-data-table.html)

chau

obtaining data from a table

Hi all,

I like to be able to obtain the dates in a text format from the table
below. ie
Test2 8-Feb
Test5 4-Feb,8-Feb
Test6 4-Feb,5-Feb, 9-Feb

Do I need to do this by macros and if so, any help would be appreciated.

Table
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb

Test1
Test2 8-Feb
Test3
Test4
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb

Fred Smith[_4_]

obtaining data from a table

See your other post.

"Chau" wrote in message
...
Hi all,

I like to be able to obtain the dates in a text format from the table
below. ie
Test2 8-Feb
Test5 4-Feb,8-Feb
Test6 4-Feb,5-Feb, 9-Feb

Do I need to do this by macros and if so, any help would be appreciated.

Table
Care Recipient Surname 4-Feb 5-Feb 8-Feb 9-Feb

Test1
Test2 8-Feb
Test3
Test4
Test5 4-Feb 8-Feb
Test6 4-Feb 5-Feb 9-Feb

All times are GMT +1. The time now is 10:52 PM.