basic function

Hi . I have managed to put in a vba code for my task , learning from here and there. what it does is. 1.when I click on a cell on a sheet 1 it copies the whole cell row on sheet 2. 2. It renames sheet 2 dynamically with info ( copied row from sheet 1 and used row on sheet 2 ) which is very...

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...

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...

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? ?

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...

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...

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...

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...

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!