Fill data in a column based on 2 condition

@Shilpa_Mohanty
find some starter help here:

it is using LINQ for grouping the data and used the for each index out put for the flagging
grafik

XAML here:
Shilpa_Mohanty.xaml (10.2 KB)

from RnDs, processing time mesaures using for each in a core way is NOT to avoid.
Thats why the hybrid approach (do grouping with LINQ, update with for each) is well balancing

  • the compact way of LINQ
  • the maintainability of for each along the debugging options

we would recommend this approach.

For a LINQ only approach we would request some data samples with the exact data column structure.


getting this error

do following:
grafik

Tested this code for more than 20000 records. You may need to fine tune selectors and delays to your need. Assumed that there are no blank entries in column A.
It’s like magic. The real power of automation.

image
Fill data in a column based on 2 condition.xlsx (1.1 MB)
Fill data in a column based on 2 condition (2).xaml (16.7 KB)

thanks for the response
but here we cant use write cell. we have to play around using linq query and datatable