Make a Unified Mathematical Script for Excel

Закрито Опубліковано %project.relative_time Оплачується при отриманні
Закрито Оплачується при отриманні

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

Введення даних Обробка даних Excel Математика Статистика

ID Проекту: #19327951

Про проект

5 заявок(-ки) Дистанційний проект Остання активність 4 роки(ів) тому

5 фрілансерів(-и) готові виконати цю роботу у середньому за $185

schoudhary1553

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. Більше

$250 USD за 4 дні(-в)
(326 відгуків(и))
7.9
elqueabandona

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 Більше

$250 USD за 7 дні(-в)
(221 відгуків(и))
6.9
TonmoyRoy111

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

$150 USD за 3 дні(-в)
(311 відгуків(и))
6.7
mowachira77

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 Більше

$55 USD за 3 дні(-в)
(3 відгуків(и))
2.4