•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Search Professionals by Specialties
Our take
Introducing a streamlined approach to searching for professionals by specialties in Excel. This project aims to optimize a comprehensive list where each professional is represented in their own row, detailing their first name, last name, and specialties. By employing a text-split function, specialties can be efficiently categorized. However, challenges arose with the grand list of specialties returning a #CALC! error due to length limitations. I'm eager to explore innovative solutions to enhance this process and welcome any insights or questions you may have!
Hi!! I'm working on an Excel sheet to effectively search through a list of professionals and their specialties. All information in linked screenshot is just a placeholder. If you have any questions I'd be glad to answer!!
Currently, I have each professional in their own row.
First name, Last name, List of specialties, Split
"Split" is the start of a textsplit function, splitting the list cell into individual specialties across the row.
I originally tried this by creating a function that vertically lists all unique specialties underneath the data set, then using that list as the data validation lists for the options. I also made a "score" column that adds points to each professional depending on how many times options are in their specialties, then another function to list and sort anyone with a score higher than (highest score)-2.
The problem with this is that once the specialties reach a certain number, the grand list of specialties only returns #CALC! because it is too long.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Making a fillable form with dropdowns and sections that can be added and moved easily**SEE ATTACHED IMAGE** I am attempting to improve this spreadsheet. I have a decent amount of experience with Excel but I am unfamiliar with the terminology require to describe the exact functions I am attempting to implement. The function of the sheet is to log various statuses and information pertaining to ladders and their inspection status. Each workbook has a header section and a footer section to diffentiate between clients. The sections that detail the individual ladders need to be moveable / re-order more easily, and also be able to insert a blank ladder section for any new ladders that come into service. The reason excel was selected is for access reasons. All of our clients use excel, but if there is an objectively better tool for the job that is part of the Office suite that people can use via the web or with their Office licence then I will consider that. Thank you to everyone who is able to provide some insight into this. https://preview.redd.it/7ln3oocpcjvg1.png?width=1405&format=png&auto=webp&s=584525d55bd27779bd56a9d746b5dcc6dd913c70 submitted by /u/WillowDime [link] [comments]
- Fill out a ranking using data from other pagesHi everyone, I'm not a particularly frequent excel user, and I'm making a silly spreadsheet documenting the reviews my Australian friend is giving to British crisps. Each crisp has a picture on the home page, which when clicked takes you to the individual review of the crisp. She has ranked each crisp with different categories and given it an overall rating. I would love for each "overall rating" to go to a final page on the spreadsheet which shows all the crisps in ranking order. Now, of course I could just go through and type them in, changing them each time she reviews a new crisp, but is there a way excel can take this information with a formula? For example, on each individual crisps page the overall rating is cell D8. If a quaver was rated 8.5, a pombear was rated 6 and a mini cheddar was rated 7, could excel automatically put them in order of quaver, mini cheddar, pombear on my final ranking page? I appreciate this is a very long winded way of getting it across but it's a bit niche and so I wanted to try and make it clear! (It's much easier to just show someone a video of the spreadsheet but I don't think I can do that here!) Thanks!! submitted by /u/puzzled_puzzler12 [link] [comments]
- Turning Text Form Responses into data values by date rangehttps://preview.redd.it/bdvlums2uhrg1.png?width=1728&format=png&auto=webp&s=621787b11e12ef3be6ade0f0bbeb646022f69716 Hi all, I'm trying to create a function / series of functions to turn the form responses in a recruiting spreadsheet (see screenshot) into month by month data tracking. Basically, when an applicant is processed through the system, a new entry is made with their name, whether they were contacted, and then a series of yes/no answers as to whether they received a screening interview, in-person, second interview, and ultimately whether they were hired. My workplace wants to make a sheet where, for each month, there's tracking for total number of applicants processed, how many were screened, how many got a first interview, how many got a second interview, etc. This would also include totals for "how many applications came from Indeed, our own website, or Other" (tracked in the blacked-out column on the right). I'm newer at Excel and struggling to think through whether this is one big, long Lookup-style function for each month and each category, or if there are intermediate steps that needs to pull these Yes/No answers out and turn them into 1's and 0's first. submitted by /u/Sivarian [link] [comments]
- Need better way to organise spreadsheethttps://preview.redd.it/oiuewnp0pstg1.png?width=599&format=png&auto=webp&s=d34be7eaeb702d5ded087538a2292a57b295dd65 I am currently keeping track of visiting football stadiums (often called the 72 or the 92) as you can see on the attached image, the shear amount of anfield visits leads to many duplicate entries and am wondering if anyone has a suggestion on tidying this up, so that anfield appears once, but perhaps links through so that i can see all visits there will also likely be more stadiums in the future that will have multiple duplicates. *several columns to the right cropped off because of personal data. submitted by /u/EpilepticFlshbng [link] [comments]