Identifying blank cells in table

  • I have a spreadsheet that has mulitple rows and columns. Column A has a unique identifier. Many of the rows have blank cells in columns from B to CA.


    I'm looking to write a function goes through each column, identifies the blanks, nad pastes them in another table.


    Ultimately, what I want as an output is a table that shows for each unique identifier, the columns that a blank:


    [TABLE="width: 500"]

    [tr]


    [td]

    ID

    [/td]


    [td]

    Column Name

    [/td]


    [/tr]


    [tr]


    [td]

    A

    [/td]


    [td]

    column A header

    [/td]


    [/tr]


    [tr]


    [td]

    A

    [/td]


    [td]

    column E header

    [/td]


    [/tr]


    [tr]


    [td]

    B

    [/td]


    [td]

    column F header

    [/td]


    [/tr]


    [tr]


    [td]

    B

    [/td]


    [td]

    column J header

    [/td]


    [/tr]


    [tr]


    [td]

    B

    [/td]


    [td]

    column K header

    [/td]


    [/tr]


    [tr]


    [td]

    B

    [/td]


    [td]

    column M header

    [/td]


    [/tr]


    [/TABLE]


    Anyone got any suggestions?


    Hope this makes sense!

  • Re: Identifying blank cells in table


    Hello,


    Regarding your objective, my assumption is that you need a macro ...rather than a function ... :wink:


    For a tailor-made solution ... why don't you attach a sample workbook with your next message ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!