formaula

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

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top