Question about Microsoft Excel for PC

2 Answers

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 jacques876 on

Ad

2 Answers

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
  • 68 Answers

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

Ad

Anonymous

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 6 Answers

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

Ad

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

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 Answer

Forget lock code for nokia c6 how can i handle it.please help me


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
http://pcgadgetdeni.blogspot.com/2013/02/how-to-unlock-nokia-c6-00.html

Feb 19, 2013 | Nokia C6 Smartphone

1 Answer

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

1 Answer

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. avatar.php?gravatar_id=64f9af84f30ee30bdc64cb8c376fd3b8&rating=x&size=32&default=http%3a%2f%2fwww.yugatech.com%2fblog%2fwp-content%2fthemes%2fyugatech%2fimages%2fdefaultgravatar.jpg 99--> Claudette Chua replied on Feb 1st, 2010 at 10:13 am (99)
    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. avatar.php?gravatar_id=6f52c6aecc686ee867402be6d29b52e8&rating=x&size=32&default=http%3a%2f%2fwww.yugatech.com%2fblog%2fwp-content%2fthemes%2fyugatech%2fimages%2fdefaultgravatar.jpg 100--> Steve Nacion replied on Feb 1st, 2010 at 10:54 pm (100)
    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. avatar.php?gravatar_id=64f9af84f30ee30bdc64cb8c376fd3b8&rating=x&size=32&default=http%3a%2f%2fwww.yugatech.com%2fblog%2fwp-content%2fthemes%2fyugatech%2fimages%2fdefaultgravatar.jpg 101--> Claudette Chua replied on Feb 2nd, 2010 at 11:41 am (101)
    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

52 Answers

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

1 Answer

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...

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

129 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...