Results 1 to 10 of 10

formula for find missing numbers from column A

Threaded View

  1. 05-23-2019, 01:53 PM #1
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    formula for find missing numbers from column A

    Hi Experts,
    I have file with numbers in Column A, I want formula in column B which numbers missing in column A they will show in column B, I think if you see screenshot you will understand what I trying to say.

    Thanks in Advance.
    G
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by AaruJaan; 05-23-2019 at 03:33 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to look at a range of cells, match dates within the range and pull data.
    By mark.k.conroy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-04-2019, 10:20 AM
  2. [SOLVED] SUMIF formula with dynamic column range and then expand the width of SUM range
    By gravythief in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2017, 08:36 AM
  3. [SOLVED] Make data range in formula shift for a whole range when copying cell
    By Zaron in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-21-2016, 06:37 AM
  4. Function/Formula to extra rows from one range based on a date period to another range?
    By Norcal1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-24-2015, 03:00 AM
  5. Constant a range in find formula in a cell even after insert a row between desired range
    By vinothmcc in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-02-2015, 11:18 AM
  6. formula to return blank value if cell va;ie not in range but vlookup if in range of cells
    By david1987 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-04-2013, 07:23 AM
  7. [SOLVED] formula to sort a range so that it matches the exact rows of a column that is outside that range?
    By steveo in forum Excel General
    Replies: 1
    Last Post: 06-17-2006, 09:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1