Search results

Hi Lohith, You've lost me a bit on this. I've pasted the above into a module in the workbook, but can you confirm the formula to use in the worksheet, please? Thanks, KJT

Hi, Yes that's true. However, the range of groupings should be such that, taking wildcards into account, a value should not occur twice. In your example, 1?? 45678 and 123 45??? would (should) not both exist in the range, as they would both hold true for the value 123 45678. Put another way...

Hi, Thanks for that, Narayan. However, that will only work where the wildcard characters occupy the 6th and 7th positions in the account code strings in the List. What I was hoping to achieve was a way of recognising a match, if applicable, wherever the wildcards may be (they are different...

Hi, Yes, using your example, I want to be able to look up a number of values including the value "123 51100" in the range A4:A400, but the specific value "123 51100" will not be in that range. Instead, the value "123 5??00" will be in that range. Ideally therefore I want the lookup formula...

Hi all, Looking for some help with the following, please: I have a set of accounts in Excel where certain account codes are grouped (using SUMIFS) in various departments, and I need to be able to check whether all account codes in a Trial Balance have been mapped to the appropriate groupings...

Luke, Not any more, unfortunately. Isn't progress great! Narayan, Genius - I can definitely use that! Many thanks for all your help with this. Regards, Kev

Hi Luke, I like the idea, but I guess I would only be able to use it as a straight "line". Ideally I need to be able to copy the format to elbows and curved lines as well, to give me line functionality and connectivity. See updated: http://dl.dropbox.com/u/78882458/striped%20lines.xlsx...

Hi Narayan, Have a look at: https://www.dropbox.com/sh/4pry430liysepl8/_0e65wieQd/striped%20lines.xlsx The line to the left is per your alternative method The second "line" (connected to another shape at each end) is the sort of thing I'm trying to achieve, but is made up of two separate...

Hi Narayan, Yes, but not really come up with anything meaningful so far. Thanks anyway. Kev

Hi Narayan, Thanks for you help with this. I'm a bit puzzled by your first comment, though, about setting my original approach as a default line, as it involves inserting 2 separate lines placed one on top of the other. I can't see how I could combine these 2 into one default line. Am I...

Hi, I tend to use Excel for drawing all sorts of flowcharts, organisational charts etc, due to familiarity. I am now trying to use it to produce a wiring diagram in which the colour of each wire is correctly displayed. This is no problem, until it comes to tackling 2-colour wires (eg yellow &...