If Excel does not have a function you require to complete a task I can make a custom one for you. This will allow you to drastically increase the type of data manipulation you can do with Excel. Allowing you to use it by simply typing "=CustomFunctionName(Parameter1, Parameter2,...........)".
With one gig you can include a request for up to three formula which use Excels built in functions (eg. SUM(), COUNT(), VLOOKUP(), MATCH(). and many many more) or a request for one custom built function to be created.
Message me if you are unsure about what you require and I will help you choose the best option.