K Kenshin Member Aug 10, 2017 #1 Nice meetingyou friends, please have a look at the file, I have a problem that caused me headeache thank you in advanced Attachments Question.xlsx 9.1 KB · Views: 4
Nice meetingyou friends, please have a look at the file, I have a problem that caused me headeache thank you in advanced
R rahulshewale1 Active Member Aug 10, 2017 #2 hii pfa sheet .use pivot table . Thanks Rahul shewale Attachments Question.xlsx 12.4 KB · Views: 6
B bosco_yip Excel Ninja Aug 10, 2017 #3 In F3, formula copy down : =IFERROR(INDIRECT(TEXT(AGGREGATE(15,6,ROW($1:$8)/1%+{1,2}/(COUNTIF(F$2:F2,A$1:B$8)=0),1),"R0C00"),0),"") Regards Bosco Attachments AggregateData.xlsx 10.9 KB · Views: 8
In F3, formula copy down : =IFERROR(INDIRECT(TEXT(AGGREGATE(15,6,ROW($1:$8)/1%+{1,2}/(COUNTIF(F$2:F2,A$1:B$8)=0),1),"R0C00"),0),"") Regards Bosco
K Kenshin Member Aug 10, 2017 #4 Thanks @Rahul appreciate your help, and @Bosco thank you so much, your formula is rock man, even i cant' understand jhow possible they can work like magic thank you and awesome Kenshin
Thanks @Rahul appreciate your help, and @Bosco thank you so much, your formula is rock man, even i cant' understand jhow possible they can work like magic thank you and awesome Kenshin
