Load part of data to memory, perform some calculations and rank then show alert with message box -vba

[kelly mort]

This is the formula I am using to get data to second sheet.

Sheet2.Range("D7:M" & lr) = "=Sheet1!I7+Sheet1!S7*0.2"

Sheet1

Sheet2

Now what I want to do is to be able to load the portion of data from sheet2 for say category "X" into memory. Now I don't want to interact with the worksheet anymore. So looking at the formula as a guide, I want to perform those calculations in memory. Then I find the totals each row , D:M into N .

All in memory, if only that's possible.

If all the above go well, then what I want next is to be able to rank the total for ID 408 against the items in column N Sheet2 then display outcome with message box.

I wish and hope some can pull it up for me.

Thanks

 

[DanteAmor]

I'm glad to help you. I appreciate your kind comments.

 

[kelly mort]

Hi again and again @DanteAmor,

I said I was going to take a break but could not take it yet.

I want to find the average of all the non zero processed data as explained below :

So from the first column of the data stored to the 10th column, we find the average of all of them. This time, no categories involved. So say our rows are 500, then we find the average of all the 500 by 10 data range (that are greater than zero) and place the result in TextBox1


Then we also find the average for the column 11, the non zero data and place result in TextBox2

 

[Schoen]

I also had this problem,
Thanks for sharing
--------------------
apkafe!

 

[kelly mort]

Hi again and again @DanteAmor,

I said I was going to take a break but could not take it yet.

I want to find the average of all the non zero processed data as explained below :

So from the first column of the data stored to the 10th column, we find the average of all of them. This time, no categories involved. So say our rows are 500, then we find the average of all the 500 by 10 data range (that are greater than zero) and place the result in TextBox1


Then we also find the average for the column 11, the non zero data and place result in TextBox2

@DanteAmor,

Please is what I am asking for possible?

Please let me know.

Thanks