Filter rows

[rwilli10]

Hello everyone,

Is there a way to assign numbers from one cell into another cell? Example, if I place 1-10 in once cell but will like to filter the data from it into columns B-G using the letter X to signify whichever number in the column how would that work? I'm sorry not very tech savvy. Coming from Academic Advising and I need a system to filter students who are staying within sequence versus those who aren't.

If this isn't the best way please feel free to share a much easier method. I will also like to name the Areas if possible. Not sure if I can change from H-.... to reflect the name of the Area ex. Communications, Humanities, etc...

[#2 · Accepted solution]

@rwilli10 Can you show is a bit more of what your (anonymized) source data looks like? And explain more about what your goal is precisely?

[#3]

@rwilli10 

If I understand your dataset and the goal correctly, perhaps with MAKEARRAY:

=LET(
    height, ROWS(missing),
    width, 20,
    CheckForMissing, LAMBDA(r, c,
        LET(
            MissingAreas, INDEX(missing, r),
            Check, XMATCH("*" & c & "*", MissingAreas, 2),
            IF(ISNUMBER(Check), "x", "")
        )
    ),
    MAKEARRAY(height, width, CheckForMissing)
)

[#4]

@JKPieterse 



Hi friend,



First thank you for following up. So again, I am not very tech savvy or have a tech vocabulary (I'm so sorry) and the school I work for do not have the best CRM system as they are revamping their program. Hopefully, this is a better example, imagine you attend a College, and that college says you are missing (A-H) classes per your Educational Plan to complete your degree.  However, as the Advisor I need to develop a system to "track" your student progress. There are two program one that is called CID that only shows me what is missing per Area and Excel in which those areas need to be tracked. In developing this new system using Excel, I can track those Areas from 1-18 rather using "X" or pulling data from that one cell (example given in image) to either filter or extract into the rows that is missing those classes. Currently, with my job which is an online college there is not greater system and everything has to be more manual using Excel. 

[#5]

@rwilli10 Have you checked the attachment of @Patrick2788 ? It might do what you are looking for?