Challenge #338: Let's Summarize!

[Michael_Dooley]

I didn't match results but think I have the right answer...

   Why no love for John Coltrane and his 12 albums?

    Album years differ as well but reconcile to data. Solution has odd results like first year = 1996 and last year = 1983?

Spoiler

[leebria3]

Here is my solution. 

My result doesn't exactly match with the suggested output due to 'John Coltrane', but wanted to share what I think the result should be.

Spoiler

[Clifford_Coon]

My Solution: 

The First/Last year in the provide result seem to be in the row order not year order.

Spoiler

 

[TurboToad]

Not sure what the note was supposed to mean since I didn't see any results without a year value. Output didn't exactly match but captured the ask.

Spoiler

[Pawel_Paleczny]

Quite different result :)

[rachel_lynch]

I do not return any null release years using this formula:

IIF(REGEX_Match(Right([rel_date],4),"\d{4}"),Right([rel_date],4),Null())

Spoiler

[Qiu]

I also noticed discrepancies with the provided resutls.

Spoiler

[balajilolla1]

Spoiler

Solution Attached

[lugesy]

My outputs are also not matched exactly with the start file's outputs.

[DanFlint]

Spoiler