Hello everyone , i have a little problem i dont know how to show the first record which returns "1" for each year, in situation below the answer should be 4 and 8, the rest shouldnt be visible.How could i do that?
1 2013 0
2 2013 0
3 2013 0
4 2013 1
5 2013 1
6 2013 0
7 2014 0
8 2014 1
9 2014 1
Array Enter:and drag down.Formula:
Please Login or Register to view this content.
An array entered formula is committed with Ctrl-Shift-Enter rather than just Enter
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
To remove errors:Formula:Please Login or Register to view this content.
Welcome to the forum.
Trevor's assumed that the first column you showed (1 to 9) were just row numbers, with 2013/2014 in column A and the 0s/1s in column B.
I'd assumed different, that your 1-9 are in column A with the 2013/14 in B and 0/1 in C, in which case use this (wrapping Index round his formula):
Formula:Please Login or Register to view this content.
or, removing the errors,
Formula:Please Login or Register to view this content.
They're still array formulae, entered with Ctrl-Shift-Enter.
Hope that helps, if my assumption's correct - if not, please ignore me and go with Trevor's answer!
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Guessing that should beFormula:Please Login or Register to view this content.
Yes, that works too, since the returned value is in the first column - probably simpler to understand tooOriginally Posted by TMS
.
Here is a regular one
Formula:Please Login or Register to view this content.
v A B C 1 2013 0 4 2 2013 0 8 3 2013 0 4 2013 1 5 2013 1 6 2013 0 7 2014 0 8 2014 1 9 2014 1
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
martis941 will the years always be increments of 1 ... ie is it possible the next year could be 2016 or 2017?
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks