Which function to use? List with amounts that automatically update based on client name

asked 2020-07-16 10:47:08 +0200

schlagzeuger gravatar image

updated 2020-07-16 10:54:57 +0200

Hello,

I am trying to create something like this, where the dates and amounts automatically appear and update based on the client name in column J.

Can anyone point me to the correct function I should use for something like this?

Thanks in advance!

image description

edit retag flag offensive close merge delete

Comments

Why don't you just sort your data by client? (If you can't do that, check for Pivot Tables).

Opaque gravatar imageOpaque ( 2020-07-16 12:23:29 +0200 )edit

I have actually a much larger amount of data, but want to be able to provide a simple summary like this. I will check out Pivot Tables. Thank you

schlagzeuger gravatar imageschlagzeuger ( 2020-07-16 12:43:46 +0200 )edit

Also look at subtotals - maybe it will be easier than a pivot table, but it will give an acceptable solution

JohnSUN gravatar imageJohnSUN ( 2020-07-16 12:53:18 +0200 )edit

Very helpful, thanks!

schlagzeuger gravatar imageschlagzeuger ( 2020-07-16 13:48:22 +0200 )edit