Find row value with specific

Hi,
I’ve sheet with data. I find the max Price and based on the max price find the entire row.
How to do it ?
Thank u.

you mean find the maximum surcharge?

yes. max surcharge and it’s entire row data

Hi @Prinal_C
use below assign activity to filter the rows having max surcharge value

dt_result = dt1.AsEnumerable().Where(Function(row) row(“Surchage”).ToString(dt1.AsEnumerable().Max(Function(row) CDbl(row(“Surcharge”)).ToString).CopyToDataTable

Regards,
Nived N
Happy Automation

@NIVED_NAMBIAR thank u… not able to do this in StudioX. Need it in StudioX.

Calculate the maximum price with an Excel formula, then iterate with ForEachRow to discover the rows with the max price.

image