Excel PERCENTRANK INC in Javascript

0 votes

Is there a way to get the exact results as in Excel for this function. I am also sharing my Node code to experiment with the function.

const formularjs = require('@formulajs/formulajs');

let array =[71,13,23,32,45,99,103,71,43,11,91,21,45,45,89,66,41,29,66,63];
let compare_array =[11,19,17,31,32,43,71,63,35,13,73,74,81,100,13,41,31,29,31,33];


compare_array.forEach(function(n){

     let pr = formularjs.PERCENTRANKINC(array,n,3);
     console.log(pr); 
 
});

Mar 23 in Database by Edureka
• 9,320 points
18 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
1 answer

Group by Sum in Excel

It is very easy and you can ...READ MORE

answered Feb 21 in Database by Edureka
• 8,820 points
18 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21 in Database by Edureka
• 8,820 points
23 views
0 votes
1 answer

Change default 'delimiters' in excel

Select a non-empty cell. Do Data -> Text ...READ MORE

answered Feb 21 in Database by Edureka
• 8,820 points
30 views
0 votes
1 answer

Convert a number to a letter in C# for use in Microsoft Excel [duplicate]

If you are familiar with using formulas ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
37 views
0 votes
1 answer

Date difference: different results in Excel vs. Python

To calculate the date difference, we can ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
47 views
0 votes
1 answer

How to sort dates from Oldest to Newest in Excel?

Drag down the column to select the ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
34 views
0 votes
1 answer

Deleting duplicate rows in Excel using Epplus

You need to re-think this… the while ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
40 views
0 votes
1 answer

how do I calculate discount with if function in excel?

Suppose a customer gets a 10 percent ...READ MORE

answered Feb 23 in Database by Edureka
• 8,820 points
175 views
0 votes
0 answers

How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

 need the row/column combinations marked with an ...READ MORE

Feb 24 in Database by Edureka
• 9,320 points
30 views
0 votes
0 answers
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP