Results 1 to 10 of 10

How to calculate the difference between values with columns of different codes

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2022
    Location
    Maryland, USA
    MS-Off Ver
    Microsoft Office Professional Plus 2019
    Posts
    8

    How to calculate the difference between values with columns of different codes

    Hi,

    I need help to calculate the difference in the price of each procedure code in two tables. Each table is from different organizations (the one on the right is my organization, and the one on the left is the other one), so the procedure codes are not all in the same order, and there are some codes that might be in one that are not in the other. I would just need to calculate the difference in price in the column named Fee and for the procedures that are in both tables.

    The example I added has just one mismatch, but the original has more mismatches between the order of procedure codes due to missing codes, although I tried to sort it the best possible.

    Thanks for any help
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Finding out the difference between two sets of codes -repetitive codes and interchanged
    By chandramouliarun in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-11-2020, 07:05 AM
  2. Trying to Calculate Difference from two columns
    By dcoughl in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-01-2020, 11:37 AM
  3. [SOLVED] Formula to calculate Tax values on net value depending on dealer codes
    By abhinavbinkar in forum Excel General
    Replies: 2
    Last Post: 12-30-2018, 03:09 AM
  4. Replies: 1
    Last Post: 08-14-2014, 10:37 AM
  5. [SOLVED] Pivot table with years on columns. I cant calculate a difference in values
    By Daniel_da6 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 05-17-2013, 12:13 PM
  6. [SOLVED] how to calculate difference in two columns either positive or negative ?
    By spandan21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-29-2012, 10:40 AM
  7. Replies: 1
    Last Post: 02-09-2006, 08:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1