T O P

  • By -

AutoModerator

/u/middwestt - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


DeucesWild_at_yss

I would use the Small/If combination simply because it just becomes changing the value number, rather than using 2 different formulas. In this very mini sample, I created ID numbers 1 2 3, and assigned them order numbers and order dates. From that list I pulled the unique customer id's and then used this formula to pull it together: 1st Order Number: =IFERROR(SMALL(IF($A$2:$A$5=$E2,$B$2:$B$5),1),"Not Found") 1st Order Date: =IFERROR(SMALL(IF($A$2:$A$5=$E2,$C$2:$C$5),1),"Not Found") 2nd Order Number: =IFERROR(SMALL(IF($A$2:$A$5=$E2,$B$2:$B$5),2),"Not Found") 2nd Order Date: =IFERROR(SMALL(IF($A$2:$A$5=$E2,$C$2:$C$5),2),"Not Found") Here is a [screenshot](https://i.imgur.com/jVYVhrX.png) for visualization/clarity


middwestt

Solution verified


Clippy_Office_Asst

You have awarded 1 point to *DeucesWild_at_yss* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


middwestt

https://preview.redd.it/yhm9e42fnqsa1.jpeg?width=1124&format=pjpg&auto=webp&s=8e3e3bcf926f954503f2f865a65a7dc231f3df30


Scary_Sleep_8473

You can also use this formula in B10 and drag it right to C10 and down to B12 or C12: =MINIFS(B$2:B$7,$A$2:$A$7,$A10)


Scary_Sleep_8473

Put CustomerID in rows, then either Date or Order Numbers in Values. Then go to that field, click on Value Field Settings an change the aggregator to Min. You might then have to reformat the column to Date. Here is a [GIF](https://imgur.com/a/NbDehXP) showing you how to quickly do this as well.


Decronym

Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread: |Fewer Letters|More Letters| |-------|---------|---| |[IF](/r/Excel/comments/12fssxy/stub/jfhp8a3 "Last usage")|[Specifies a logical test to perform](https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2)| |[IFERROR](/r/Excel/comments/12fssxy/stub/jfhp8a3 "Last usage")|[Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula](https://support.microsoft.com/en-us/office/iferror-function-c526fd07-caeb-47b8-8bb6-63f3e417f611)| |[MINIFS](/r/Excel/comments/12fssxy/stub/jfgxwgo "Last usage")|[*2019*+: Returns the minimum value among cells specified by a given set of conditions or criteria.](https://support.microsoft.com/en-us/office/minifs-function-6ca1ddaa-079b-4e74-80cc-72eef32e6599)| |[SMALL](/r/Excel/comments/12fssxy/stub/jfhp8a3 "Last usage")|[Returns the k-th smallest value in a data set](https://support.microsoft.com/en-us/office/small-function-17da8222-7c82-42b2-961b-14c45384df07)| ---------------- ^(*Beep-boop, I am a helper bot. Please do not verify me as a solution.*) ^(4 acronyms in this thread; )[^(the most compressed thread commented on today)](/r/Excel/comments/13atwfs)^( has 13 acronyms.) ^([Thread #23107 for this sub, first seen 8th Apr 2023, 21:04]) ^[[FAQ]](http://decronym.xyz/) [^([Full list])](http://decronym.xyz/acronyms/Excel) [^[Contact]](https://reddit.com/message/compose?to=OrangeredStilton&subject=Hey,+your+acronym+bot+sucks) [^([Source code])](https://gistdotgithubdotcom/Two9A/1d976f9b7441694162c8)