• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Grouping Data

Kenshin

Member
This is double post


and still no answer, please need help and take a look at the file for clear explanation and need formula solution (Im using office 2019

Thank you
 

Attachments

pecoflyer

Active Member
Please be patient. this is a free forum staffed by members working for free on their spare time ( as on XLforum).
If you are looking for an urgent answer there are pay sites who will do the job fast
OTOH you give no requirements whatsoever in your post, and your title is less than descriptive
You cannot expect members to have to open your file to see what you need, and if its in their domain of expertise
 

Peter Bartholomew

Well-Known Member
Good luck. I can make progress with Excel 365
Code:
= LET(
  leadOccurrence, IF(NOT(COUNTIFS(Kiosk_Name,Kiosk_Name,No,"<"&No)), Kiosk_Name, ""),
  requiredData, IF({1,0}, leadOccurrence, Source_Note),
  SORTBY(requiredData, Kiosk_Name))
73396
but I do not fancy the task with traditional spreadsheet techniques
 
Top