hi everyone. i have a table which consists of a class number, syle number, qty onhand, and qty sold. using Data/Subtotal, i can get the sum of the qty onhand, and sales, by class now i have a table, with a row inserted, which carries the subtotals by class. the number of style numbers per class varies.
now, i need to count the number of unique styles, in column b, with the total count of styles, inserted on the row, which also has the subtotals. the style numbers start on row 2, and end at the first instance of 2 consecutive blank rows.
i would appreciate any help, you can provide. thanks.
now, i need to count the number of unique styles, in column b, with the total count of styles, inserted on the row, which also has the subtotals. the style numbers start on row 2, and end at the first instance of 2 consecutive blank rows.
i would appreciate any help, you can provide. thanks.
