Forum Discussion
rwilli10
Apr 08, 2024Copper Contributor
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 ...
- 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
Apr 08, 2024Silver Contributor
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
Apr 09, 2024Copper Contributor
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.
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.
- JKPieterseApr 09, 2024Silver Contributor
rwilli10 Have you checked the attachment of Patrick2788 ? It might do what you are looking for?