Hi David You should give us the actual expected result as your report amount does not tally with the AR Database. Why don't you just use a Pivot...
Hi Hava Your question is not very clear to me (maybe even to Clark and Anders). Do you want to translate the word automatically upon entry? Do you w...
Hi Julian Attached is the file with the macro. Please follow the instructioins below: 1) You still need to add the helper column with VLOOKUP. I...
Hi Julian I don't quite understand what you wanted. Option 1 : Maybe a VLOOKUP with a helper column? Option 2 : Or is it you actually wanted ...
Hi Rob Great to know that we could help. Thanks for your feedback. Happy New Year Sunny
Hi Troy Try this =LEFT(A2,SEARCH(" (",A2)-1) Sunny
Hi Rob I have no idea why your data was setup the way it was. It is far too complex for me to understand. I have rearranged your data into tabl...
Hi Troy Thanks for your feedback. We are glad to know you finally got it sorted out. Merry Christmas & A Happy New Year Sunny
Hi Troy Give this a try. I think the problem is because multiple words are found in the cells. E.g. Cash and Conventional both exist in cell ...
Hi lea Give this a try. Merry Christmas Sunny
Hi Lea Custom functions will definitely perform slower than Excel functions. I think 5 minutes is fair (fast enough for me) as the function need...
Hi Lea 1) Open my earlier attachment (Lea-Cohen-Fuzzy-Lookup.xlsm) together with your new file. 2) Press ALT-F11 to open the VBA window (refer d...
Hi Lea Thanks to Google Translate I am able to read what you have written What you need is a type of Fuzzy lookup. There is a free add-in avail...
Hi Willy Don't quite understand your question. What is it that you wanted to highlight? Can you show us the expected result from your attachment...
Hi Bryan See if this helps. 1) =SUMPRODUCT(--(A1:A7=B1:B7)*C1:C7) 2) Another version with the helper column similar to Frans solution is to u...