Maximum Occurrence of a value in a column datatable/excel

[Shaeen_Shah]

Can anyone help me with this

[nikhil.girish]

Hi @Shaeen_Shah

Refer this thread hope this helps

How can i find the Maximum Occurrence of a value in a column of a datatable

Hi, If you want to get the most occurrence values in a column, the following will help you. Value dt.AsEnumerable.GroupBy(Function(r) r("ColumnName").ToString).OrderBy(Function(g) g.Count).Last().First().Item("ColumnName").ToString() Count dt.AsEnumerable.GroupBy(Function(r) r("ColumnName").ToString).OrderBy(Function(g) g.Count).Last().Count Regards,

[suraj.setty]

@nikhil.girish

Refer this thread hope this helps

Hi @Shaeen_Shah

Please let us know if this is what you are looking for , or something else.

Thanks.

[Shaeen_Shah]

Thanks @nikhil.girish