questions in formula

  1. A

    Formula LOOKUP returns incorrect value

    I have a list of names and want to find each person's designation from a database, but LOOKUP won't give me the correct value :( This is my formula: =LOOKUP(A1646,A3:A3514,I3:I3514) Col A - Name Col I - Designation Please note that the names are not repeated. How could I make it right?
  2. A

    Extract anything that has a ".com"

    I have a list of texts and withing there the users mentions sometimes their email address and sometimes their websites Also sometimes they have more than one email address and more than one urls in the same column The column looks like <tbody>...
  3. K

    Excel Formula

    Dear all, Did any one can teach me how to set this difficult formula in excel cell ? Please refer to the image as below. Thank you.
  4. V

    Top 5 Denomination

    Hi, i have some data where i want top 5 denomination of 1 customer no. there is huge data with customer no. & it's denomination. Data is like below. Customer no. Denomination <colgroup><col><col></colgroup><tbody> 8130038377 130 8130038377 100 8130038377 100 8130038380 60...
  5. caritx

    Formula Question

    I have the following data in Columns A and B and I want C to be my formula. Column A------- Column B 4152 -------------Y (blank) ------------N 1524 --------------N (blank)-------------...
  6. M

    Asking a ? in a formula

    I have a worksheet for my wife that she needs to fill out weekly for work. It contains 3 cells that I want to automate. My problem is that some of the date required changes at times. I will explain. One cell needs this.. (Daily Goal Quota) = "Remaining monthly goal ÷ # of days left in the...

Some videos you may like

This Week's Hot Topics

  • Problem in vba vlookup
    Dear All Master, The problem I mean is as follows : 1. I want to modify the vba code because it takes too long/very slow to vlookup in VBA code...
  • VBA Vlookup
    Please for help. Why it`s not works? [CODE=vba]Sub Check_equpment1_click() Worksheets("Production_program").Activate Dim ans1 As Integer ans1 =...
  • Nesting INDEX MATCH into SUMIFS
    I currently have several formulas pulling in a SUMIFS from a data sheet, beginning with =SUMIFS('datasheet'!$N:$N, 'datasheet..... but as I am...
  • Extracting number from a range randomly
    Hello Expert, please kindly advise what is the best method to extract numbers from a range randomly I have a series of numbers in the range of A1...
  • Problem with If Formula
    I am using the following formula in cell A5. I would like if N5 is blank then A5 also return blank. If N5 is 0 or is greater than zero then equals...
  • Is there a way to make the day's name show up automatically in a header?
    I have a form I print out every day..and in the top right custom header I have the &[DATE], which automatically gives the current date in top...