How do I match up excel cells?

More Lino Sanchez's questions See All

How can I improve the concentration of banana fruits extracted RNA?

Currently, I'm working with banana fruits. I've tried to do RNA extractions with different methods, and I've gotten total RNA without contamination, but I couldn't get a high concentration of...

22 February 2021 6,126 2 View

Where can I find a reliable and updated methodology related with the design of spiral heat exchangers?

I need to design an spiral heat exchanger, buy I don't know what reference or bibliography (preferably a book) should I consult in order to get an updated and reliable methodology related with...

14 February 2021 7,910 3 View

Can a mRNA be degraded but still observe a protein over-expression?

Hello there, I'm currently trying to over-express a gene by transfecting the cells with a pcDNA6 plasmid containing my target gene. When I measure the mRNA for my gene of interest, the levels are...

03 February 2021 4,112 4 View

How can I do the bang's blinding index and james blinding index?

Hi! I would like to know with which statistical software the bang blinding index and the James blinding index and how to do it. Thanks

09 December 2020 1,363 2 View

What is the main difference of diluting HCL in methanol as opposed to water?

I am hoping to determine the mass per unit area (as per DIN 50938) of a black oxide coating. I use water to achieve the required 1mol/l hydrochloric acidic solution, but a fellow lab had used...

06 December 2020 4,806 1 View

No title

Greetings to all. I have some questions about setting up DFT calculations in Gaussian software (I am a beginner in these matters), and trying to calculate the energy of the first excited triplet...

06 December 2020 3,504 4 View

What statistical method to use to identify potential confounders in a large set of explanatory variables?

I am working on identifying biomarkers of the outcome of treatment in a disease. I have 20 potential biomarkers and more than 30 potential confounders. Actually, I know that some of those...

11 November 2020 3,794 3 View

"IHC profiler" for ImageJ: Why do same images give you different cytoplasmic results?

In order to analyze immunohistochemistry images, lately I have been using the ImageJ Macro "IHC profiler" developed by Varghese and colleagues and I have a question about the results you get from...

11 October 2020 6,735 1 View

Has anyone thermodynamic and kinetic information about nitric acid synthesis?

I want to elaborate a presentation to my students of Chemical Reaction Engineering where I can illustrate them reactor design with multiple reactions, including reversible exothermic reactions. I...

28 September 2020 6,465 1 View

How to select pixels by color in ImageJ?

I want to use ImageJ for counting my different tephra populations in a thin section sample, but I am not able to separate the lighter populations from the darker ones in ImageJ before counting. I...

28 September 2020 5,471 2 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

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

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

Can NFL theorem be valid in infinite search space in ML?

NFL theorem is valid for algorithms training in fixed training set. However, the general characteristic of algorithms in expanded or open dataset has not been proved yet. Could you show your...

01 March 2021 1,189 3 View

Does anyone know how to plot my station to a section plot on Ocean Data View (ODV)?

I made a vertical section plot with WOA .nc file on ODV, and now I want to plot my stations (csv. file) in it. Does anyone know how to import my points to the section? They are two different...

01 March 2021 3,610 1 View

How to address this issue in the analysis of Real-Time PCR results?

To dear Researchers, I was analyzing a series of concentration for estimation of Real-Time PCR efficiency. The concentration was 1:10. I used MS-excel to evaluate Slope. The result of slope was -8...

01 March 2021 8,683 4 View

How to arrange coordinates and extract climate dataset out of MPI-ESM-MR netcdf files?

Have a nice day everyone, I'm stuck in extracting datasets out of MPI-ESM-MR netcdf files because the latitude ranges from -3*10^6 to 3*10^6 and longitude ranges -5,9*10^6 to 5,9*10^6. Plus, the...

28 February 2021 912 3 View

Is there any Machine Learning/AI algorithm that lets you predict with incomplete features without missing value imputation process?

For instance, the model is trained with A,B,C,D,E features to predict F target. Then, I want to make prediction on a new data, but with only A,C,D,E is known without doing missing value imputation...

28 February 2021 1,556 6 View

Daniel Doss Popular answer

Hi Lino,

You might need to write a macro. Here's a book link that might provide insight:

https://books.google.com/books?id=0GDcCgAAQBAJ&printsec=frontcover&dq=excel+macros&hl=en&sa=X&ved=0ahUKEwibxfPzrK_bAhWR1lMKHQ7UDSMQ6AEIUjAG#v=onepage&q=excel%20macros&f=false

Have a great day!

--Adrian

Daniel Doss

Álvaro Reis Figueira

1) Create the final list by adding a new column to the right

2) Insert in the top cell of the new column the formula:

vlookup(, TopLeft1Column:BottomRight1Column, 2, False)

Example: vlookup(A1, Sheet1!A1:B10, 2, False)

If you want to drag this formula to all rows make sure you use the '$'

vlookup(A1, Sheet1!A$1:B$10, 2, False)

Hope it helps!

Alvaro

Jordan Poley

"concatenate" might be useful?

Lino Sanchez

Hello, thanks everyone for the suggestions! The vlookup(A1, Sheet1!A$1:B$10, 2, False) formula did it!! I have had to use concatenate a lot, but for this specific task I need to have reference a table, I think it is called the array table, but not positive.

For the next task I was hoping to ask about (This research job just keeps demanding more excel acrobatics!), I need to someone find a way to add up all the values for each corresponding group.

As an example this would be:

Population of people for U.S. Counties...

County A, CA - 195

County B, CA - 333

County C, CA - 43

County D, WY - 44

County E, WY - 456

County F, WY - 231

So I want to simply that into

California Counties - 571

Wyoming Counties - 731

I don't know what to call this function, would this also be vlookup?

Thank you! :)

Assuming you have

Counties -> column A

Acronym -> column B

number ->column C

You should use

=SUMIF(B$1:B$10; "CA"; C$1:C$10)

Good luck!

Thank you very much!