unique criteria

I've been racking my brain all day on this one and desperately need someone to swoop in and give me the answer. Data is set up as follows: <tbody> SSN $Dollars Date 123 $10 10/10/2018 123 $10 10/12/2018 456 10/14/2018 456 $20 10/16/2018 123 11/10/2018 789 $10 11/12/2018 1011...

Hi Team, I am looking for some help here, I have base data and need to get the unique info based on one criteria in the below example is is "Category". Why I am looking formula is because it should dynamic and should not perform pivot/remove duplicate every time. Base Data...

hi i'm trying to calulate otif (on time in full) for deliveries we make. B has the order number - i can calulate the number if unique orders (three) I cannot work out how to calulate how many order were in full (c=3 and I = blank) (c = 1 ordered, c=3 delivered, I = action: Backorder, Deleted...

Hi, Thanks for showing interest in this post. I have 2 excel sheets one of which has entire database and 2nd sheet contains day-wise production data as below Sheet 1: Database <tbody> Month Date Emp_ID Emp_Name Attendance Status Task1 Production for Task1 (PD1) Task2 Production for Task2...

A table of data that holds records of multiple projects. Projects may be duplicated within the table however, when they are, their Total Units are always the same number. Obviously, a problem with this is that I cannot easily provide a sum or subtotal of the Total Units without double counting...

Dear Seniors, I would like to share a question regarding unique list in between range. I have a data in which Column A have a range 1 to 999 and all are unique values. I want to show 1-333 rows data in Column B I want to show 334-666 rows data in Column C I want to show 667-999 rows data in...

I need help on this problem. I have a large dataset, and I need to get a count for every UNIQUE 3 Bedroom record, below. So if floor plan type = 3 Bedroom, then count the records, but only for UNIQUE unit numbers and UNIQUE property name. IE, if there are 4 unit E1001 at property xxx, that...

Hi all, I'm trying to extract a list from a couple of columns. <tbody> A B 1 Documents Required? 2 Form 1 Yes 3 4 Form 2 Yes 5 6 Form 3 No 7 </tbody> First column has a list of all the forms (one blank row after each form). Column B indicated whether that form is...

Hi, I have a very large data set, 10,000 rows and 150 columns. I need to extract and display unique values from the rows. My data is arranged as follows. <tbody> A B C D E F G H I J 1 Boston 3 5 3 7 3 2 NYC 1 2 2 4 8 </tbody> Desired Result Display: <tbody> Boston 3 5 7...

Hello, everyone. My first post/question. Thank you in advance for the help. I need to determine unique company names from within a list of clients, 12,000+. There are numerous variations on how the company names are presented. I don't feel like trying in Excel to go after disambiguating...

Hi Everyone, I've been puzzled with this one for way to long and am hoping someone will be able to help! :) Below is an example of the data I'm using: <tbody> <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> Name Chris John Adam Chris Rob...