There isn't a direct way to filter data based solely on the existence of a hyperlink in Excel. However, you can achieve this functionality with a combination of helper columns and filtering techniques. Here's one approach:

Method 1: Using a Helper Column and Filter

1. Add a Helper Column: Insert a new column next to your data (e.g., Column C) where you suspect hyperlinks might be present.
2. Formula for Hyperlink Check: In the first cell of the helper column (e.g., C2), enter the following formula:

```excel
=ISHYPERLINK(A2) Replace A2 with the actual cell reference containing your data
```

This formula checks if there's a hyperlink in cell A2.
3. Copy Formula Down: Drag the formula in cell C2 down to apply it to all the remaining cells in the helper column corresponding to your data range.
4. Filter Based on Helper Column: Now you can filter your data based on the values in the helper column. Click on the filter arrow for the helper column (e.g., Column C).
5. Filter by Hyperlink Presence: Choose "(Select All)" to uncheck all options. Then, select "TRUE" to filter for rows where a hyperlink exists (TRUE indicates a hyperlink) and "FALSE" for rows without a hyperlink (FALSE indicates no hyperlink).

Alternative Method: Using Advanced Filtering

1. Copy Data: Copy your entire data range (including the helper column) to a new location on your sheet.
2. Advanced Filter: Go to the "Data" tab and click "Advanced" within the "Sort & Filter" group.
3. Criteria Range: Set the "Criteria range" to the range containing your helper column with the hyperlink check formula.
4. Copy Data Location: Define the "Copy to" range as the original location of your data (where you want the filtered results to appear).
5. Check "Copy Top Rows" (Optional): If you only want the top N rows with hyperlinks, enter that value in the "Copy top rows" box. Otherwise, leave it blank.
6. Check "Unique records only" (Optional): If you only want unique entries based on hyperlinks, check this box.
7. Click OK: Click "OK" to run the advanced filter. This will copy only the rows with TRUE values (indicating hyperlinks) in the helper column to your original data location.

Remember to remove the helper column after filtering if you don't need it anymore.

These methods allow you to filter your data based on the presence or absence of hyperlinks within your original data range.