sjo007
New member
- Joined
- Dec 1, 2015
- Messages
- 28
- Reaction score
- 0
- Points
- 1
- Excel Version(s)
- Excel for Mac 16.4
Hi,
I am doing a fishing catch return and the csv table of the output of my form is attached.
Depending on the number of fish caught upto 3 in the attached example, depends on the number of entries showing location and category of fish caught per person. 1st fish, 2nd fish etc
I am trying to extract the following information:
- date (by month), person, guest or not, reach fished and category of fish caught. (each entry can have 1 ,2 or 3 entries of location and category of fish caught)
Is this possible by the use of a pivot table and if so how please - or should I produce another table from this one using the COUNTIF function and then to a pivot table ?
Any help and advice gratefully received.
Thank you very much
Stephen
I am doing a fishing catch return and the csv table of the output of my form is attached.
Depending on the number of fish caught upto 3 in the attached example, depends on the number of entries showing location and category of fish caught per person. 1st fish, 2nd fish etc
I am trying to extract the following information:
- date (by month), person, guest or not, reach fished and category of fish caught. (each entry can have 1 ,2 or 3 entries of location and category of fish caught)
Is this possible by the use of a pivot table and if so how please - or should I produce another table from this one using the COUNTIF function and then to a pivot table ?
Any help and advice gratefully received.
Thank you very much
Stephen