Get The Last Rows Of A Collection

Input collection: myCars13

Year	Make	Model
2016	Toyota	Corolla
2014	Honda	Civic
2019	Toyota	Camry
2018	Honda	Civic
2018	Hyundai	Elantra
2020	Honda	Accord

Output collection: mySolution13a

Year	Make	Model
2020	Honda	Accord

Solution code:

//Create a collection
ClearCollect(myCars13,
{Year: 2016, Make: "Toyota", Model: "Corolla"},
{Year: 2014, Make: "Honda", Model: "Civic" },
{Year: 2019, Make: "Toyota", Model: "Camry" },
{Year: 2018, Make: "Honda",Model: "Civic"},
{Year: 2018, Make: "Hyundai", Model: "Elantra"},
{Year: 2020, Make: "Honda", Model: "Accord"}
);

//Get the last row only code
ClearCollect(
    mySolution13a,
    Last(myCars13)
);

Output collection: mySolution13b

Year	Make	Model
2018	Toyota	Civic
2018	Hyundai	Elantra
2020	HOnda	Accord

Solution code:

//Create a collection
ClearCollect(myCars13,
{Year: 2016, Make: "Toyota", Model: "Corolla"},
{Year: 2014, Make: "Honda", Model: "Civic" },
{Year: 2019, Make: "Toyota", Model: "Camry" },
{Year: 2018, Make: "Honda",Model: "Civic"},
{Year: 2018, Make: "Hyundai", Model: "Elantra"},
{Year: 2020, Make: "Honda", Model: "Accord"}
);


//Get the last rows code
ClearCollect(
    mySolution13b,
    LastN(myCars13,3)
);