I Have a 3 Excel file with 16 columns (A to P) and about 850 rows
Column A is date
Columns B to P are 14 numbers (Randomly from 1 to 25)
WHAT IS NEEDED:
I need a Dynamic Excel file that allows me the following:
- Add future records in the same format in the future (More Rows, same columns)
And Calculate the following:
A- Top 10 Most repeated numbers of all rows / columns including the date that they appeared
B- Max separation between numbers of each ROW:
Each row will have 14 numbers, i need the biggest separation between numbers on each row, for example if we have 3 , 6 the separation number would be 2.
1 , 3 = separation 1
With that information on each row, i also need top 3(most repeated) SEPARATION numbers according to the results of all ROWS.
C- SUM of all numbers of each ROW:
I need the SUM of all numbers in each ROW.
With that information i need the top 3 ranges between numbers
1 - 2 - 3 - 6 - 9 - 11 - 12 - 13 - 14 - 17 - 18 - 19 - 24 - 25 = 174
59% have values between 174 and 192
80% have values between 193 and 200 etc..
D- Pair and Impair numbers:
Since we only have numbers between 1 to 25 and only 14 digits
We have 12 pair numbers (2 - 4 - 6 - 8 - 10 - 12 - 14 - 16 - 18 - 20 - 22 - 24)
13 impair numbers (1 - 3 - 5 - 7 - 9 - 11 - 13 - 15 - 17 - 19 - 21 - 23 - 25)
I need to know the "top 3" % of which we see pair and impair numbers.
For example 40% of the 14 digits of each ROW have 6 pair numbers and 8 impair numbers.
E- Prime Numbers
Since we have 14 numbers from 1 to 25 in each ROW i need:
Top 3 Quantity of prime numbers on EACH ROW
F- Numbers with one digit and two digits
I need the top 3 '%' of one digit and two digit numbers that appear on each ROW.
68% have 4 one digit numbers repeteated
79% have two digit numbers repeated
G- PREVIOUS ROW COMPARISSION
Compare all rows with their previous to see how many digits repeat and show the TOP 3 digits repeat quantity
for example 87% repeat 5 numbers from previous row
50% repeat 2 numbers from previous row
40% repeat 4 numbers from previous row
I am sending a sample file for conversion
whoever will complete this sample file and send it to me
I will award the project to him/her with 100$ as advance
35 freelancers are bidding on average $395 for this job
Hello, One of my customers have named me Excel Guru. That I am not but I know very much about Excel and VBA. Please check my reviews, profile and portfolio and award me with trust. With regards, Tom
Hello I'd be happy to help you on this project, please check some of my previous VBA projects below: http://www.mediafire.com/download/sjbh4d8calsess0/VBA_2.zip Pedrumj
Hi, I'm Expert in Excel (+8 years exp), and I can do it, of course... But, I know how do all it WITHOUT VBA, just using formulas/functions, please, let me show you.
Hi, I have a degree in business and I work with excel every day, I love to create formulas and interpreting the results. Send me an attachment and I'll send you a sample. Best regards.
Please send through the sample file and I'll show you what I can do. From your description the task is well within my capability. Let me know if you're interested.