Good Afternoon,
I have a spreadsheet that tracks percentage reductions in prices.
The first page that has all the reductions, showing the original price and the new price, then a formula such as =C2/B2 to work out the difference as a percentage.
On the second page is every member of staff and how many reductions they have created, but I want a new formula that looks up all of the reductions they have made, and then returns a value showing all of the ones they have done that are 10% or greater
I have tried VLOOKUPS and COUNTIFS but I dont think I am using the right arguments in the formulas, any help would be greatly appreciated
I have a spreadsheet that tracks percentage reductions in prices.
The first page that has all the reductions, showing the original price and the new price, then a formula such as =C2/B2 to work out the difference as a percentage.
On the second page is every member of staff and how many reductions they have created, but I want a new formula that looks up all of the reductions they have made, and then returns a value showing all of the ones they have done that are 10% or greater
I have tried VLOOKUPS and COUNTIFS but I dont think I am using the right arguments in the formulas, any help would be greatly appreciated