# basic function

1. ### Function to count values in one column if another column contains text in a single cell

Hi all, Not sure if the title makes any sense, but I have a spreadsheet of names in Column B, with those names showing up in Columns D, F, and H. Column D is 3 points, Column F is 2 points, and Column H is 1 point. So if someone's name shows up 3 times in each of Columns D, F, and H, they should...
2. ### Excel vlookup problems

Dear all, I am relatively new to Excel and have little experience with functions, especially across different excel files. I currently have two excel-files, where one looks like this (file 1): And the other one looks like this (file 2): Currently, what I would like is for file 1 to...
3. ### Using mid Left right

How will I extract the domain name(like gmail) from the email address which contains several dot. For example: shanti.du.bd@gmail.com. I do want to extract "gmail". how can I do that? Is there any easy way please? ?
4. ### Problem using countif and offset when data is contained on two rows (see example)

This is a simplified representation of the problem: How do I write a formula that will count the number of green apples from a dataset like the one below where the odd number rows have fruit type and the even number row right below it has the corresponding fruit colour? A 1 Apple 2...
5. ### Need Help with Creating an If-Then Statement

I just started learning the ropes to VBA and don't fully understand it yet. I am trying to create something that will change the value of two different cells, based on the contents of one cell. Specifically, if the text in column B says "shoecare", then the contents in column E need to change...
6. ### How to identify the order of repeating data in a list

Hi, This is a very basic question, I have a list of data in a column, with data that repeats iteself. What I am looking is a formula to identify which is 1st/ 2nd etc for the repeating data. So Im after a way of recreating the second column below. I know its basic but any help would be much...
7. ### REALLY SIMPLY question

I have this monster string of code that I need to shorten because the code is just to big. There are a few Values that I want to return the same information. However I dont know how to make the different values = same result without the long code. Is there an "or" command that would allow...
8. ### If then statement

I have a If functionI am trying to write that has to conditions and I do not know how to write it. Example: If A2 = "termination" and D2 <> "" , "True", "False" IF(logical_test, [value_if_true], [value_if_false]) I can not figuer out how to have two logical tests. Please help! Thanks!

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back