Forum Discussion

rwilli10's avatar
rwilli10
Copper Contributor
Apr 08, 2024

Filter rows

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...

 

 

BI & Data Analysis
Charting
Formulas and Functions
  • JKPieterse's avatar
    JKPieterse
    Apr 08, 2024

    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?

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 08, 2024

    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?

  • Patrick2788's avatar
    Patrick2788
    Silver Contributor
    Apr 08, 2024

    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)
)
    • rwilli10's avatar
      rwilli10
      Copper Contributor
      Apr 09, 2024
      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. 

Resources