Help & Advice: I need to make an excel spreadsheet linked to a form that randomly selects ~11 responses/rows & moves those responses to a different tab

Our take

Managing a patient lottery for your free healthcare clinic can be a complex task, especially when working with Excel. To streamline your process, you’ll want to create a system that randomly selects approximately 11 responses from a linked Microsoft Form and transfers those entries to a “Selected Patients” tab. Additionally, implementing features to delete responses every six months and eliminate duplicates based on phone numbers will enhance efficiency.

I am working for a free healthcare clinic, and I desperately need help with excel. For our clinic, interested patients fill out a microsoft form, and then they are randomly selected to be seen by us in the excel spreadsheet linked to the form. However, I have no experience in making this happen in excel. I am working with someone familiar with excel to make this happen, but I wanted to ask this here in case anyone has specific experience and advice in these areas.

Ideally, I need:

To get a list of 11 random patients/rows/responses from the patient lottery responses
To then move those responses off this tab to a “Selected Patients” tab
To be able to delete responses every 6 months
To automatically delete duplicate responses (likely using duplicate phone numbers)

Any help is appreciated - links, tips, etc. Thank you so much.

submitted by /u/shrekedyourlastshrak
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#Excel compatibility#Excel alternatives#rows.com#financial modeling with spreadsheets#natural language processing for spreadsheets#generative AI for data analysis#modern spreadsheet innovations#machine learning in spreadsheet applications#enterprise-level spreadsheet solutions#digital transformation in spreadsheet software#collaborative spreadsheet tools#AI-driven spreadsheet solutions#cloud-based spreadsheet applications#automation in spreadsheet workflows#no-code spreadsheet solutions#AI-powered spreadsheet#spreadsheet API integration#excel#spreadsheet