Make a Unified Mathematical Script for Excel

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.


***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

Compétences : Saisie de Données, Traitement de Données, Excel, Mathématiques, Statistiques

en voir plus : convert excel stand alone software, start vba script excel, run vba script excel, how to write script in excel 2016, excel vba, excel formulas, microsoft mathematics add-in office 365, excel scripting python, create scripts in excel, scripting in excel 2016, excel scripting tutorial, excel stand alone application, import script excel, excel stand alone program, form submission script excel, macro script excel, excel stand alone, webdesign download script excel, php script excel input, mathematical symbol excel

Concernant l'employeur :
( 1 commentaire ) Abu Dhabi, India

Nº du projet : #19327951

5 freelance font une offre moyenne de $185 pour ce travail


Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(326 Commentaires)

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the pro Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(221 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(311 Commentaires)

Hi, How are you today? I have just read your job description carefully and I am very interesting in your job. I am a senior Excel,VBA,C,C++ ,C# developer with 10 years experiences and I have developed many program of Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(15 Commentaires)

Hi. I have read through your project requirements and I understand precisely what is required. I have completed similar work in the past of combined excel and statistics. I am available to start this work right no Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(3 Commentaires)