basic function

  1. R

    Using mid Left right

    How will I extract the domain name(like gmail) from the email address which contains several dot. For example: I do want to extract "gmail". how can I do that? Is there any easy way please? ?
  2. S

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

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

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

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

    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!

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...