DISTINCT
Can DISTINCT be used to identify a distinct row of data?
Answers
-
How so? What exactly are you trying to accomplish?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
The sheet would look like this:
I would like to identify the DISTINCT rows only:
-
Which field(s) would be used to meet the requirement? It looks like you are excluding the date field? Is there a particular one from each grouping that you would want to pull such as earliest or latest date?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
The grouping would just include LO No, P.O., Cost Ctr, Vendor, Amt.,
-
And if there are multiple rows such as for 873, which one would be pulled? Earliest Date?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Correct, earliest date.
-
Ok. First, for any column that could contain both numerical and text entries (such as the [LO No] column), you will need to create a helper column that converts everything into text strings.
=[LO No]@row + ""
From there you would insert a checkbox column with something along these lines...
=IF(COUNTIFS([LO No Helper]:[LO No Helper], @cell = [LO No Helper]@row, [P.O.]:[P.O.], @cell = [P.O.]@row, [Cost Ctr]:[Cost Ctr], @cell = [Cost Ctr]@row, Vendor:Vendor, @cell = Vendor@row, Amt:Amt, @cell = Amt@row, Date:Date, @cell<= Date@row) = 1, 1)
This should check the box for the earliest date for each of those unique combinations. You can then create a row report that is filtered to only show rows where that box is checked.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!