good afternoon. I am creating a list of names. Next to each name is a cell showing how many that name is used. In another place on the same workpage I wish to show a "*" (star)for every time that name is used over 10 times. e.g. 11 times= * 12 times= ** etc. I am using this in EXCEL thanks..
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Stars if over 10 2
- Thread starter copeco
- Start date
-
2
- #2
If the number is in column B, then this formula will display a string of stars in column C when the number > 10:
(Copy the formula down the column for each row with a number used.)
Is that what you mean?
Code:
=IF(B2>10,REPT("*",B2-10),"")Is that what you mean?
- Thread starter
- #3
If you choose Insert/Function... from the menu (or click the "Paste Function" tool) you can select the category of Text functions and "look around" in the right-hand box (Function Name
for what's available.
Alternatively, you can look in the help file with the search word "repeat", select "repeating actions" when it is offered, and REPT will be one of the choices to explore. The help file isn't always as helpful as it should be, but I can usually find what I want after a few stabs.
for what's available.Alternatively, you can look in the help file with the search word "repeat", select "repeating actions" when it is offered, and REPT will be one of the choices to explore. The help file isn't always as helpful as it should be, but I can usually find what I want after a few stabs.
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question