Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have two columns in excel showing our company's pricing and our customer's pricing. Both columns should read the same but i want to add a formula that will show any differences. any ideas? thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
With the two pricings in columns A and B, in C1 enter =ABS(A1-B1) and drag
it down to the end of the lists. Regards, Alan. "cward1" wrote in message ... Hi, I have two columns in excel showing our company's pricing and our customer's pricing. Both columns should read the same but i want to add a formula that will show any differences. any ideas? thanks in advance. -- cward1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
Help needed! | Excel Worksheet Functions | |||
Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
Needed: worksheet export help | Excel Discussion (Misc queries) | |||
IF / Else Format help needed | Excel Worksheet Functions |