+ Reply to Thread
Results 1 to 9 of 9

Comparing JSON data in two rows for every set of ID

  1. #1
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Red face Comparing JSON data in two rows for every set of ID

    Hi All,

    Hope you are doing well!..I have a billing file data in which I am trying to compare JSON data for each pair of Billid and Ctextid ..Each pair of Billid and Ctextid have two rows of JSON data..I am trying to check if the two rows of JSON are the same or whether there are any changes made... Can you please help me here!..Please find attached the sample file with input and output data tabs...Can you please help me here... The JSON format for my original file is the same structure but can have more than two number of data points ..The third column info is JSON in my file...


    Thanks,
    Arun
    Attached Files Attached Files

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Comparing JSON data in two rows for every set of ID

    Would you explain why you show C2 as No

    Both A2 & A3 (2132) contain the same value 91156 in B2 & B3
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Comparing JSON data in two rows for every set of ID

    @Richard Buttrey : By No I mean that for the pair of Billid and Ctextid 2132, 91156 the info JSON column(which is the third column in my input sheet) for the two rows has no change (meaning the JSON info column is the same for both the rows)...

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Comparing JSON data in two rows for every set of ID

    ...have you got this the wrong way round.
    C2 does = C3 whereas C4 <> C5, i.e. the results should be Yes & NO respectively?

  5. #5
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Comparing JSON data in two rows for every set of ID

    @Richard Buttrey : Yes you are right!...Sorry about that..

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Comparing JSON data in two rows for every set of ID

    ...in that case try

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Comparing JSON data in two rows for every set of ID

    @ Richard Buttrey : This is giving me a #N/A for the second Billid 5678 and for 2132 it is giving me No

  8. #8
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Comparing JSON data in two rows for every set of ID

    Not in my Workbook.

    See attached. NOt sure how it translates from 365 but if there's a @ before INDEX() functions just remove it. I find it an annoying 'feature' now I'm using 365
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    10-18-2016
    Location
    Chicago, USA
    MS-Off Ver
    Office 365
    Posts
    220

    Re: Comparing JSON data in two rows for every set of ID

    Thanks @ Richard Buttrey: Really appreciate your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Edit JSON parser code to add function to write JSON file
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-16-2020, 09:28 PM
  2. Comparing (2) Rows of Data
    By martybrodeur in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-19-2019, 10:15 AM
  3. comparing rows of data
    By MistaMotor in forum Excel General
    Replies: 3
    Last Post: 03-08-2013, 11:41 PM
  4. JSON URL to xls in rows and columns
    By kvsree in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2013, 12:02 PM
  5. [SOLVED] Pulling json or csv data from a url
    By Versial in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-10-2012, 04:43 AM
  6. Comparing two rows of Data
    By zecro in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-17-2008, 07:20 PM
  7. Comparing rows of data
    By Stewpot in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2008, 08:59 AM

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