1. C

    Formula Help

    I am trying to come up with a formula to count how many robot batteries are needed. Below you will see the formula that I am using to input the type of robot battery for that type of robot and multiply the quantity of robots in that column by 4 to come out with how many I need (each robot takes...
  2. P

    VBA Index/Match in a Loop

    HI all, am new to VBA excel. some i am trying to use the macro for index match but some am not able to get the that . am using the below formaula . ={INDEX(Sheet2!P:P,MATCH(Sheet1!A2&Sheet1!$O$1,Sheet2!A:A&Sheet2!E:E,0))} Note: Sheet1!$O$1 is constant criteria Please help me with this
  3. M

    Formaula to return last entry in Col. to Total Line

    Does Anyone know how to write a formaula that will return the last entry in a Col. to the Total line in a table sort??? :confused::(:warning:
  4. R

    Finding a value if the user defines its location

    Hey all, I have a column of numbers in Column J. I also have a cell which I input a number in. I want a formula that then goes to get the number from the row in Column J specified. eg. If I input 10 into the cell, I want the value in J10 to be displayed. Any help would be greatly appreciated...
  5. L

    formulas for date and times

    Please can someone help...... I would like to add a formula that can tell me the difference in days and time from two cells. An example of the two rows of cells are below <TABLE style="WIDTH: 186pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=248 border=0><COLGROUP><COL...

Some videos you may like

This Week's Hot Topics