obtaining data from a table

C

Chau

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

obtaining data in text form from a table 1
If Function 1
Countifs or a pivot 1
Need help with formula 8
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY 3
Search closest day in the past from today 2
table lookup 5
Report using dates as a criteria 1

Top