Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel - formula
Thanks for your help, but unfortunatly my problems got a lot biggger and i think that won't be able to solve it so easaly now. I have a large excel sheet with 5 or more tabs. and the cells contain a numeric value and also a specific backgroundcolor ( there are up to 5 different colors). from a...- Nacean
- Post #5
- Forum: Microsoft: Office
-
Excel - formula
One thing i've forgot to tell, that could be significant: the characters are allways positioned at the end of the numbers and the char is allway a star (*).- Nacean
- Post #2
- Forum: Microsoft: Office
-
Excel - formula
Hey, I have a question, i want to calculate the maximun of an amount of cells. But here is the tricky part: a few numbers have a character in it. Now i want excel to ingnore that character? example: "20", "25", "35", "55*" the maximum should be "55*" but excel gives "35"??- Nacean
- Thread
- Replies: 6
- Forum: Microsoft: Office
