Mar 17 2020 11:12 PM
Mar 17 2020 11:16 PM
Hi @rutvik276
The best solution is to make the PivotTable that can answer all your point.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.
Mar 18 2020 01:03 AM
i make a pivot table then how to do sir.i am a beginner in excel.i know to add different categories but how will that answer my questions@Faraz Shaikh
Mar 18 2020 05:48 AM
Mar 18 2020 05:51 AM
i am sorry but i dont know how to send excel file here@Faraz Shaikh
Mar 18 2020 05:54 AM
Mar 18 2020 05:56 AM
oh sorry for being so stupid.here it is @Faraz Shaikh
Mar 23 2020 05:46 AM
SolutionHi @rutvik276
Please see the attached file with all your question solution
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.
Mar 23 2020 07:27 AM
@Faraz Shaikh Great though its late.I aready have done it as u suggested me pivot table earlier.Thank you so much for solving in so detail and using your time.
Mar 23 2020 09:47 AM
@rutvik276 wonderful.. I am happy to hear you solved it by yourself .. :)
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.
Mar 23 2020 05:46 AM
SolutionHi @rutvik276
Please see the attached file with all your question solution
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer.