junaid44
06-26-2014, 01:57 AM
Dear all,
I am writing to request a macro/function/formula, which can find duplicate names and match them up, between both sheets and run logic calculations, as explained below:
The aim of the macro is to find the same name and date from (sheet2) and match it to the , same name and date in sheet1, and execute the calculation logic below:
outlier calculation logic:
if name's prices (sheet1 - column G) fall under the high & low Range (from sheet2 - range 1), then leave blank, else if they do not, highlight the prices in sheet1, in red.
if name's prices (sheet1 - column G) fall under the high & low Range (from sheet2 - range 2), then leave blank, else if they do not, highlight the prices in sheet1, in yellow.
Also, if any outliers found extract them in to the sheet2, under the heading outliers. please note, outliers can be more than
Please see the attachment below, for further details:
11873
the example can be seen in the sheet1, which is the desired output.
Thank you for your time and help.
I am writing to request a macro/function/formula, which can find duplicate names and match them up, between both sheets and run logic calculations, as explained below:
The aim of the macro is to find the same name and date from (sheet2) and match it to the , same name and date in sheet1, and execute the calculation logic below:
outlier calculation logic:
if name's prices (sheet1 - column G) fall under the high & low Range (from sheet2 - range 1), then leave blank, else if they do not, highlight the prices in sheet1, in red.
if name's prices (sheet1 - column G) fall under the high & low Range (from sheet2 - range 2), then leave blank, else if they do not, highlight the prices in sheet1, in yellow.
Also, if any outliers found extract them in to the sheet2, under the heading outliers. please note, outliers can be more than
Please see the attachment below, for further details:
11873
the example can be seen in the sheet1, which is the desired output.
Thank you for your time and help.