I have an excel where i want to get row number for combination of Column values.
ColA Colb ColC
AA 123 Happy
BB 456 Sad
CC 678 Excited
So basically i want row number for combination of ColA+Colb+colc. Like AA123Happy should give row number 1. BB456Sad should give 2.
Thanks in Advance
Can you please give some more logic for the filtering?
are you trying to find the row number of a particular row which satisfies “AA123Happy” and “BB456Sad”
then the outputs should be 1 and 2 only , but 3 does not satisfy the filter as its “CC678Excited”
Add Data Column “RowNumber” using AddDataColumn Activity in your existing DT
Using for each row and assign(“RowNumber”)=Row(“cola”).tostring + row("colb).tostring+row(“colc”).tostring
Then you can write range the value
The above statement will help you get index.
Hope that helps.
So you just want to get the current row index number?
Or you need to get the row index of a given cell value?