I am trying to extract tornado days from a large database. By entering the month, it goes and grabs the data and puts it into the table. It is fairly straightforward to grab the months, but I need to grab the days and years too. In some, cases they will be on the day of the month, but different year. In other cases, I might have 2 days in the same month and year. I have attached a spreadsheet with a desired results. It should be easy, but I am going blank on how to do this.
Jeff B
Still using Excel 2010??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
How aboutdragged down & acrossFormula:
Please Login or Register to view this content.
are you still using 2010 excel
if you have 365 version or 2021 with FILTER()
=FILTER(A2:C25,(A2:A25=H3))
need to think about the 2010 version
so this is just pulling a table based on the month = 5
in cell H3
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Try:
=INDEX(A:A,AGGREGATE(14,6,ROW($C$2:$C$50)/($A$2:$A$50=$H$3),$F6))
copied across and down.
loL. I'm slow today. Where did those other replies come from???
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks