I have a excel workbook filled with information that I would like to sort and also count but I do not know where to start…
I was thinking that it would work with a for each loop and for each row increment a variable that will in the end print the total amount or something.
What is important is the img files number, which all have a specific word tied to it. For example 1 = GK, 2 = RB, 3 = RW and so on.
Is there any way to create a for each row and if the row contains the number 1, then add +1 to a variable than can in the end be used to print the total value of how many 1.png exist in the excel workbook.
Those are just examples of what the final excel workbook would look like. Badly explained by me.
Basically every png represent a text (football position) so 1.png is LWG, 2.png is ST and so on. The value beneath those are where I want to put the actual numbers counted from the first image I attached. So for example, the total of 1.png in the first image COULD be 234…
Is my explanation making a bit more sense now or am I just making it more confusing?
where the values I am interested in are how many LWG, RWG, OMF etc there are in total among 20000 something players.
The LWG, RWG, OMF etc however are not text but images, that is why the received data is 1.png, 2.png etc. So I do not necessarily want the images, just the info of how many there are.
I want to maybe use a foreach row if that is the easiest, to count how many of the texts there are in total in the excel workbook.
Then I want to take that counted data and paste the total numbers into another workbook in their respective places
That sounds like it is on the right track but how would I accomplish that? I have not used filters before and I am pretty stupid when it comes to assigning counts… As you can probably tell…
@Robert_Wennberg Caan you send that Input Excel, but however the Mapping from 1.png to LWG and so on is quite not possible if no Alternative mapping is provided
Using Filter Data Table to find the data you are looking for, giving the column, what to keep what to delete than use var = var + 1 or as said before use count to count the rows number.
Would there not be an easier way to just iterate through column B and add +1 to a variable if the row contains 1.png, same thing for 2.png and so on? Or something along those lines.
I will try and see if I can get the Filter Data Table to work! Thank you for the guidance
The filter data table is very is very to use, let’s say you want to keep all the data that contains “True”, first you choose keep, than you enter the column that you want to check weither the data exists than you choose contains and give the value you want like “True”.
This will give you all the rows that the column A, contains the word “True”.
Thank you for a much more detailed explanation and taking your time to explaining it to me… I am new to all of this so it is a lot to take in! I appreciate everyone taking their time to help though
@Robert_Wennberg Check This Workflow, After you open this You may get Missing Activity Error , if you get , then From Manage Packages, Download and Save “Data Manipulations” Package
This is not the Complete Output What you needed though