PDA

View Full Version : Price consistency calculation in Excel



uroy
05-20-2015, 08:34 PM
Hi All,

I am facing problem to customize the price column in attached file. In original input file I have more than 10000 of line items.

Its takes hell lot of time to customize the price column as per the expected result in attached file :banghead:.

First,same security number with the same price amount should be remain unchanged but same security number with the different price needs to be color with light pink. Do not consider the decimal changes. This is very important.

Second, unique security number with the different price amount needs to keep unchanged. This condition only applicable for the security number which has different price amount. Do not consider the decimal changes in price column. Additional note has given in the attached file.

I need a VBA command to customize the price column as requested.

Advance thanks
Uday Roy