Make a column in the original data and use a if statement to refer to that criteria ("yes"). After that you can make a pivot table and add the criteria in the filter box and select on "yes".
Make a column in the original data and use a if statement to refer to that criteria ("yes"). After that you can make a pivot table and add the criteria in the filter box and select on "yes".
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
Thank You for your advice.
Can you explain with an example or the formula for the statement.
Many thanks.
Eric
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks