Search results

dear xld and hui many thanks for the suggessions.i wanted to use less of vba and formulae to count colours. i experimented with excel and found that if we assign values 1,2, and 3 to red,green and blue we can use conditional formating (excel 2003,2007,2010) to colour the cells bearing 1,2,3...

dear all if i have colours red,green and blue in five cells each from A1:A15 how do i count the respective colours.is it possible to convert the colours into rgb code and then use the rgb codes in count function. i am just speculating.thanks in advance. jay

thanks hui.wonderful and awesome.it works well. jay

dear luke congrats.keep it up. jay

dear all i would like to count the number of words in excel. is there a function which i can use. if i have to count in excel"this is a test" how do i do it.thanks in advance jay

thanks all will try and post jay

dear senthil is it possible to send some information on MOS certification and details about the course.many thanks. jay

thanks a lot to fashee,senthil and old chippy if we have used a single quotation mark and entered the number how do we take away the single quotation mark which appears before the number

dear all can anyone please help me with this problem? how to enter numbers as text straight away in excel. currently i input the number and use the formula =text(a1,"#")to convert the number to text. i want to enter the number straight as text. thanks in advance. jay

hi montrey nice post on index i cannot download the xl spreadsheet.could you please tell what i should do to down load it. when i click in the url link it takes to the speedyshare and then gives codes which when pasted does not downlaod the spreadsheet.thanks in advance. jay