array formula

  • Thread starter Thread starter wolfgang
  • Start date Start date
W

wolfgang

i have a range named "Entries" it is data in table format
on another sheet formatted exactly the same with the same
column headings in the aforementioned range name, i need
an array formula that can return all of the entries in
the table that are in the month of january. in the
range "entries", the date of the entry is in column B.
TIA
 
not quite sure what you are saying but
=sumproduct((month(a2:a200)=1)*(whateverelse))
 
perhaps i was not too clear as to what i was trying to
accomplish. i am not sure what "whatever" means, but
what i have is sheet1, with all the entries for the
entire year in a table, the date is in column B.
on sheet "Jan" i want to show all the entries that
occured in the month of january. i am not too familiar
with the SUMPRODUCT function. i know i could just copy
the range and use auto filtering, but this application
has lots of macros and userfors for the data entry and
i'd much rather use a formula if possible. Thanks
 
One possible solution

=INDEX(Entries,SMALL(IF((MONTH(INDEX(Entries,,1))=1)*ISNUMBER(INDEX(Entries,
,1)),ROW(Entries)),ROW(1:1)),2)

entered with ctrl + shift & enter

copy down until you get a #num error
 
Back
Top