# Trim Class , Distance , Stakes .

#### Sunline

##### Well-known Member
Hello all ,

I am wanting to get some functions that can give me the results I have in cols B C and D

The asterix * must also appear in the results if mentioned in col A .

Many thanks .
Excel Workbook
ABCD
1Col AClassDistStakes
2WFA 1600m - \$200,000WFA1600200000
3OPN HCP 2000m - \$40,000OPN HCP200040000
4Rating 85 Benchmark 1400m - \$8,000Rating 85 Benchmark14008000
5Rating 65 Benchmark* 2200m - \$30,000Rating 65 Benchmark*220030000
6SP COND 1300m - \$150,000SP COND1300150000
73YOF SW 1200m - \$70,0003YOF SW120070000
8MDN 1400m - \$30,000MDN140030000
9OPN HCP 2500m - \$2,500,000OPN HCP25002500000
10Rating 65 Benchmark Fillies and Mares* 1400m - \$7,000Rating 65 Benchmark Fillies and Mares*14007000
Sheet1

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Try

#### Sunline

##### Well-known Member
Perfect again Momentman , 100% .
Exactly what i needed .
Thanks .

You are welcome

Replies
2
Views
207
Replies
4
Views
363

1,109,444
Messages
5,528,795
Members
409,835
Latest member
Mafu1267

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...