Data showing who pays a doesnt after manually input receipts

Solved/Closed
ramaemachado
Posts
2
Registration date
Monday January 15, 2018
Status
Member
Last seen
January 16, 2018
- Updated on Jan 16, 2018 at 04:48 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Jan 17, 2018 at 07:17 AM
Hello,


Hope im clear on this. Im a bit lost. I have sheet one. This is a spredsheet where we input a secuential number with the name of the student, the date and the amount paid. For example:

date # name amount paid

jan-1-2018 288478 Ricky $300
jan-2-2018 288479 Monica $300
jan-8-2018 288480 Irene $300
feb-2-2018 288481 max $300
feb-4-2018 288482 Monica $300
feb-4-2018 288483 max $300
feb-15-2018 288484 Ricky $300


and so on... manually only entering the name, date and the amont on any random order.
ON sheet 2, i have a table with the name of the student and a full year calendar. Im looking for a way that on January box besides Rickys name, I have $300 or if he did not pay that month, no value. the same for the following months jan-december (1 year) and the same for every other student. Im looking for a simple way of after manually inserting the receipt number with the amount paid, date and name on sheet 1, i can have a full report of all students on a simple JAN-DEC calendar something like this:

JAN FEB MAR APR MAY JUN JULY AGO SEP OCT NOV DEC
RICKY $300 $300
MONICA $300 $300
IRENE $300 $0
MAX $300 $300

I dont need the exact date on the table, only the month they paid.

Was wondering if anyone has a suggestion of how it can be simpler? Any suggestions will be greatly appreciated!

2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jan 16, 2018 at 07:00 AM
ramaemachado, Good morning.

Your necessity is a common process for this situation.

I did an example for you to study:
https://www.sendspace.com/file/dyuxmn

Adapt formulas and layout to your reality.

Is that what you want?
I hope it helps
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
3
ramaemachado
Posts
2
Registration date
Monday January 15, 2018
Status
Member
Last seen
January 16, 2018

Jan 16, 2018 at 10:24 PM
Wow! thank you soooooo much! Great example easy to replicate. I appreciate it tons!
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jan 17, 2018 at 05:23 AM
ramaemachado, Good morning.

I'm very happy to have been able to help you with your task.

Have a nice day!
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
0
Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021
11,315
Jan 17, 2018 at 05:25 AM
Marcílio, you are one of CCM's heroes and admired contributor.
0
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147 > Ambucias
Posts
47366
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
September 1, 2021

Jan 17, 2018 at 07:17 AM
Dear Ambucias, thank you very much for the comments but in fact this is not everything you said.

I have great pleasure in helping people whenever my knowledge reaches the degree of difficulty presented by the question.

Congratulations to you for the good work of moderating this important place of cooperation and international technical assistance in EXCEL.

Thanks again for the comments.

Have a great day!
0