I have 2 questions.
I am trying to sort my excel file. I need to sort 2 columns in ascending order.
In the “Sort Data Table” activity i am specifing the “Name” of the column. The problem is it cant find the column name. the specific column name is the “C7” position. When I manually remove the first 6 rows and the column is in the “A7” position the sorting works, why is this?
When i tried to sort with the index position instead it works but i get data that i dont need in the other 6 rows.
the first question is part of this one. I have exported excel file(same as in 1.) I have 2 columns that i want to compare. In Column “H” and column “I” i have data that i need to use.
Column “H” contains names and column “I” contains the word “Yes”.
Is it possible that I can in the same excel file match the unique(the same name can appear multiply times in the same column) names with the word “Yes”. After i need to divide number of “Yes” with the unique name.
Example: The name “David” appears 150 times and “Yes” appears 120 times in the opposing column.
I then want to calculate the difference 120/150=…
Is this possible, I hope you can understand what I mean.