• 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

  • Ask Formula.xlsx
    10.6 KB · Views: 13
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
 
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
 
Add a column E to your data and pivot. See attached.
 

Attachments

  • Chandoo45824Ask Formula.xlsx
    14.8 KB · Views: 5
…or a not very elegant (nor efficient) Power Query query table at cell L1. Right-click and choose Refresh to update.
 

Attachments

  • Chandoo45824b Ask Formula.xlsx
    20.8 KB · Views: 1
Back
Top