Weather: Raining

What should I wear? Rain Jacket

Weather: Sunny

Temperature: 80°F

What should I wear? T-Shirt

Weather: Sunny

Temperature: 90°F

What should I do? Go to the Beach

Weather: Sunny

Temperature: 80°F

What should I do? Go for a Run

Weather: Raining

What should I do?

= Equal To
> Greater Than
< Less Than
>= Greater Than or Equal To
<= Less Than or Equal To
<> Not Equal To
 Store # Units Sold Avg. Price Total Sales
Store 1 8,505 $10.34 $87,942 1 3
Store 2 3,753 10.83 40,645
Store 3 8,159 9.94 81,100
Store 4 9,103 10.01 91,121
Store 5 1,756 12.14 21,318
Store 6 4,712 11.71 55,178
Store 7 4,894 12.43 60,832
Store 8 2,932 10.01 29,349
Store 9 9,148 11.29 103,281
Store 10 Construction - 0
Store 11 3,081 11.51 35,462
Store 12 6,765 10.02 67,785
Store 13 8,336 11.93 99,448
Store 14 5,381 8.71 46,869
Store 15 Construction - 0
Store 16 4,270 11.73 50,087
Store 17 7,151 10.25 73,298
Store 18 3,061 9.60 29,386
Store 19 8,720 8.22 71,678
Store 20 5,676 8.08 45,862
Store 21 1,709 8.07 13,792
Store 22 3,226 10.50 33,873
Store 23 2,825 10.06 28,420
Store 24 7,857 10.04 78,884
Store 25 4,597 10.52 48,360
Store 26 Construction - 0
Store 27 1,506 10.27 15,467
Sum: $1,309,437
4
 #NAME?

ISBLANK 0
ISNUMBER 0
ISTEXT 0
ISERROR 1
Mixed Abbreviated Long
Arlington, Texas Boston, MA St. Louis, Missouri
Toledo, Ohio St. Louis, MO San Diego, California
Arlington, TX San Diego, CA Chandler, Arizona
Henderson, NV Chandler, AZ Arlington, Texas
Corpus Christi, TX Arlington, TX Corpus Christi, Texas
St. Louis, MO Corpus Christi, TX Santa Ana, California
Chula Vista, California Santa Ana, CA Colorado Springs, Colorado
Chicago, Illinois Colorado Springs, CO Corpus Christi, Texas
Colorado Springs, CO Corpus Christi, TX Toledo, Ohio
Santa Ana, California Toledo, Ohio Hialeah, Florida
Chandler, AZ Hialeah, FL Henderson, Nevada
Oakland, CA Henderson, NV Oakland, California
Chandler, Arizona Oakland, CA Ft. Worth, Texas
Hialeah, Florida Ft. Worth, TX Montgomery, Alabama
Scottsdale, AZ Montgomery, AL Scottsdale, Arizona
San Diego, California Scottsdale, AZ Chicago, Illinois
Corpus Christi, Texas Chicago, IL Chula Vista, California
Scottsdale, Arizona Chula Vista, CA New York, New York
Corpus Christi, Texas
St. Louis, Missouri
San Diego, CA
Chula Vista, CA
Oakland, California
Ft. Worth, Texas
Hialeah, FL
Montgomery, Alabama
Montgomery, AL
Santa Ana, CA
Colorado Springs, Colorado
Henderson, Nevada
Chicago, IL
Boston, MA
Ft. Worth, TX
Corpus Christi, TX
Toledo, Ohio
Lower (start) Proper (demo) TX Only (Substitute Demo) Using SEARCH
st. louis, missouri St. Louis, Missouri St. Louis, Missouri 0
san diego, california San Diego, California San Diego, California 0
chandler, arizona Chandler, Arizona Chandler, Arizona 0
arlington, texas Arlington, Texas Arlington, TX 1
corpus christi, texas Corpus Christi, Texas Corpus Christi, TX 1
santa ana, california Santa Ana, California Santa Ana, California 0
colorado springs, col Colorado Springs, Colorado Colorado Springs, Colorado 0
corpus christi, texas Corpus Christi, Texas Corpus Christi, TX 1
toledo, ohio Toledo, Ohio Toledo, Ohio 0
hialeah, florida Hialeah, Florida Hialeah, Florida 0
henderson, nevada Henderson, Nevada Henderson, Nevada 0
oakland, california Oakland, California Oakland, California 0
ft. worth, texas Ft. Worth, Texas Ft. Worth, TX 1
montgomery, alabamMontgomery, Alabama Montgomery, Alabama 0
scottsdale, arizona Scottsdale, Arizona Scottsdale, Arizona 0
chicago, illinois Chicago, Illinois Chicago, Illinois 0
chula vista, california Chula Vista, California Chula Vista, California 0
new york, new york New York, New York New York, New York 0

^ Can also demo UPPER and LOWER

Using SEARCH Units Sold by City Text to Columns TRIM
St. Louis, Missouri - 7811 St. Louis Missouri 7811
San Diego, California - 1072 San Diego California 1072
Chandler, Arizona - 9994 Chandler Arizona 9994
Arlington, Texas - 6758 Arlington Texas 6758
Buffalo, New York - 2960 Buffalo New York 2960
Santa Ana, California - 5702 Santa Ana California 5702
Colorado Springs, Colorado - 5562 Colorado Springs Colorado 5562
Corpus Christi, Texas - 3153 Corpus Christi Texas 3153
Toledo, Ohio - 7822 Toledo Ohio 7822
Hialeah, Florida - 8501 Hialeah Florida 8501
Henderson, Nevada - 4740 Henderson Nevada 4740
Oakland, California - 5291 Oakland California 5291
Ft. Worth, Texas - 4352 Ft. Worth Texas 4352
Montgomery, Alabama - 5793 Montgomery Alabama 5793
Scottsdale, Arizona - 6343 Scottsdale Arizona 6343
Chicago, Illinois - 1513 Chicago Illinois 1513
Chula Vista, California - 7295 Chula Vista California 7295
New York, New York - 9929 New York New York 9929
st. louis, missouri St. Louis, Missouri st. louis, missouri ST. LOUIS, MISSOURI
san diego, california San Diego, California san diego, california SAN DIEGO, CALIFORNIA
chandler, arizona Chandler, Arizona chandler, arizona CHANDLER, ARIZONA
arlington, texas Arlington, Texas arlington, texas ARLINGTON, TEXAS
corpus christi, texas Corpus Christi, Texas corpus christi, texas CORPUS CHRISTI, TEXAS
santa ana, california Santa Ana, California santa ana, california SANTA ANA, CALIFORNIA
colorado springs, colorado Colorado Springs, Colorado colorado springs, colorado COLORADO SPRINGS, COLORAD
corpus christi, texas Corpus Christi, Texas corpus christi, texas CORPUS CHRISTI, TEXAS
toledo, ohio Toledo, Ohio toledo, ohio TOLEDO, OHIO
hialeah, florida Hialeah, Florida hialeah, florida HIALEAH, FLORIDA
henderson, nevada Henderson, Nevada henderson, nevada HENDERSON, NEVADA
oakland, california Oakland, California oakland, california OAKLAND, CALIFORNIA
ft. worth, texas Ft. Worth, Texas ft. worth, texas FT. WORTH, TEXAS
montgomery, alabama Montgomery, Alabama montgomery, alabama MONTGOMERY, ALABAMA
scottsdale, arizona Scottsdale, Arizona scottsdale, arizona SCOTTSDALE, ARIZONA
chicago, illinois Chicago, Illinois chicago, illinois CHICAGO, ILLINOIS
chula vista, california Chula Vista, California chula vista, california CHULA VISTA, CALIFORNIA
new york, new york New York, New York new york, new york NEW YORK, NEW YORK
ST. LOUIS, MISSOURI
SAN DIEGO, CALIFORNIA
CHANDLER, ARIZONA
ARLINGTON, TEXAS
CORPUS CHRISTI, TEXAS
SANTA ANA, CALIFORNIA
COLORADO SPRINGS, COLORADO
CORPUS CHRISTI, TEXAS
TOLEDO, OHIO
HIALEAH, FLORIDA
HENDERSON, NEVADA
OAKLAND, CALIFORNIA
FT. WORTH, TEXAS
MONTGOMERY, ALABAMA
SCOTTSDALE, ARIZONA
CHICAGO, ILLINOIS
CHULA VISTA, CALIFORNIA
NEW YORK, NEW YORK
City Boston MA Boston MA
City St. Louis MO St. Louis MO
City San Diego CA San Diego CA
City Chandler AZ Chandler AZ
City Arlington TX Arlington TX
City Corpus ChrTX Corpus ChriTX
City Santa Ana CA Santa Ana CA
City Colorado SCO Colorado SCO
City Corpus ChrTX Corpus ChriTX
City Toledo OH Toledo OH
City Hialeah FL Hialeah FL
City Henderso NV HendersonNV
City Oakland CA Oakland CA
City Ft. Worth TX Ft. Worth TX
City MontgomeAL MontgomeAL
City Scottsdale AZ Scottsdale AZ
City Chicago IL Chicago IL
City Chula Vist CA Chula VistaCA
St. Louis, Missouri St. Louis, Missouri 0 698
San Diego, California San Diego, California 1 816
Chandler, Arizona Chandler, Arizona 0 498
Arlington, TX Arlington, Texas 0 981
Corpus Christi, TX Corpus Christi, Texas 0 557
Santa Ana, California Santa Ana, California 1 732
Colorado Springs, Colorado Colorado Springs, Colorado 0 464
Corpus Christi, TX Corpus Christi, Texas 0 622
Toledo, Ohio Toledo, Ohio 0 432
Hialeah, Florida Hialeah, Florida 0 209
Henderson, Nevada Henderson, Nevada 0 796
Oakland, California Oakland, California 1 560
Ft. Worth, TX Ft. Worth, Texas 0 725
Montgomery, Alabama Montgomery, Alabama 0 207
Scottsdale, Arizona Scottsdale, Arizona 0 266
Chicago, Illinois Chicago, Illinois 0 548
Chula Vista, California Chula Vista, California 1 487
New York, New York New York, New York 0 171

2595
 City State Units
St. Louis, Missouri - 7811
San Diego, California - 1072
Chandler, Arizona - 9994
Arlington, Texas - 6758
Buffalo, New York - 2960
Santa Ana, California - 5702
Colorado Springs, Colorado - 5562
Corpus Christi, Texas - 3153
Toledo, Ohio - 7822
Hialeah, Florida - 8501
Henderson, Nevada - 4740
Oakland, California - 5291
Ft. Worth, Texas - 4352
Montgomery, Alabama - 5793
Scottsdale, Arizona - 6343
Chicago, Illinois - 1513
Chula Vista, California - 7295
New York, New York - 9929