Make a Unified Mathematical Script for Excel

Ukončen Zveřejněno před 4 lety K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

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

Zadávání dat Zpracování dat Excel Matematika Statistika

Identifikační číslo projektu: #19327951

O projektu

5 nabídek Projekt na dálku Aktivní před 4 lety

5 Freelnceři na tento projekt zveřejňují nabídky v průměru $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. Další

$250 USD za 4 dní
(326 Recenzí)
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 Další

$250 USD za 7 dní
(221 Recenzí)
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 za 3 dní
(311 Recenzí)
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 Další

$55 USD za 3 dní
(3 Recenzí)
2.4