excell formuals

Hi, Please help! I have a file with multiple sheets. The same products, but from different countries so they have 70% the same names. They all have different prices but in the same currency. I need to be able to have the first row with my name of the product (the one that I set), my price in...

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

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

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

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

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