range between two fields

  1. jrn1392

    Need to return column heading of value in a row

    I have a table of days for various feelings. Ages are going down column A. In row 1, columns B through G are the feelings. For example: <tbody style="box-sizing: inherit; border: 0px; margin: 0px; padding: 0px; vertical-align: top; -webkit-font-smoothing: antialiased; text-size-adjust: none;">...
  2. Y

    Insert rows from a master sheet, in between 2 named ranges using VBA

    Hi, I currently have a template in which i have a lot of pre prepared formula, which extract information from data in order to produce, invoices statements and remittance advice notes. All formula are written to use defined names, I have a range in which i currently insert data manually, and...
  3. F

    Value from Range

    Hi, I want to put different text name for value depend on to which ranges value belong. My ranges: 0 - 15: text name: "AAAA" 6-28: text name: "BBBBB" more than >29 : "CCCCC" I have below code, but I know that my condition are wrong: looking_date = ws.Range("B2").Value if looking_date < 15...
  4. K

    Difficulity identifying the month in a range then proceeding with a calcualtion.

    I am fairly new to excel VBA and I am stuck so far. I am attempting to write some code for use with a userform. The logic I would like to use is as follows: If the calculated number of months = A:A then use the days/hours from Column E, however if any of the months are 6,7,or 8 (June...
  5. B

    Look Up with Multiple Ranges

    Apologies for almost certainly posting a question that has already been answered here, but I have tried a number of the solutions without any luck as I cannot relate the variables to my own, so here goes (note I am running Excel 2010 and I have no idea how to create the table below properly...
  6. B

    Comparing a range of values for best fit with another range of values

    Hi guys, I'm trying to compare a range of daily values with that of the daily values from the previous 5 years. What I have is the daily increase/decrease (in %) of sales of my company. What I want to do, is have excel use this year's daily sales percentage increase/decrease compared to that...
  7. J

    Find Count of Days within another (seperate) Date Range

    Hi, I am assessing the impact of product price increases on volume (qty) and sales (£/$). The prices are changed sporadically and at no set intervals. For example pries were changed on the 15th Jan and 13th Feb this year. We have set reporting dates (calender months) so i am hoping to be...

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
Back
Top