Data Table Question

[Russ At Index]

Morning ,

I have a table with the following headers :

Date , Year , Month , WeekDay , DayNumber , WeekNumber , Shift , Parcel , O/L

I am looking to extract into a separate sheet the all the corresponding row data based on the highest
figure within the parcel column .

Any assistance would be greatly appreciated .

Regards,
Russ.

 

[arthurbr]

Perhaps

= FILTER(A2:I20,H2:H20=max(H2:H20))

 

[HighAndWilder]

Perhaps

= FILTER(A2:I20,H2:H20=max(H2:H20))

Or make it dynamic where the table name is tblData.

=FILTER(tblData,tblData[[ Parcel ]]=MAX(tblData[[ Parcel ]]))

 

[HighAndWilder]

Morning ,

I have a table with the following headers :

Date , Year , Month , WeekDay , DayNumber , WeekNumber , Shift , Parcel , O/L

I am looking to extract into a separate sheet the all the corresponding row data based on the highest
figure within the parcel column .

Any assistance would be greatly appreciated .

Regards,
Russ.

If you want the headers and the date to be formatted.

Substitute tblData with the actual table name.

=LET(d,SORT(tblData,8,-1),VSTACK(tblData[#Headers],CHOOSEROWS(HSTACK(TEXT(INDEX(d,,1),"DD/MM/YYYY"),DROP(d,,1)),1)))

 

[Russ At Index]

Morning arthurbr & HighandWilder ,
Many thanks for the prompt response , appreciated as always .
All solutions worked perfectly , thank you

Have a good weekend ,

Russ.