- 144
- 1 307 852
BiotechLucas
Finland
Registrace 12. 11. 2019
How To Use VLOOKUP In Google Sheets
VLOOKUP is extremely useful, as it allows us to find a value in one column, and return the value on that row in the same or different column.
To use it simply write equals VLOOKUP and specify the:
1. ”Search Value”,
2. “Search Area” and
3. “Return Column Number”
OBS! In most cases, write FALSE or 0 as the 4th argument!
So in this example, we can see that the search value is the car brand “Kia” and the “search area” or range is A2:C6. Since I’m interested in the colour, the “Return Column Number” or index is 2, since we wish to return the second column.
And as we can see, this returns the value “blue”. However, if we are interested in the colour of a different car, we can simply change the search value. On the other hand, if we are interested in the price instead of the colour, we simply change the index from 2 to 3.
One of the biggest drawbacks with VLOOKUP is that it only allows us to return values to the right of the found value, meaning that if you want to return a value located to the left of what you are searching for, you’ll have to use a different function such as XLOOKUP instead.
To use it simply write equals VLOOKUP and specify the:
1. ”Search Value”,
2. “Search Area” and
3. “Return Column Number”
OBS! In most cases, write FALSE or 0 as the 4th argument!
So in this example, we can see that the search value is the car brand “Kia” and the “search area” or range is A2:C6. Since I’m interested in the colour, the “Return Column Number” or index is 2, since we wish to return the second column.
And as we can see, this returns the value “blue”. However, if we are interested in the colour of a different car, we can simply change the search value. On the other hand, if we are interested in the price instead of the colour, we simply change the index from 2 to 3.
One of the biggest drawbacks with VLOOKUP is that it only allows us to return values to the right of the found value, meaning that if you want to return a value located to the left of what you are searching for, you’ll have to use a different function such as XLOOKUP instead.
zhlédnutí: 19
Video
Add or Subtract Dates in Google Sheets
zhlédnutí 47Před 13 hodinami
If you want to subtract one date from another in Google Sheets, simply make sure that both dates are actually in the date format by clicking “Format”, “Number” and “Custom date and time”. Then choose the date format you prefer. Then dates can be subtracted from each other without any problem. This can be used to create a count down timer by using the function =TODAY() and subtract this date fro...
How to Add a Pop-Up Calendar Date Picker in Google Sheets
zhlédnutí 56Před 13 hodinami
To add an easy-to-use pop-up calendar date picker in Google Sheets, simply choose the cell or cells where you want to be able to add dates. Then click “Insert”, “Dropdown”, and choose “Is valid date”. Then make sure that “If the data is invalid”, “Reject the input” is chosen. This will avoid any addition of invalid information into these cells by mistake. After this, simply double click the sel...
Interactive Tasklist in Google Sheets
zhlédnutí 188Před 21 dnem
Function: {"charttype","bar";"max",1;"color1","green"} If you want to easily create an interactive task list like this one in Google Sheets, simply follow the next 5 steps: 1. Step 1: Write out the tasks you want to add to your list. 2. Step 2: Select the cells to the right of your task and click “Insert”, followed by “Checkbox”. 3. Step 3: Measure progress by using the formula COUNTIF(”Checkbo...
Change Text Into UPPER/LOWER/PROPER CASE in Google Sheets
zhlédnutí 50Před 21 dnem
Do you want to quickly convert text to lower case, upper case or proper case in Google Sheets? Then simply use the “lower function”, “upper function” or “proper function”. Just write =lower/upper/proper() and select the range of the data you want to convert. Then if you want to save this data permanently, copy it by pressing ctrl/cmnd c and paste values only by pressing ctrl/cmnd shift v.
FLATTEN Function
zhlédnutí 63Před 28 dny
The FLATTEN function is great when you want to combine multiple lists into one big list. Simply write =FLATTEN() and select the range of all lists that you want to combine. You can also select different ranges by adding a comma between them like so. Then you will end up with one big list containing the individuals of multiple smaller lists!
How to Use Filters to Sort Data in Google Sheets
zhlédnutí 30Před měsícem
Adding filters to a range of data in Google Sheets is extremely easy and I have my trusty Pokémon stats to demonstrate how it works. Simply select the range you want to sort and click the filter icon in the top right corner. This allows us you to sort data in ascending (A-Z) or descending order (Z-A). In a good 90% of cases this will get the job done. However, maybe you want to filter out data ...
Find Matches and Differences the Easy Way in Google Sheets
zhlédnutí 43Před měsícem
Finding matches or differences in Google Sheets can be done by using a combination of CONDITIONAL FORMATTING and the COUNTIF function. Step 1, select the area of interest. Step 2, click “Format”, “Conditional formatting” and “Custom formula is”. Step 3, write =COUNTIF and specify the range of interest as well as the starting cell for criterion within the parenthesis. Then make the formula true ...
How To Highlight Duplicate Data In Google Sheets
zhlédnutí 116Před měsícem
Highlighting cells that contain duplicates, i.e. the exact same information, can be done in 3 steps in Google Sheets: 1. Step 1, select the area where you wish to check for duplicates. 2. Step 2, click “Format”, “Conditional formatting” and “Custom formula is”. 3. Step 3, write =COUNTIF and specify the range of interest as well as the starting cell for criterion within the parenthesis. Then mak...
CONDITIONAL FORMATTING - Step By Step Guide (Google Sheets)
zhlédnutí 70Před měsícem
Conditional Formatting in Google Sheets can be extremely useful as it allows us to highlight cells based on the contents in one particular cell. Let me show you how it works in 4 simple steps: 1. First, select the area you want the conditional formatting to apply to. 2. Second, click “Format” and “Conditional Formatting”. This will open up this window on the right. 3. Third, click the drop-down...
How To Use FILTER Function In Google Sheets
zhlédnutí 119Před měsícem
Here I’ve created a FILTER function in Google Sheets, that allows me to find Pokémon from generation 1 based on their type and stat points. The FILTER function is the main trick I use to do this and here is how it works. The filter function can be used in Google Sheets to select specific data from a range based on one or multiple criteria, chosen by the user. Let’s use it on the Pokémon data to...
VLOOKUP In Google Sheets
zhlédnutí 59Před měsícem
VLOOKUP is a massively powerful function that finds matches and returns information of the row where it has found these matches. It works like so: 1. Step 1, write =VLOOKUP(). 2. Step 2, specify WHAT you want to look for in the 1st column of that range. 3. Step 3, specify the RANGE of interest BUT note that VLOOKUP will only look for values in the first column of this range! 4. Step 4, specify ...
Google Sheets - SUMIF, COUNTIF, AVERAGEIF Functions
zhlédnutí 58Před měsícem
As you might now you can use the SUM, COUNT & AVERAGE functions to find out the sum, size and average of a dataset. You might also know that you can use the IF function to setup a basic IF-THEN statement. But did you know that you can combine these to only add, count or average datapoints in a dataset that fulfil specific criteria? The functions are written as SUMIF, COUNTIF and AVERAGEIF and a...
ANOVA Explained With Example (Analysis of Variance)
zhlédnutí 92Před měsícem
ANOVA tests are used to check if results from experiments are significant or not or in other words, whether the null hypothesis can be rejected or not. ANOVA is an extension of the t-test because instead of checking the significance of results between 2 datasets, it does it between 3 or more datasets. To calculate ANOVA you need 2 things: 1. Sum of Squares Within groups (SSW) and its degree of ...
IF THEN Statements In Google Sheets
zhlédnutí 50Před měsícem
IF functions in Google Spreadsheets can be used to set up a basic “IF-THEN” statement. The function is written as: =IF(logical expression, outcome if true, outcome if false). Here I have used the IF function to test whether or not students pass a test, based on their test scores. If the value in the B column or “test score column” exceeds 50% they pass and otherwise they fail. To setup multiple...
How To Easily Calculate Average In Google Sheets
zhlédnutí 67Před měsícem
How To Easily Calculate Average In Google Sheets
How to Find Dataset Size in Google Sheets (COUNT & COUNTA Functions)
zhlédnutí 33Před měsícem
How to Find Dataset Size in Google Sheets (COUNT & COUNTA Functions)
How To Easily Add In Google Spreadsheets (SUM function)
zhlédnutí 77Před měsícem
How To Easily Add In Google Spreadsheets (SUM function)
How to Calculate Bayes' Theorem (Example Included)
zhlédnutí 332Před 2 měsíci
How to Calculate Bayes' Theorem (Example Included)
How to Identify Type 1 and Type 2 Errors in Statistics
zhlédnutí 91Před 2 měsíci
How to Identify Type 1 and Type 2 Errors in Statistics
How to Calculate Poisson Distribution PMF
zhlédnutí 218Před 2 měsíci
How to Calculate Poisson Distribution PMF
Probability Distributions (PMF, CDF, PDF)
zhlédnutí 128Před 3 měsíci
Probability Distributions (PMF, CDF, PDF)
Uniform Distribution Explained with Examples
zhlédnutí 258Před 3 měsíci
Uniform Distribution Explained with Examples
NORMAL DISTRIBUTION EXPLAINED WITH EXAMPLE
zhlédnutí 197Před 3 měsíci
NORMAL DISTRIBUTION EXPLAINED WITH EXAMPLE
How to Calculate the Coefficient of Variation (CV) - EXAMPLE
zhlédnutí 590Před 3 měsíci
How to Calculate the Coefficient of Variation (CV) - EXAMPLE
How to Calculate the Variance and Standard Deviation (EXAMPLE)
zhlédnutí 529Před 3 měsíci
How to Calculate the Variance and Standard Deviation (EXAMPLE)
Hello this was a great video explaining how MALDI-TOF works! I am currently using the MALDI-TOF on some peptides I'm making and I had a question. The peptides we are making has a +4 net charge but on the maldi we usually see +1 charge mass (m/z) on the spectra and not the +4 charged (m/z) mass. Can you explain this? Thank you!
How does that show up exactly? I mean how do you know that you're seeing +1 charge rather than +4 charge?🤔 I've only analyzed things that had a +1 charge myself I'm afraid🙈😅
The biggest problem with GC-MS is the companies producing them will not compete to drive the price down. We need more research which means lower analytical equipment costs. Everybody who wants to do research can't just happen to get a job with a deep pockets corporation supporting their work. To advance science...lower the tool costs!
I couldn't agree more! However I'm sure some of that cost comes from the fact that these instruments are not exactly cheap to manufacture. But I agree that it would be fantastic if more affordable options would exist!
hello sir, can you make a lpg ionization rod flame sensor without photodiode IR receiver
thank you 🤍😊 I watched it and benefited from you from Palestine 🇵🇸...... I subscribed to you because your explanation is wonderful, simple and beautiful. Thank you again 🤍👑
Can transpoons travel across chromatids, or is it only within the locii?
It seems like they can move between chromosomes as well. You may want to check out this article for more information: 'www.ncbi.nlm.nih.gov/books/NBK557780/#:~:text=Transposition%20can%20take%20place%20from,elements%20independent%20of%20the%20chromosome
Question: what difference is between led ionization and filament tube ionization? ( It can't use the same terminals in a tube noble gas as the terminals of an LED?)
Those two technologies should be combined so you can have a larger area illuminated ( the entire gas tube) with the power consumption of an LED....(efficiency)...the principle of both technologies kinda be the same
Thank u😊
Happy I could help!!😇👍
Why in your videos the antibodies are connected to the antigen in their heavy chain region? The attachment to the antigen happens on the opposite side of the antibody, in its Fab region composed of both the light chain and heavy chain.
My apologies! This was a mistake on my part when making the video series on antibodies. I plan on making a correction series in the near future and then deleting these.
At 1 min make sure when you say making 3 to 5 to specify thats whats being read since the synthesis itself is 5 to 3
Yes that's correct! Sorry if that was unclear!😅🙏
Well donee
Thank you!
Excellent, Short and crisp
Thank you so much!
Great video thanks. One question...if we look at m/z 191 for example, which is triterpanes as far as I remember, we see many peaks from C21 or so up to C37 or so..now, all those peaks from ~C21 to ~C37 are fragments that give off a m/z 191 fragmentation when going through the ionization, am I correct? But the main molecules would have a mass of ~296 (C21) up to 520(C37), also correct?
BE AWARE: IILEGAL HUMAN EXPERIMENTATION AND TORTURE BY CIENCE AND MEDICINE. TARGET INDIVIDUALS ARE TEST SUBJECTS FOR BIOMEDICINE, TECHNOLOGY, AI, ROBOTIC ETC. GANGSTALKING AND MIND CONTROL. See Dr. Robert Duncan Project Soul Catcher / Dr. John Hall, Technologies of Control / MK Ultra (Remote)
those videos about Mass Spectrometry are quite helpful, thank you so much!
Great to hear! Thank you!!🙏
Thank you so much! Simple and clear!
That's great! Happy I could help!😇
Good
Superb ❤ thanks youuu
So happy that I could help!😇
Perfect!
Haha, thank you!😇
Thanks
Happy that I could help!😇🙏
why didn't this channel exist when I was doing my bachelor's 15 years ago!!!! very helpful
That's so nice of you! Thank you!!🙏🙏
you are a God sent in this exam period
That's great to hear! Good luck!!💪
Hello, I'd like to ask you a question. So, does the function of the monochromator consist of separating the wavelength that exits the sample after passing through it from the wavelength that is being generated by the flame? Thanks in advance!
Yes, that is exactly right! Sorry, I didn't really explain that part in the video😅
@@biotechlucas4126 Don't worry, I had my exam today and the video was very useful to clarify concepts. Thank you so much!
@@MarioHB01 That's fantastic to hear! Thanks for sharing!!
1:47 hahhahahah
Have you done any research regarding balance 13;14 autism or future physical elements
No, I'm sorry. I do not have any expertise to offer on that subject.
Kuthollander
Kuthollander
Now I understand ELISA . Thank you.
Great to hear!
Hello. Please how can I explain the rationale behind the buffer gas pressure difference between simulation (0.3 mTorr) and experimental conditions (approximately 5 Torr and 2.8 mTorr) in a linear ion trap
It is also possible to induce apoptosis and perhaps use this method to kill certain cells such as cancer cells.
Great video! 😊
Thank you so much for your kind comment!😇
Thank you so much 🫂🫂🫂
Thank you!♥️
Thanks!
Great to hear that it was helpful!😇
This is confusing
Sorry to hear that. Is there something in particular that I can clarify for you?😇
@@biotechlucas4126how does the chart convert to writing because the chart is what I listened in science class living environment and I don’t remember the circle thing if that made sense thanks for replying imma subscribe
@@swishstudios285 Do you mean how you convert from DNA to an amino acid chain? Well you read the chart from LEFT SIDE - UPPER SIDE - RIGHT SIDE, and the only amino acid that all 3 codons will overlap is your amino acid of interest. Let's say your codon is CUA, then it's the SECOND on the LEFT SIDE, the FIRST COLUMN on the UPPER SIDE and the 3rd LETTER on the second row on the right side. The corresponding amino acid is Leucine which is shortened as Leu. In other words, we simply use the chart to find the correct location of what we are looking for but if you happen to see the codon (3 DNA nucleotides) that you are looking for, you can just check the corresponding amino acid (the one next to the codon) immediately and forget about the "proper way" to find what you are looking for. I hope that is of some help!
which would you choose as the more meaningful measure of average of set of values?
Depends on the dataset👍 There's a reason why averages are used all the time but when you have data that skews in either direction because of a few extreme numbers, median might be more informative😇👍
I love you! TT
Thank you! Happy I could help!
Hello, so if I understand, we want to know how many cold antigen are on the solution based on their capacity to replace to hot antigen (which is radioactive), so the radioactivity will decrease if we have a lot and steady if we dont have cold antigene ?
fuck thanks man rlly appreciate it
Happy I could help!😇👍
Legend, thanks!
Hahah, thank you so much!🙏
Sir what is your view on the NTA scam in NEET 2024 in INDIA because of this scam many students lost their lives (in terms of future)
What's your favourite function in Google Sheets or Excel?
Let me know if you have any questions!
Please do a video on the Hill equation and Hill plot explained.
Excellent suggestion! Thank you!🙏
CO2 has double bonds between C and O
I have been searching 2h for this explanation and you are the only one who helped me understand
That's really great! Thank you for taking the time to comment!
Thank you for making this video😊
How many signals are there for phenol?
There's going to be 4 "unique hydrogen environments", so therefore there's going to be a total of 4 signals.
So cute
Thank you!😄
Suppose I have film of copolymer with some crosslink Can I ise mass spectroscopy to analyse the crosslink Or should I have to do gc then ms
This didn’t explain a thing! Talk to me like I’m three and break every little thing down please for next time!
Sorry to hear that. I try my best to explain things both fast and simply. Sometimes I don't get that balance quite right and lean too much towards explaining it fast. I'll try to be clearer in the future!😇
I have discovered your channel and to studying for the exams is perfect. Short and visual explanations. Thx for your work!!
Thank you for that! I'm happy I can be of service!😇