Hello Everyone,
I welcome myself here as it is my first day and my first post on this forum! :D
For anyone who can remotely help in any shape or form, I will try to be as clear as possible:
I have a "table1 " with data. Column A in table1 is the names of different institutions but are repeated. Column C is the year 2011 to 2020. and Columns B : L are datas from those years.
In Table2 I have a list of all the institutions in Column A NOT Repeated.
'--- I want to find all the rows in Table1.ColumnA where its value is = to Table2.ColumnA
and if so, To perform WSFunction.Correl of (Array 1 and 2) taking other columns in the table with the same rows as the previous line.
In my little example below ..
In my Table2.Column B for all rows where Table1.ColumnA = Table2.Cell then
CORREL ( ARRAY1=take the name of the header in Table2.ColumnB and all the ROWS previously found, Array2 Take all the values in Column PRICE with Rows equal to what has been previously found)
Can I use the same line to calculate all my cells in Table2?
Table1
A 2011 121 5151 51616
A 2012 156 62 2662
A 2013 662 616 62
B 2011 161 626 32132
B 2012 626 3232 3131
B 2013 6161 3213 313
C 2011 62 3131 3131
C 2012 121 3231 156
C 2013 ...
...
Table2
A
B
C
...
Any thoughts on how I can go about it? This is beyond my abilities of VBA at the moment.
I greatly appreciate your time and help