Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2015
    Posts
    31

    Unanswered: Searching for missing values

    Hello everyone,

    I have a small problem where i have 2 columns both containing hundreds of order numbers. However, there are supposed to be the same amount and same order numbers in both of these columns. However, there are some orders that are missing from one of the columns so i need to find out which ones are missing.

    So what excel function would i need to use ? 1 column has all of the orders and the other is missing 37, i need to find these 37 orders in the column containing all the orders.

    Thank you all !!

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    VLookup() or CountIfs() would be where I'd start.
    George
    Home | Blog

  3. #3
    Join Date
    Mar 2015
    Posts
    31
    So if i were to give you these numbers for instance how would the Vlookup() function work ?
    A----------------- B
    204925840 204705820
    204891760 204702210
    204896570 204762210
    204962810 204705830
    204925810 204791710
    204684030 204846550
    204705910 204891750
    204896510 204846450
    204891710 204846580
    204880810 204857820
    204857840 204896510
    204906380 204951710
    205075540 204610280
    204896560 204891720
    204937070 204891760
    204955310 204896580
    204891750 204896590
    204940410 204896570
    204925830 204896550
    2049370120 49063100
    204937040 2049063120

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Oct 2014
    Posts
    268
    Provided Answers: 6
    = match(column b row 1, column a the whole set define the array, 0)

    Or you could select columns and then use conditional formatting to select find duplicates then filter by the non red cells (with no fill) and that will show you the missing order numbers.

    Click image for larger version. 

Name:	Capture.PNG 
Views:	1 
Size:	20.8 KB 
ID:	16310
    Last edited by VLOOKUP; 04-22-15 at 12:53.

Posting Permissions

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