Forum Discussion
Viewing data rows from another worksheet in a portal
First off, I'm a novice with Excel. Learning by exploring. I have a worksheet (#1) with 14K+ rows of data (30+ columns). One of the columns on sheet#1 holds a unique ID number for each row. On anothe...
In the absence of a link to your actual workbook, I'm just going to point you in the direction of the function that I/m pretty sure will do what you want, leaving you to figure out more specifically the "how to"
That function is the FILTER function, and it will require Excel 2021 or newer. This link takes you to a website that describes how to use it.
And this video is also very instructive.
I'd be happy (and I'm sure others would too) to help further. You can help us help you by posting a copy of the actual workbook (or a reasonable facsimile)--not an image-- on OneDrive or GoogleDrive, with a link pasted here that grants access to it.