Advertisements Given a table T and headers H1, H2, H3. I know that we can use T[H1] to refer to the column under the header H1 of the table. Now, I have a cell A10 containing the header such as H1, H2, or H3. I would like to return the column depending the value of… Read More Reference to a column under a variable header of a table
Advertisements 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.… Read More EXCEL CONCATENATED SUMIFS are ignoring filters
Advertisements 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… Read More Need formula to Detect "Different products" for same ID IN EXCEL