Trying to use lookup to display data within a date range.

I have multiple operations for each project.
Capture.JPG
I need the data to display in a line like shown below. For the operations that have the same day, I want the letters to concatenate (ME). I have multiple operations shown above in different date ranges, I'd like each to be displayed on the same line.


I am really struggling, please help!

Welcome to the forum.

Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

Instructions (Please Read Carefully):

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

anderem12 will there ever be instances of 3 or more operations?

Never mind. I answered my own question.

And from the looks of things that could also include

	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT
20	55	56	57	58	59	60	61	62	63	64	65
21
22	FQ	GVT	GVT	GVT	GVT	GVT	DVT	DVT	DVT	DVT	VT

Originally Posted by anderem12

... I'd like for each of the projects to have their own row that shows each operation within the date range ...

We will need a representative sample of data source that also includes multiple Projects. That layout will likely affect the solution(s) offered.

This will require a user defined function (VBA). I have used tigeravatar's CONCATALL. It is installed in the attached. Here is the code.

Please Login or Register  to view this content.

Although the code is installed already in the attached if you are not familiar with how to do this:

1. Copy code
2. Press Alt and F11 on your keyboard to open VB Editor
3. Click on Insert and select Module
4. Paste code into Module and close VB Editor.

Don't forget to save your worbook as Macro-Enabled workbook.

In row 11 are the dates to test same as your previous upload. In D13:D16 the list of Projects. The data in your row 5 needed cleaning up (Done in the attached). There were several extra spaces in the data. This causes havoc in formulas.

Then this array entered formula in E13 filled down and across column DT. 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.

Why wont it work on the test page at the bottom for what I have where it says NAME?

I am getting an error that says "Ambiguous name detected:ConcatAll

You have installed the CONCATALL twice. Open VBA editor and remove the second module. Return to the spreadsheet and hit the F9 function key.

You are welcome. Thank you for the feedback, added rep and marking your thread Solved.

BTW: Please share what you did to make it work.