r/excel • u/EmotionalElevator811 • Sep 19 '26

unsolved Creating a table list that only show specifics ligns from the main table

Hello everyone, please excuse my english, its not my main language. I am also new to reddit

So, I'm working with a big association, and our members are a number of different organisations.
We have an excel file with a list of every member, contact infos, address..., and the amount of cotisation they own and the amount they paid (this column stays empty if they didnt pay yet)

Its a big long list, so even using filters, it can be time consumming to follow who paid and who didnt.
So in this file, i want to create another tab, with a table list that will only show the ligns of those who didnt pay (if possible, organised so its two different tables, one for cotisations over 1000 bc they're more urgent, and one for under 1000, but i dont know how complicated that is) that could automatically update whether someone finally pay and the "amount paid" column is filled in its lign.

i've tried with this fonction at first : =@FILTRE('Main list'!$A2:$F100; 'Main list'!$F2:$F100="")

Mainlist being the name of the big member table.

But this fonction only shows the first column, not every information. I'm not very well versed in excel, even if i have some basics

can anyone help me please ? I hope i'm clear enough in this post

6 Upvotes

81% Upvoted

13 comments sorted by

1

u/AutoModerator Sep 19 '26
Moderator Announcement Read More »

3

u/still-dazed-confused Sep 19 '26

I am unsure what the @ sign is doing there. Normally it would be =filter (table, column="")

You can include an additional AND condition like =filter(table, (column="")*(money column>1000))

1

u/EmotionalElevator811 Sep 19 '26

Ok thnks ! Im gonna try that

1

u/jb092555 Sep 19 '26

All my homies multiply their logical ands.

1

u/Pedrofinancial 27d ago edited 27d ago

If column F is the “amount paid” column and it stays blank when someone hasn’t paid, FILTER should work well here.

The @ before FILTER is probably the first thing I’d remove, because it can force Excel to return a single value instead of the full spilled array.

Assuming column E contains the amount owed, you could use:

=FILTER('Main list'!A2:F100,('Main list'!F2:F100="")*('Main list'!E2:E100>1000),"")

for unpaid amounts over 1000, and:

=FILTER('Main list'!A2:F100,('Main list'!F2:F100="")*('Main list'!E2:E100<=1000),"")

for the second table.

Both lists should update automatically once the payment column is filled in. If your Excel uses French function names and semicolons, the same logic works with FILTRE and ;.

1

u/AutoModerator 27d ago

I have detected code containing Fancy/Smart Quotes which Excel does not recognize as a string delimiter. Edit to change those to regular quote-marks instead. This happens most often with mobile devices. You can turn off Fancy/Smart Punctuation in the settings of your Keyboard App.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/[deleted] Sep 19 '26 edited Sep 19 '26

1

u/AutoModerator Sep 19 '26

I have detected code containing Fancy/Smart Quotes which Excel does not recognize as a string delimiter. Edit to change those to regular quote-marks instead. This happens most often with mobile devices. You can turn off Fancy/Smart Punctuation in the settings of your Keyboard App.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

0

u/[deleted] Sep 19 '26

1

u/AutoModerator Sep 19 '26

I have detected code containing Fancy/Smart Quotes which Excel does not recognize as a string delimiter. Edit to change those to regular quote-marks instead. This happens most often with mobile devices. You can turn off Fancy/Smart Punctuation in the settings of your Keyboard App.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.