Lookup question..please help

[reddo]

Hi guys

Im hoping some one can help me with a problem..

Basically, I want my excel formula to pick up which days are populated with info??

So I have a list of companies in column A1, A2, A3, A4 etc
Then I have the days of the week going across the top as the header.
For each company, certain days are populated with codes
For each company, I need my formula to pick up these days

For example, Company A has info in monday and Tuesday, So I need my formula to say "Monday,Tuesday"
Similarily, a company might only have info in one day- So in this case I want it to say "Monday"

Any ideas??

Thanks!

[vlady]

Welcome to the forum.

Attach a sample workbook.This will ensure that other members understand your query and it is better to solve a problem with actual data in it and expected output.

When you are in Advanced reply, click on the paperclip to open the upload window.

View Pic

[reddo]

Please see attached

Thanks

[abousetta]

It's a little long but try this formula:

Please Login or Register  to view this content.

abousetta

[reddo]

Much appreciated - Thanks

(I love this forum :-)

[abousetta]

Glad we could be of assistance.

Good luck.

abousetta

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save