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