Question about Microsoft Excel for PC

# Hi, how do I find the 1st 2 letters in a cell and reference it to another. ie A1: 0209JJP001. I thus want to find "02" which is Feb (this would be a vlookup I assume). Therefore the 1st 2 letters represents the month of each unique number and last 3 the qty (not needed). My goal is to find how many in Feb, March etc. Many thanks, Jaq

Posted by on

### Anonymous

• Level 2:

An expert who has achieved level 2 by getting 100 points

MVP:

An expert that gotÂ 5 achievements.

Governor:

An expert whose answer gotÂ voted for 20 times.

Scholar:

An expert who has written 20 answers of more than 400 characters.

• Expert

To reference the first letters in a cell, use the left function. The syntax is =left(cell,#). So, to return the left two letters from cell A1, you use =left(a1,2). You can put that in a cell or incorporate it into some functions.

Posted on Jun 18, 2009

### Anonymous

• Level 1:

An expert who has achieved level 1.

Problem Solver:

An expert who has answered 5 questions.

• Contributor

It sounds like what you want to do is a conditional count of cells in a range that meet a certain criteria? If that is correct, you want to use the COUNTIF function, which will count values in a specified range based on a specified criteria.

The way the formula is structured is =COUNTIF(range, criteria)
=COUNTIF(A2:A7, "<=39845")

A2:A7 is the cell range
"<=39845" is less than or equal to 39845

39845 is also 2/1/2009

If you want to calculate values in a range you can do a simple SUM formula like:

=SUM(COUNTIF(B2:B33,"<=39872")-(COUNTIF(B2:B33,"<=39845")))

The logic is:
Count the number of values less than or equal to 39872 (2/28/09 - last day of Feb)
--then--
Subtract the number of values less than or equal to 39845 (2/1/09 - first day of Feb)
--
that leaves you the total number of values in February.

You may also want to look at using the Conditional Formatting command, which will allow you to apply color and bold to values that fall into or out of a specific range.

Posted on Jun 13, 2009

×

my-video-file.mp4

×

## Related Questions:

### I need to know the year of a Lennox Furnace Model #C33-24B-2F

Year is typically the 3rd and 4th numbers in the serial number. "5806g13456" would be 2006

If you need further help, reach me via phone at https://www.6ya.com/expert/thomas_092728000e6acb79

Feb 21, 2017 | Heating & Cooling

Tip

### Determining the Age of Your GE Appliance

This advice applies to all appliances manufactured by GE. Determining the manufactured date of most appliances is accomplished by looking at the SERIAL NUMBER. On GE appliances this is determined by the following method:

The manufactured date is determined by the 1st two letters of the serial number

Example: FY456789

1st Letter is the MONTH

A – JAN
D – FEB
F – MAR
G – APR
H – MAY
L – JUN
M – JUL
R – AUG
S – SEP
T – OCT
V – NOV
Z - DEC

2nd Letter is the YEAR

A – 1977, 1989, 2001, 2013
D – 1978, 1990, 2002, 2014
F – 1979, 1991, 2003, 2015
G – 1980, 1992, 2004, 2016
H – 1981, 1993, 2005, 2017
L – 1982, 1994, 2006, 2018
M – 1983, 1995, 2007, 2019
R – 1984, 1996, 2008, 2020
S – 1985, 1997, 2009, 2021
T – 1986, 1998, 2010, 2022
V – 1987, 1999, 2011, 2023
Z – 1988, 2000, 2012, 2024

NOTE: Some Kenmore appliances are manufactured by GE and will have the following prefixes in the MODEL number:

362, 363, 464

on Dec 05, 2009 | Washing Machines

Tip

### Determining the Age of Your Maytag Appliance

This advice applies to all appliances manufactured by Maytag. Determining the manufactured date of most appliances is accomplished by looking at the SERIAL NUMBER. On Maytag appliances this is determined by the following method:

The LAST two letters in the serial number identifies the date code.

Example: 123456FY

The 1st Letter is the YEAR.

A – 1978/2002
B – 1966/1990
C – 1979/2003
D – 1967/1991
E – 1980/2004
F – 1968/1992
G – 1981/2005
H – 1969/1993
J – 1982/2006
K – 1970/1994
L – 1983/2007
M – 1971/1995
N – 1984/2008
P – 1972/1996
Q – 1985/2009
R – 1973/1997
S – 1986/2010
T – 1974/1998
U – 1987/2011
V – 1975/1999
X – 1988/2012
Y – 1976/2000
Z – 1977/2001

The 2nd Letter is the MONTH

A – JAN
B – JAN
C – FEB
D – FEB
E – MAR
F – MAR
G – APR
H – APR
J – MAY
K – MAY
L – JUN
M – JUN
N – JUL
P – AUG
Q – JUL
R – SEP
S – AUG
T – OCT
U – SEP
V – NOV
W – OCT
X – DEC
Y – NOV
Z – DEC

NOTE: Some later model Maytag appliances are manufactured by Whirlpool. The serial numbers may be in a different format. Check the MODEL number for any of the following prefixes:

106, 110, 198, 562, 664, 665.

These prefixes indicate the manufacturer as Whirlpool.

on Dec 05, 2009 | Washing Machines

1 - Switch ON your phone without SIM Card, 2 - As if making a phone call, on your dial pad compose: #PW+UNLOCKCODE+1# * For Bell Canada NOKIA C6-00 Please 1st use #PW+UNLOCKCODE+5# * For Fido NOKIA C6-00 Please 1st use #PW+UNLOCKCODE+7# The letter P appear after press 3 times quickly the button star ( * ) The letter W appear after press 4 times quickly the button star ( * ) The letter + appear after press 2 times quickly the button star ( * ) 3-The phone will show "SIM Restriction Off" * NOKIA C6-00 has been unlocked now visit my blog for more complete tutorial this unlock

Feb 19, 2013 | Nokia C6 Smartphone

### SCX4824FN driver

Fixya doesn't have any drivers for any device, the only place to get the software is at the manufacturers support site, if they don't have the needed drivers to use Linux then it likely doesn't exist.

Feb 10, 2012 | Samsung SCX4824FN Mono All-in-One Laser...

Tip

### Determining the Age of Your GE Appliance

This advice applies to all appliances manufactured by GE. Determining the manufactured date of most appliances is accomplished by looking at the SERIAL NUMBER. On GE appliances this is determined by the following method:

The manufactured date is determined by the 1st two letters of the serial number

Example: FY456789

1st Letter is the MONTH

A – JAN
D – FEB
F – MAR
G – APR
H – MAY
L – JUN
M – JUL
R – AUG
S – SEP
T – OCT
V – NOV
Z - DEC

2nd Letter is the YEAR

A – 1977, 1989, 2001, 2013
D – 1978, 1990, 2002, 2014
F – 1979, 1991, 2003, 2015
G – 1980, 1992, 2004, 2016
H – 1981, 1993, 2005, 2017
L – 1982, 1994, 2006, 2018
M – 1983, 1995, 2007, 2019
R – 1984, 1996, 2008, 2020
S – 1985, 1997, 2009, 2021
T – 1986, 1998, 2010, 2022
V – 1987, 1999, 2011, 2023
Z – 1988, 2000, 2012, 2024

NOTE: Some Kenmore appliances are manufactured by GE and will have the following prefixes in the MODEL number:

362, 363, 464

on Sep 03, 2009 | GE Profile DPSB619ED Electric Dryer

Tip

### Determining the Age of Your Maytag Appliance

This advice applies to all appliances manufactured by Maytag. Determining the manufactured date of most appliances is accomplished by looking at the SERIAL NUMBER. On Maytag appliances this is determined by the following method:

The LAST two letters in the serial number identifies the date code.

Example: 123456FY

The 1st Letter is the YEAR.

A – 1978/2002
B – 1966/1990
C – 1979/2003
D – 1967/1991
E – 1980/2004
F – 1968/1992
G – 1981/2005
H – 1969/1993
J – 1982/2006
K – 1970/1994
L – 1983/2007
M – 1971/1995
N – 1984/2008
P – 1972/1996
Q – 1985/2009
R – 1973/1997
S – 1986/2010
T – 1974/1998
U – 1987/2011
V – 1975/1999
X – 1988/2012
Y – 1976/2000
Z – 1977/2001

The 2nd Letter is the MONTH

A – JAN
B – JAN
C – FEB
D – FEB
E – MAR
F – MAR
G – APR
H – APR
J – MAY
K – MAY
L – JUN
M – JUN
N – JUL
P – AUG
Q – JUL
R – SEP
S – AUG
T – OCT
U – SEP
V – NOV
W – OCT
X – DEC
Y – NOV
Z – DEC

NOTE: Some later model Maytag appliances are manufactured by Whirlpool. The serial numbers may be in a different format. Check the MODEL number for any of the following prefixes:

106, 110, 198, 562, 664, 665.

These prefixes indicate the manufacturer as Whirlpool.

on Sep 03, 2009 | Maytag MMV4205 Microwave Oven

### My new dell inspiron 1110 it seems that not in your list. my friend bought it in bremerhaven, germany & no warranty.

This may answer your question. The long wait is finally over! Dell will officially welcome the arrival of its award winning consumer brands here in the Philippines. And we want you to be part of this momentous event. We will celebrate the arrival of these products with a night of colors, action and entertainment on April 10, 2008 at the Prince of Jaipur at the Fort Bonifacio, Taguig City.

TO THE BOTTOM:
1. 99--> Claudette Chua replied on
Hi Guys,
We would like to introduce to you our company, Phil-Data Business Systems, Inc. We are a Dell Channel Partner and a Dell Authorized Service Provider (DASP) here in the Philippines. If you have any concerns about Dell Vostro, Latitude and XPS models (only), please call us at (02) 811-2878 or email us at [email protected] and we will be glad to assist you the best way we can. Thank you.
Our website is http://www.phildata.com
Thank you.
Phil-Data Sales and Marketing
2. 100--> Steve Nacion replied on
Hi Ms. Claudette …
do you also provide parts and service???
if in any case that a part needs to be replaced like platics, hinges, palmrest, MOBO … is there a way for you to get speceific parts for specific models???
3. 101--> Claudette Chua replied on
Sir Steve,
Yes, we do provide (Philippines) parts and service for the following:
1.) For units purchased from Phil-Data Business Systems, Inc. and was still covered by the warranty – Free of charge both parts and service.
2.) For units not purchased from Phil-Data but still covered by warranty – Free of charge on parts warranty but with labor charge.
3.) For units not purchased from Phil-Data and with no warranty – With charges both on service and parts.
Please note that we only provide parts and services on Dell Vostro, Latitude and XPS models only. We don’t cater to other Dell products such as Inspiron and others.
Thank you.
Hope this helps

Feb 15, 2010 | Dell Inspiron 1000 Notebook

### I need the call details of airtel prepaid no. 919959711982

Hi,
I want to know call detail of my airtel no. 9630885868
Plz sent it to me at
[email protected]

Jul 23, 2009 | Nokia 6300 Cell Phone

### N pleaseeed code for 5a01 20th feb

C & W -- 18/02/09
5C 01
00=0B-F2-52-72-4E-1B-86-90
01=83 61 00 3A FD F3 DC 0A

Telewest -- 29/01/08
5A 01
00= E7 D3 69 2E 6F 38 EA 78
01= A1 38 06 29 24 29 8D 2B

NTL -- 18/02/09
54 01
00= 5C 2C 26 36 CF 81 AB 66

Feb 20, 2009 | StarTech.com StarView SV211K 2-port KVM...

129 views

Level 3 Expert

Level 3 Expert