•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Making range of numbers searchable
My organization uses Excel as a database to track seal numbers (6-10 numerical digits). Often, seal numbers are inputted dozens at a time (ie seals 000001-0000045).
The issue becomes, when someone then wants to locate a specific seal number, and uses the search number, a seal in the middle of the range would not be found (ie seal 0000033).
Is the only solution to type each seal number out individually? I haven’t been able to locate any other viable solution.
Tia.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel compatibility
#Excel alternatives for data analysis
#Excel alternatives
#rows.com
#real-time data collaboration
#real-time collaboration
#Excel
#seal numbers
#database
#searchable
#range of numbers
#numerical digits
#locate
#specific seal number
#inputted
#individual seal numbers
#search number
#viable solution
#track
#efficiency