+ Reply to Thread
Results 1 to 2 of 2

Enter =cell addresses (not cell values) from noncontiguous cells into contiguous cells

  1. #1
    Registered User
    Join Date
    11-15-2022
    Location
    Left Coast
    MS-Off Ver
    16.66.1
    Posts
    1

    Enter =cell addresses (not cell values) from noncontiguous cells into contiguous cells

    Noob here. I tried looking everywhere but I apparently don't know how to use the correct words to find what seems like should be a simple solution...

    Column A is for Day labels of consecutive weekends (Saturday and Sunday) for 4 consecutive weekends.
    Column B is related data for each day.
    Column C has one cell for each weekend that sums the data for each weekend. Each cell in this column is separated by a blank cell so they are noncontiguous.
    I need a quick/simple way to enter the formula "=cell address" of each non-empty cell in column C into continuous cells in Column D. In other words, I need the contiguous cells in Column D to reference cells in Column C and not just show the calculated results of the cells in Column C. My real worksheet has thousands of rows of data so manually entering "=cell address" from every other cell in Column C into every contiguous cell in Column D is prohibitive. Also I need to be able to copy the worksheet and replace the column B data with other data and have the results in column D recalc.

    My sample worksheet is attached. I hope I explained myself adequately. Thanks in advance for any help offered.Excel Sample 1.xlsx

  2. #2
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,419

    Re: Enter =cell addresses (not cell values) from noncontiguous cells into contiguous cells

    Please try =FILTER(C2:C9,LEN(C2:C9))
    Attached Files Attached Files

+ 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. [SOLVED] Get cell address for non-contiguous cells?
    By aquixano in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-04-2018, 01:11 PM
  2. Match cell value then copy non contiguous cells from one worksheet to another.
    By MagicMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2017, 01:18 PM
  3. Replies: 5
    Last Post: 06-18-2014, 02:25 PM
  4. Add contiguous cells, and put result in the top cell
    By paladin7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-13-2014, 10:20 AM
  5. [SOLVED] How can i match values from 4 cells then enter value from a 5th cell?
    By mikey42979 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-23-2013, 10:17 AM
  6. Replies: 3
    Last Post: 06-09-2011, 11:07 AM
  7. Automatically enter cell value based on the values of two other cells
    By vamedic11 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-09-2010, 11:21 PM

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