J
JoeSpareBedroom
Maybe. Just got a call from a user with Excel 11, who claims that once upon
a time, he had a search feature (not the Find feature) which would gather
all occurrences of a value into one "screen" as he calls it, instead of
stepping from one occurrence to the next (as with the Find Next button). I
use Excel 2000, so I have no idea if he's making this up. He is not savvy
enough to build such a thing using VBA or spreadsheet functions, although
it's possible that one of his customers has been sending him a tricked up
sheet, and then eliminated the trick.
Absent that last possibility, was there anything like this feature included
with "right outta the box" Excel-11? Something he may have accidentally
turned off? I stepped him through the menu customization process, but
there's nothing obvious. He claims it existed in the File menu, but who
knows?
a time, he had a search feature (not the Find feature) which would gather
all occurrences of a value into one "screen" as he calls it, instead of
stepping from one occurrence to the next (as with the Find Next button). I
use Excel 2000, so I have no idea if he's making this up. He is not savvy
enough to build such a thing using VBA or spreadsheet functions, although
it's possible that one of his customers has been sending him a tricked up
sheet, and then eliminated the trick.
Absent that last possibility, was there anything like this feature included
with "right outta the box" Excel-11? Something he may have accidentally
turned off? I stepped him through the menu customization process, but
there's nothing obvious. He claims it existed in the File menu, but who
knows?