Juniad Active Member Jul 13, 2020 #1 Hi all, I have attached file where manually i mentioned desired result plz help out to do in Excel 2007. Attachments Sample WB.xlsx 27.3 KB · Views: 9
Hi all, I have attached file where manually i mentioned desired result plz help out to do in Excel 2007.
N navic Active Member Jul 16, 2020 #3 See if the attached idea suits to you. Attachments Junaid-Navic44650.xlsx 31 KB · Views: 9
shrivallabha Excel Ninja Jul 16, 2020 #4 If you are okay with adding a column to your layout then you can use Pivot table. See attached file. Attachments Sample WB.xlsx 37.4 KB · Views: 8