I have a table with country performance data & I would like to be able to see the best performing country on a certain date. The idea is that if I change the date in cell E10 (highlighted in red), the formula in E11 would display the country name of the highest value on that date.
In the event...
Hello,
I am trying a do cell replacement exercise and have found it a bit challenging. Below is my data and expected results:
Current Data:
<tbody>
Policy No
Name_Address
Agent
Code
Date
Premium
23456
James Price
T83P
2XP
23/05/2013
£35.00
Line1
Line2
Line3
PO1 2TN...
Ok, need some help in the formula line of the code below I need it to use the stored value instead of a set cell reference but I can't figure out the syntax.
Sub test()
Dim c As Range
Dim R1 As Integer
Dim R2 As Integer
R1 = 2
Dim fillto As String
Dim newa As String
For Each c In...
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.