Sorting 2 columns and a 10% reduction value to a separate column

**JohnnyBoyxxx** · 03-05-2014, 08:48 AM

Hi, In the attached sample I'm looking for a code that will sort column G with everything greater than 4, column F with everything greater than 400 and then add a value of '-10%' of each cell in column F to all the remaining cells in column Z.

Any help with this would be appreciated.

I've tried to do this using a macro but because the row items vary on a regular basis i cannot get it to work consistently.

Regards
John

**alansidman** · 03-05-2014, 09:02 AM

Try this:

Please Login or Register  to view this content.

**Kaper** · 03-05-2014, 09:09 AM

or if you need rounded prices

Please Login or Register  to view this content.

check what about exactly 4pcs. and exactly 400 price - I used (as opposite to Allan) "more or equal" >=

**JohnnyBoyxxx** · 03-05-2014, 10:03 AM

Many many thx, always get blown away by the superfast help I've got from this forum. I'm using Kaper's answer as the rounded prices was needed although i know i didn't specify that. Thanks Alan for your contribution to my query. Great work guys