excell formuals

  1. K

    Sum a column by the header name

    How can I sum a column header by it's name? The column header will move to different columns from time to time. The formulas I will use is below =MAX(U10:U32) {=MIN(IF($U$10:$U$32>0,$U$10:$U$32))} =MAX(U10:U32) Thanks
  2. P

    Excel array formula help

    Hi, We have a workbook with one sheet for each month, and on each month we have a list of web sites with some data provided by that website. The list of websites is different from month to month, but always between A2:A13. On my summary sheet I need a dynamic list of the available websites...
  3. N

    F1 prediction

    Hi, I would like to run a simple formula one prediction game next year and would like to use the last remaining races to trial what ever I get together. setting the bar low I think, but I just what a top 8 prediction. 8 points for correct position then one point less for out of position, ie...
  4. B

    Help with macro

    Hello All. thanks for reading my problem. I have a workbook with one sheet (called 'data') that is a calender with staff assignments. for example: DAY DATE MONTH DAY CALL NIGHT CALL NOTES tues 1 jan Sam Sue wed 2 jan...
  5. U

    Help with Returning muliple values from a function

    Please help, I need to return multiple values from a function with for inputs: function name(i1,i2,i3,i4) As Variant Dim d(5) Dim other variables function calulation name = Array(d1,d2,d3,d4,d5) end function. This code does not work as I need to horizontaly return each value each column next to...

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