Seperating Rows By Price Difference
 

Ok, so I have an excel inventory sheet with seperate rows for seperate
products in my inventory and different columns with information like
retail price, MSRP price, title.....ect, my problem is they are all
mixed up and to be able to more easily figure out what I need to sell I
need to find a way to either re-order my list by the difference of the
Retail price column and the MSRP Price column, or show all products
above a certain difference in figures and hide all the
rest.....whichever is easiest if you can help me that'd be great Im not
sure if i explained this so its easily understandable but if you have
any questions please let me know because I need to figure something out
for this as soon as possible

Thanks Alot!
-Alix


--
mxalix257
------------------------------------------------------------------------
mxalix257's Profile: http://www.excelforum.com/member.php...o&userid=35478
View this thread: http://www.excelforum.com/showthread...hreadid=552537

Seperating Rows By Price Difference
 

You could create another column (call it 'markup' or 'price difference' or
whatever.)
then put a formula like =B2-A2 (in this example B2 is the cell where your
retail price is and A2 is your MSRP) Then copy that formula down. It would
give you the difference between the MSRP and the retail price. You could
then sort the sheet by that column to get the data from highest difference to
lowest, is that the type of thing you are looking for?

"mxalix257" wrote:


Ok, so I have an excel inventory sheet with seperate rows for seperate
products in my inventory and different columns with information like
retail price, MSRP price, title.....ect, my problem is they are all
mixed up and to be able to more easily figure out what I need to sell I
need to find a way to either re-order my list by the difference of the
Retail price column and the MSRP Price column, or show all products
above a certain difference in figures and hide all the
rest.....whichever is easiest if you can help me that'd be great Im not
sure if i explained this so its easily understandable but if you have
any questions please let me know because I need to figure something out
for this as soon as possible

Thanks Alot!
-Alix


--
mxalix257
------------------------------------------------------------------------
mxalix257's Profile: http://www.excelforum.com/member.php...o&userid=35478
View this thread: http://www.excelforum.com/showthread...hreadid=552537