So I only recently have started using excel so I'm very basic at it. So naturally I'm working in a project that requires extensive knowledge of it. I work as an IT help desk at corporate for a medical group. I have decided to take the 100,000 tickets we have and export them to excel to create a solution database. It will be used as a tool to find solutions quickly by simply searching keywords. However I need to sort these tickets. For example if someone looks up what to do for "locked accounts" then I need to have all solutions readily available. So how do I sort through these tickets by text? Is there a formula? Also is there a way I can create a solution entry area so if someone fills out certain areas for a solution it gets sorted under the right category? I must sound like someone with a low intelligence level but I have never really had training in excel beyond =a1+b2 sad I know lol any answer would be greatly appreciated.
Last edited: