Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Excel Exclude Data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 57.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Lee Jefferies
20
Reputation points
I have an all time list of World Cup teams in a league table format on excel with the placing in the 'league' based on average points due to the large difference in games played by the 90 nations who historically have played in a World Cup.
The league table is formed using VLOOKUP to copy the data from a dummy table. I want to be able to not show from the 'league' any team that has played less than 25 matches but the 'league' retains correct position numbers. Converting the 'league' to a table doesn't allow this to work.
The dummy table is created using SUMPRODUCT and SUMIF to capture the data from a fixtures list.
Microsoft 365 and Office | Excel | For home | Windows
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz 5,836 Reputation points2026-06-24T16:13:41.6933333+00:00 What do you mean by "not show"? Should that row be hidden? What is the dummy table? Are you extracting the desired data from the league table into the dummy? Are these actual Excel tables or are you using the word in its generic sense?
What do you mean by retain correct position number? Did you mean same relative position with the entries that do show?
It would really help if you showed sample data and the desired results.
Sign in to comment
Sign in to answer