Get last 5 values in a row with multiple columns?

Jagoo Girish @Jagoo_Girish

12 December 2018 1 6K Report

Hello Folks,

Suppose I have an excel of 3 rows, however it has 100 columns.

I need to pull out the last 5 values in the rows.

A1 = 100

B1 = 99

....

CV1 = 1

I need to be able to pull 1 2 3 4 5.

Can someone please help with the formula?

Badges
Science topic

More Jagoo Girish's questions See All

Suppose X has a Poisson Distribution with parameter U. Given any integer r>= 1. Show that E[x(x-1)(x-2)...(x-r+1)]=U^r ?

And Also deduce the coefficient of skewness of X. The coefficient of skewness of random variable Y with mean U and variance >0, is E((Y-U)^3)/sigma^3

08 September 2016 7,670 0 View

Why do students (at Primary Level) hate Mathematics?

How can it be changed?

06 July 2016 251 5 View

How do I find the regression coefficients (multiple) for quadratic polynomial equation using a genetic algorithm?

Implementing in Scilab.

01 February 2016 9,252 0 View

Can someone help on this one? I keep getting errors in my codings. It is in scilab. The file is attached below.

function f=script(x) f= 60 + sum((x.^2)-10*cos(2*%pi.*x));endfunctionclearlines(0) objective='script' // the objective function filewmax=0.9; // initial inertiawmin=0.4; // final inertiaitmax=200;...

31 December 2015 859 2 View

Can someone guide me converting a matlab file to a SCILAB file.?

Matlab to Scilab codings.

10 November 2015 1,688 5 View

How can I prove d is a metric on X?

Well I managed to prove the symmetry. d(x,y) = sqrt ( (x1 - y1)^2 + (x2-y2)^2 ) for all x,y in R^2 x= (x1,y1) y=(x2,y2)

02 March 2014 8,273 3 View

Des Chiffres et des lettres.How can we write this program in Python?

Python

07 August 2013 6,609 7 View

How to compare two groups with only two measurements?

Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...

03 March 2021 8,796 3 View

Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence?

I am on the lookout for the Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence. Does anyone know where I can find it? Thank you in advance

03 March 2021 3,568 1 View

What kind of fluid could I use for a pitfall trap that also does not invalidate molecular testing?

Hi, I want to start testing pitfall trap to obtain ants samples, but I need to conduct molecular analysis on those insects. So, what kind of fluid can I use? Ethanol expires too early and I need...

03 March 2021 5,978 5 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

Do we need to write protocol for a second study of a systematic review that has been registered and published?

I have conducted and published a systematic review and meta-analysis research with the topic related to public health and health pomotion (protocol was registed in PROSPERO). Now we want to...

03 March 2021 8,920 3 View

How to increase a model accuracy ?

dear community, my model is based feature extraction from non stationary signals using discrete Wavelet Transform and then using statistical features then machine learning classifiers in order to...

03 March 2021 6,994 5 View

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature)?

1. What is the impact of having different scales in a survey? and how can we solve this problem before and after data collection (Literature-based reflection)? Thank you for your time and for...

03 March 2021 2,870 3 View

What degree of missing data in a particular case/participant results in Expectation-Maximisation no longer working?

I'm dealing with a mediation model and am using the PROCESS module in SPSS. Due to SPSS and PROCESS being limited in the imputation methods - being unable to handle multiple imputation - the other...

02 March 2021 4,362 1 View

Do I need to do linear regression before running mediation analysis using PROCESS MACRO by Hayes ?

I just wanted to check if I need to run a linear regression separately if I am using PROCESS MACRO to run mediation analysis. Thank you.

02 March 2021 4,359 3 View

Sample dilution for quantitative analysis using ELISA?

If the detection range is in ng/ml but the reference range is in ug/ml for a molecule or protein in serum or plasma .how to dilute and what is the initial volume to be taken for quantitative analysis

02 March 2021 7,670 3 View