I have table with summary like that. To achieve that summary I used formula like that: CONCATENATE(SUMIFS(A2:A13;C2:C13;"=JPY");" JPY";CHAR(10);SUMIFS(A2:A13;C2:C13;"=EUR");" EUR";CHAR(10);SUMIFS(A2:A13;C2:C13;"=PLN");" PLN"; ) The problem is its not working with filters in column. How can I modify this formula to consider filters? It needs to be in single cell because this sheet is created in java. >Solution… Read More EXCEL CONCATENATED SUMIFS are ignoring filters

I’ll need a formula in excel to detect for example 1111; has three different products linked, meanwhile 2222 has only linked "oranges" Here I left and example of my excel table: Product ID Product Name 1111 Apples 1111 Orange 1111 Grapes 2222 Orange 3333 Apples 3333 Orange 3333 Grapes 4444 Orange Hope it is clear!… Read More Need formula to Detect "Different products" for same ID IN EXCEL