|
| If you're trying to filter data by a specific "what" in Excel or Calc, the function you're looking for is probably "Filter." It lets you hide everything except the rows that match your criteria. To do this, select the header row with your column names, then go to "Data" and choose "Filter" in Excel (or "AutoFilter" in Calc). You'll get a drop-down menu for each column. Click the one for "what" and select the item you want to focus on.
Once you've filtered it, you can copy the visible rows and paste them into another spot on your spreadsheet. It should be a lot quicker than manually sorting and searching.
If you want to automate this process, consider using automatic data entry software. It can sort and filter data for you without much effort.
Edited by Rhubarb 4/29/2024 07:32
| |
|
Excel help please
