Showing related tags and posts accross the entire site.
-
Hello again! Wondering if its possible with the same example to actually count the distinct values in the given column I'm aware that I can get distinct count (including text) by saying: =SUM(IF(FREQUENCY(IF(LEN(H3:H11243)>0,MATCH(H3:H11243,H3:H11243,0),""), IF(LEN(H3:H11243)>0,MATCH...
-
Hello, Would highly like if you could shed some light on how I can accomplish this. My sheet has three segments. The first being a selection for the users (the user can choose which category they want to view the reports for): Selection # Category Include? 1 Electricals Yes 2 Paper Yes 3 Food Yes 4 Beverages...
-
Here is a typical row in the spreadsheet which is nearly 4000 rows of data: Description WBS WBD Material Qty Mea Size | Ball Valve, V600, 02 | C12DO | F1804B | CARBON STEEL, PIPING | 12 | EA | 1" | Im trying to use the "Description" & "WBS" columns for the criteria to match...
-
I'm sure many of you knew this but it was new to me and I came across it today, so in an effort to get it out there a bit more, i document it here. It concerns the fact that COUNTIF and SUMIF (and their 2007 plural counterparts SUMIFS and COUNTIFS) carry forward the limitation that Excel has of 15...