Read repeated names inexcel sheet and write in another sheet with count example sai is 5 times in excel sheet i want in another excel sheet sai = 5

Ask in Your Language
1

countingnames.xlsx (9.4 KB)

2

HI @Sai_V

How the expression?

DtRead.AsEnumerable.Where(Function(r) r("Names").ToString=CurrentRow("Names").ToString).CopyToDataTable

Check out the XAML file

ColumnNameCount.xaml (9.7 KB)

image
image607×531 27 KB

Output

image

Regards
Gokul