Search results

Hi, A colleague has asked me if there is a way, in Excel 2003, to extract data from a large report that has multiple entries .... i.e. show the order number and other relevant data for each line. I had initially used INDEX and MATCH in conjunction with the SMALL function in one tab, while in the...

Hi xld ,,,, thanks for the reply ,,, but after playing around some more I discovered that I had the formula back to front ( Doh! ) ... should be K5-C5>100 for it to work, but thanks for the reply, your reply is correct ..... see what happens when you take a couple of weeks off, brain becomes...

Hi guys, I have a small query. Is it possible to use Conditional Format to highlight a cell if the sum of that cell minus another cell is greater than 100 .... so, if the sum of C5-K5 is greater than 100 highlight RED. I've tried various things and none seem to work.

Hi guys, I've been looking for a simple macro ( or formatting if possible ) that will change the colour of cells within a worksheet when the value is changed .... this will need to encompass a large area of data, in addition I need to reset those changed cells to No Fill once all the updates...

Hi guys, little poser for you. If using a file that contains monthly data say starts at Jan and we wanted to colour a column every time a new month was added what is the best way to achieve this?

Managed to get it with a test password cracker which provides 3 letters of the password ,,, luckily the password had only 4 letters :-). Let's hope no-one else has a 123 file for conversion. Thanks

Hey Dan ,,,,, yeah , I wouldn't say 70's software ,, more like from the Triassic period. The only thing I need to look at in this file is the raw data , which is hidden in a second tab that is password protected. Why someone still has a file that's millions of years old I will never know ,,, lol.

Hi guys, i received a file from a colleague which is in Lotus 123 format ( I know ).... he has asked me to replicate the file in Excel ( welcome to the 21st Century )but the file is password protected and he does not know the password, as he didn't set it up. Is there a good password cracker for...

Hi Fabrice, Thanks for the update, your sample file is a huge help and will help me with more awesome Dashboard creations. Keep up the great work. Thanks

Hey guys ,,,, looked at the http://sourceforge.net/projects/sparklinesforxl/ sparklines add in for Excel 2003 .... I like both ( this one and TinyGraphs.exe ). Still looking to understand if it is possible to add a value into the start or at the end of a sparkline as Hui had mentioned (...

Hi Hui ,,, I have the TinyGraphs.exe add in, although looking at the suggested sourceforge.net from Vijay this looks good also ( little bit more detailed but will try it out ).