Thread: Excel question
20th February 2007 #1
Right, getting off the plumbing questions in the PC section and back to computer advice
If I have a list in excel as such
Can I do a search for File 3465 to get it to bring up the 2nd item in the list (3459-3478)???
20th February 2007 #2
20th February 2007 #3
No, but I have some stuff to jot down.
It will say something like 3459 to 3478
Is there no way I could put that down
so that it would know a file in between those numbers is there!
20th February 2007 #4
How are you planning to use this search facility? A normal find works on a string match which wouldn't work in this case as a search for 3465 wouldn't find a match anywhere in your data.
You need the row (basically) containing a file number lower than (or equal to) the search string and one greater than (or equal to) it don't you? What will you then do with that row number?
20th February 2007 #5
Every few set of files will be in an individual box, so the search wil only be to determine which box the particular file is in!
So if I do the start and finish file in different columns,
and then do search for file number it will take me to the closest figure, yes?
20th February 2007 #6
20th February 2007 #7
The lokup thing is a great idea too!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)