[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
Solved

# Choose Year

Posted on 2014-01-24
Medium Priority
237 Views
Hi,

In the attached ss can you look at tab "Sales" and column L

I am trying to pick the year from Column A

Can i use a choose formula like i did in Column I?

Many thanks
Seamus
The-howl-sales.xlsx
0
Question by:Seamus2626
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 35

Accepted Solution

mvidas earned 2000 total points
ID: 39807032
Hi Seamus,

You can use CHOOSE in column L like you do column I, but I don't know what you'd get out of it. You'd have to subtract the year below the smallest year, so the first year would result in a 1. For example, to make the years use the last two digits in word format, you could use
=CHOOSE(YEAR(A2)-2011,"Twelve","Thirteen","Fourteen")
But I don't know why you'd ever want to do that.

For column L just use =YEAR(A2) and put the number format as General. Then your autofilter can easily filter by year.

Matt

EDIT: Brief explanation of choose. CHOOSE uses a numeric result between 1 and 254 to return a result. So if A2 had a number between 1 and 254, you could use
=CHOOSE(A2,"result if one","result if two","result if three",etc). That is why you use it for column I, because the WEEKDAY formula returns 1-7.
0

Author Closing Comment

ID: 39807041
Perfect Matt,

For column L just use =YEAR(A2) and put the number format as General. Then your autofilter can easily filter by year.

Is what i was looking for

Thanks!
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
###### Suggested Courses
Course of the Month13 days, 12 hours left to enroll