REPLACE ALL VALUES IN AN ARRAY FOR FREQUENCY RESULTS.

[vicktor schausberger]

I am looking to replace all the values of the array B2:G2066 for the frequency results values; example the first row B2:G2 will be replaced or swap the values from the frequency results on I2:I54 to be more clear,

The row B2:G2 is 9-12-15-21-33-45 and in column “ I “ is the frequency taken in the range of 18 numbers from B3:G20, in the bin H is the numbers from 1 to 53 so in front of 9 in column I you see number one, this is the number will replace 9, so the row B2:G2 sheet 2 will be like this 1-1-4-1-0-1.
The formula used here is thanks to the ninja Hui (=FREQUENCY(OFFSET($B$3:$G$20,COLUMN()-COLUMN($I$1),),$H2:$H54). So now I am looking for the code able to swap all this information I Think the file is more than clear.

thanks. see you soon.

 

[Hui]

In X2: =INDEX($I$2:$O$54,MATCH(B2,$H$2:$H$54,0),MATCH($A2,$I$1:$O$1,0))
Copy across and down

 

[vicktor schausberger]

Hello, Hui.

Now I upload the first formula you give it to me, this time with the all results, in this second file I scroll down and do not respond, sorry. can you check for me PLEASE. check the file that say 01aHUI FREQUENCY second I think this illustrated better what I have in mind.

THANKS HUI.

 

[Hui]

I2: =IFERROR(INDEX($P$2:$BB$54,MATCH(B2,$O$2:$O$54,0),ROWS($B$1:$B2)),"-")
Copy across & Down or see attached

 

[vicktor schausberger]

I tried but do not work. I really appreciate your effort, but do you think it is possible a code for this, please.

 

[Hui]

Instead of saying it doesn't work
How about possibly posting a sample of the answer ?
With either a Formula or Code without knowing what pattern you are trying to achieve it is basically guesswork
You have to help us to help you

 

[vicktor schausberger]

sorry I am working in a better example. sorry