+ Reply to Thread
Results 1 to 3 of 3

fill blank cells in a column by duplicating values of first unique instance

  1. 12-11-2021, 03:00 AM #1
    hasan mougharbel
    hasan mougharbel is offline
    Forum Contributor
    Join Date
    11-06-2021
    Location
    Tripoli
    MS-Off Ver
    Still using 2007 in 2023
    Posts
    289

    Smile fill blank cells in a column by duplicating values of first unique instance

    Hello guys.. Is there a neat formula where I could fill cells under the first unique number with its duplicates..My attached file makes everything clear..God bless you. and thanks in advance
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-11-2021, 03:32 AM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,207

    Re: fill blank cells in a column by duplicating values of first unique instance

    In B2

    =IF($A2<>"",$A2,B1)
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 12-11-2021, 03:46 AM #3
    hasan mougharbel
    hasan mougharbel is offline
    Forum Contributor
    Join Date
    11-06-2021
    Location
    Tripoli
    MS-Off Ver
    Still using 2007 in 2023
    Posts
    289

    Re: fill blank cells in a column by duplicating values of first unique instance

    thanks john..god bless you
    https://www.ablebits.com/office-addi...-blanks-excel/
    This is another solution that works excellent
    Last edited by hasan mougharbel; 12-11-2021 at 04:03 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Excel formula to fill column B with unique values from column A
    By CV_Sam in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 01-24-2022, 09:29 AM
  2. Sort unique values in column while ignoring empty/blank cells
    By mainemojo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-15-2019, 04:02 PM
  3. VBA for Totals Row Insertion beneath Last Instance of Each Group of Unique Column Values
    By Aimee S. in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 10-23-2014, 07:39 PM
  4. Fill Column B based on non-unique values in Column A
    By viksmehta in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-21-2014, 07:39 AM
  5. [SOLVED] Macro to fill blank cells in column A based on non-blank cells
    By ktalamantez in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2014, 02:47 PM
  6. Need to fill blank cells with values from another sheet that match unique values in rows
    By kawaguy90 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-11-2013, 01:02 PM
  7. How to fill blank cells with different values in a column
    By intermine in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2010, 12:43 AM

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