In the attached excel files, I need a fixed unified singular mathematical approach to apply in excel to select the numbers shown in the grey.
The idea if u opened the excel files with the name (X)....i want a way or formula to select the grey colored numbers in column A to E....the corresponding stats of these are in the respective columns G to K and M to Q
You'll have 38 unique 5-number codes row-wise; please note that the grey numbers are 5 unique numbers no matter how many times they make be repeated across the codes.
The unified way or mathematical formula to be found shall be used in a unified way across similar 88 excel sheets....of course dont forget I'm talking about only the excel file with (X) in its name.
so the idea is how to select these grey colored numbers using their stats....NOT BASED ON THEIR COLOR ALONE
Thats the idea...ull have to see across all files how these numbers were selected to be grey in the first place using a MATH approach
Using the formula or way you'll come up with, I'll be able to apply it to a situation where I don't know which grey numbers are to be selected....thats the ULTIMATE GOAL
Finding how and why these numbers were selected to be grey, (ONLY FIVE NUMBERS) they can be repeated many times throughout the number pool but in total 5 unique number.
FIND HOW AND WHY THEY WERE SELECTED TO BE GREY using their STATISTICS.....MATH EXCEL APPROACH
***I attached a the first 9 excel sheets. You'll be first tested to see if you're able to do that and later on if successful, you can start with other sheets
Bu iş için 5 freelancer ortalamada $185 teklif veriyor
Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy