-
Count Distinct from multiple criteria?
I have a data set similar to this sample which contains: Primary column with unique names Visited dates column formatted as DATE ClientID column - this has a many to one relationship with the Primary (Sandra and Mike can both work for the same Client) Results of the visit: Yes, Maybe Product discussed I'm trying to get a…
-
Formula needed - if a cell in column A matches that of any other cell in column A
Attempting a superbowl board this year virtually. I am in need of a formula that will tell me if any Cell in column A is an exact match of any other cell in column A - I would like tit to display "DUPLICATE" in another column.
-
Rolling total
Hi, I'm trying to create a total days column based on the following: start date - end date (ie., 10 days) 1/1/21 - 1/10/21 end date changes to new end date based on extension 1 (i.e., 20 days) 1/1/21 - extended to 1/20/21 extensions can happen at least 4 times (columns are TA EXT 1, TA EXT 2, TA EXT 3 (all are date fields)…
-
How to cross reference two columns from one sheet to a data sheet. Counting by two data points.
Hi All, I am trying to count the number of product types (Column A), by Project Manager (Column D) and am always getting incorrect argument or inparseable. I can get the data if I just count the product types, but not when I want to only count product types by PM. I am putting this formula in a separate sheet (formula…
-
Need a formula for counting something on a weekly basis.
From the screenshot below, I need a formula to count the incoming mail based on each week. I want to show the information on a dashboard on a weekly basis which will exclude the weekends. For example here, I have the data for last week of Jan, but when we enter into next week, first week of feb, I want the dashboard to…
-
IF(Index-Match) - Multiple Entries in INDEX returns Non-Blank
I’m using an Index-Match formula and ran into an issue where the Source sheet (WIP Details) has multiple entries in the INDEX column (some entries w/ JobCtMo populated, some with JobCtMo blank). I want to capture only the entries where JobCtMo is NOT BLANK. I used the formula below, but it is returning the #INVALID DATA…
-
Rounding percentages in sheet summary
I am looking for a way to use the percentage number format on sheet summary and to be able to round the percentage to a whole number. I have tried adding ROUND to my formula but this just populates the field with 0 as the calculation to convert the number to a percentage happens separately to this. These fields link to a…
-
COUNTIFS Question
Hi all, I'm working with the formula below - =COUNTIFS({CXAO JIRA Range 1}, "Open", {CXAO JIRA Range 2}, "Change") I need to know if it's possible to add multiple criteria for the where "Open" is listed? I need to bring back a count of several statuses Open, Backlog, etc. all while meeting the second criteria" of "Change".…
-
Sheet Summary - Countif - #Invalid Operation
Hi all, Ok I am going crazy, hope someone can tell me where I am going wrong: I keep getting #Invalid Operation on a sheet summary Countif Formual based column "Days to Obtain PO Range" - This column had a formula in it I have a second column called "Test" - this column has the same formula as the above Why am I getting a…
-
Join Collect with collecting data from Multiple cells
Hi, I have six "issue" columns and six "resolved" columns. I'm trying to collect all the Issue columns into a final column. I'm using the following formula but I'm getting #INCORRECT ARGUMENT SET =JOIN(COLLECT([Issue I]@row, [Resolved I]@row, 0, [Issue II]@row, [Resolved II]@row, 0, [Issue III]@row, [Resolved III]@row, 0,…
