Gather unique values from one sheet but leave out values based on a value from other colum

Hello,

In the attachment, I am looking to gather unique values from one worksheet and populate on another worksheet.

But I am looking to leave out values "Customers" who have no value "amount" next to their name.

I played with the unique function, but I don't think editing will work in this case.

I then want to sum the adjacent columns for those Customers.

I appreciate any assistance.

Thank you,
Nick

How about

Formula:

Please Login or Register  to view this content.

That is amazing Fluff13!

Is it possible, without adding another column on the Data Entry sheet, to have the formula expand another column with the Paid In minus the Paid Out?

For example, Patron #02 has $1500 - $800, column D would show $700.

But that is amazing, thanks for your skills.

How about

Formula:

Please Login or Register  to view this content.

Fantastic! you are awesome.

Thank you,

You're welcome & thanks for the feedback.

I added a sort to this, but do you know how I can reverse sort? High to low?

=SORT(LET(u,UNIQUE(FILTER('DATA ENTRY'!B2:B100,'DATA ENTRY'!C2:C100<>"")),in,SUMIFS('DATA ENTRY'!C:C,'DATA ENTRY'!B:B,u),out,SUMIFS('DATA ENTRY'!D:D,'DATA ENTRY'!B:B,u),CHOOSE({1,2,3,4},u,in,out,in-out)),4)

Add ,-1 after the 4

Great, thank you.

Hi Fluff, I am not sure if you are still around, but I inserting a column after the customer name, and I am trying to get that to return also.

I keep trying, but no luck.

Attached is an example of what I am trying to do.

If you can, I appreciate your help.

Nick

Which number should it return? eg Patron#5 is 127 & 147

Sorry, I just threw some numbers on there, the patrons will always have the same number.

I attached a corrected copy.

Ok, how about

Formula:

Please Login or Register  to view this content.

Thank you Fluff, that works perfect. I learn quite a bit here, but I am always amazed with these complicate formulas you and others put together.

Hi Fluff, you have been so much help and may be offline for the day, but I wanted to know if this formula could only display results if the last column the difference between values is greater than 0. (in-out) is great than 0. Thank you.

Are you going to make any more changes or is this the last?

Hi Fluff, this is the last. I input the formula from my template into my master file and this was the last update I need. Thanks

How about

Formula:

Please Login or Register  to view this content.

Thank you Fluff, that worked and that is all for this project. I appreciate your help.

Glad to help & thanks for the feedback