Hi everyone,
I am looking for assistance to come up with a formula to display pictures (via URL) of first, second and last occurence of the event in the table in which the events are grouped by item names and category (every single event has a image of its own). I seemed to try everything I can think of, and got nowhere. The following is the principle of the data sheet:
| Item 1 | item 2 | Location | Index | event URL |
| A | B | 1 | 1 | Link 1 |
| A | C | 1 | 2 | Link 2 |
| A | D | 1 | 3 | Link 3 |
| A | E | 1 | 4 | Link 4 |
| B | A | 1 | 1 | Link 1 |
Please have in mind that these events of same items can occur in several places and they all have their own image. So my objective is to display several images as examples in one line. (probably it si best to display them in different columns??
My expected results should look similar to as the following:
| Item 1 | Item 2 | Category | Location | Count | Event image 1 | Event image 2 | Event image 3 |
| A | B | 1 | 1 | 10 | Event 1-image1 | Event 1-image2 | Event 1-image3 |
| A | C | 2 | 1 | 6 | Event 2-image1 | Event 2-image2 | Event 2-image3 |
| A | D | 1 | 1 | 7 | Event 3-image1 | Event 3-image2 | Event 3-image3 |
| A | E | 1 | 1 | 5 | Event 4-image1 | Event 4-image2 | Event 4-image3 |
| B | A | 1 | 1 | 10 | Event 1-image1 | Event 1-image2 | Event 1-image3 |
Could anyof you help me out with coming up with formulas to do something like that?
Looking forward to any help/guidance,
