The tag has no usage guidance.

learn more… | top users | synonyms

6
votes
5answers
9k views

How to get VLOOKUP to return the *last* match?

I'm used to working with VLOOKUP but this time I have a challenge. I don't want the first matching value, but the last. How? (I'm working with LibreOffice Calc but an MS Excel solution ought to be ...
3
votes
4answers
8k views

Problem with network shares

I have a laptop installed with Windows 7 that has problems in accessing network shares. Even if I am able to ping the computers containing the share then I get the infamous "Windows cannot access the ...
2
votes
2answers
2k views

Dos executable lookup except PATH

I have a cmd open (Windows 7), and I type "java.exe", and the system finds the executable at c:\program files\java\jre6\bin. However, this folder is not in the path. What other mechanism affect the ...
3
votes
1answer
2k views

Excel 2013 Fuzzy Lookup to find near-duplicate text

I have a list of captions with a large number of near-duplicates. For example: Birthday for Her For Her Birthday Birthday - For Her For Her / Birthday I was looking into Fuzzy Lookup as a way ...
1
vote
2answers
87 views

Formula to search highest value related to a near match reference

I have a list of neutral references which change as per the date so What I am looking for is a formula that will search Product and return the latest date. e.g., A B ...
0
votes
1answer
28 views

Excel Lookup for work sheet comparison

I have 3 sheets. The first one contains data for Shop A, the second data for Shop B, and the last sheet contains the results. Sheet A & B: Item Code, Name, Brand,and Stock I want to compare ...