New answers tagged index
I've got a formula for you that should do the trick. For it to work you'll need to do the following: In cell D1 you'll type your criteria. I entered 'Product One' (without the quotes) In cell E1 enter the following formula then press 'Ctrl+Shift+Enter' instead of just enter =MAX(IF(LEFT(A1:A5,LEN(D1))=D1,B1:B5))
Open up My Computer Right click the drive you want to index Select Properties At the bottom of the General tab (default tab), check the checkbox "Allow files on the drive to have contents indexed in addition to file properties" Repeat for other drives/partitions you wish to index
First of all, please clarify what you mean “near matches”. I’m guessing that you mean, for example, that “Product one 1 DEC 13” matches “Product one 2 DEC 13”. If that’s right (or close enough to being right), create a “helper column” that contains strings that can be matched exactly; e.g., C1 = C2 = C3 = “Product one”. If you need help with this, please ...
Go to the Control Panel, change the "View by" option to "Small icons" so you can see everything, then select "Indexing Options". You'll be able to rebuild and change index locations from there.
Top 50 recent answers are included