I have this task that is taking too much time
So on one column I have products and the other the bugs that are on this products.
I want to create a table that will show the number of different bugs on each product.
PS: as shown
I have this task that is taking too much time
So on one column I have products and the other the bugs that are on this products.
I want to create a table that will show the number of different bugs on each product.
PS: as shown
Have you tried a Pivot Table?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Yeah thanks so much NBVC u saved my life that really helped, except now that some bugs are showing twice ??
okay I got it thank you so much
Now I have another problem, on some product are showing twice in the Pivot table !!!
Some of your entries have trailing spaces. Those need to be cleaned.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks