Hello,
Facts:
1. Sheet contain 20 columns and 600 rows of data.
2. Data is changed dynamically every 1 min using a third party CSV.
3. For illustration purposes only, attached a screenshot of a mini-table so I could explain what needed based on that idea (I hope I attached the image correctly) :
https://ibb.co/ktt2Gz
So basically I would need a msg box made of the next fields: Name Old New Change ... BUT I need that as a sorted list of only part of the rows based on the next requirements:
1. The list going to be sorted based on the highest value of the "Change" field.
2. "Change" needs to be above a given percentage.
3. "New" needs to be above a given value.
4. "Old" needs to be a above a given value to prevent a DIV error (red in the attached) and too high results (in yellow)
Example:
#2 Change needs to be >=10%
#3 New needs to be >= 20
#4 Old needs to be >= 5
Msg box will show the next list:
DDD 11 (old) 14 (new) 27.3% (Change)
GGG 188 (old) 233 (new) 23.9% (change)
HHH 467 (old) 532 (new) 13.9% (change)
III 1800 (old) 2011 (new) 11.7% (change)
Notice: This UDF (user defined function) will need to take the entire data to be tested every 1 minute so the msg box might need to be scrolled down as there're 600 rows.
Please help me, let me know if need some clarification.
Thanks
Facts:
1. Sheet contain 20 columns and 600 rows of data.
2. Data is changed dynamically every 1 min using a third party CSV.
3. For illustration purposes only, attached a screenshot of a mini-table so I could explain what needed based on that idea (I hope I attached the image correctly) :
So basically I would need a msg box made of the next fields: Name Old New Change ... BUT I need that as a sorted list of only part of the rows based on the next requirements:
1. The list going to be sorted based on the highest value of the "Change" field.
2. "Change" needs to be above a given percentage.
3. "New" needs to be above a given value.
4. "Old" needs to be a above a given value to prevent a DIV error (red in the attached) and too high results (in yellow)
Example:
#2 Change needs to be >=10%
#3 New needs to be >= 20
#4 Old needs to be >= 5
Msg box will show the next list:
DDD 11 (old) 14 (new) 27.3% (Change)
GGG 188 (old) 233 (new) 23.9% (change)
HHH 467 (old) 532 (new) 13.9% (change)
III 1800 (old) 2011 (new) 11.7% (change)
Notice: This UDF (user defined function) will need to take the entire data to be tested every 1 minute so the msg box might need to be scrolled down as there're 600 rows.
Please help me, let me know if need some clarification.
Thanks
