Last dates from special range

tulls

New Member
Joined
Jun 10, 2015
Messages
3
Hi people.
I waste about 5 hours with this problem. I try functions as INDEX, MATCH, SMALL, etc. etc. etc. :mad: but unsuccessfully

I need sort a few last dates in column H from column B, but range are only cells with letter E in column E.

Please, please, please for your help! THANK YOU!!!!!!!


eBE9jGd.png
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

tulls

New Member
Joined
Jun 10, 2015
Messages
3
PCL, thanks for your quick reply!
I'm not sure, that Pivot table is right. But is possible that i wrong. :)

I have more sheets with more dates. And I want something as Client card, with last dates of communicate, phones, mails, etc. When I write name of firm in cell A1 , I want see all this dates from all sheets. I hope, that you understand me. :)

So, is Pivot table right solution? If yes, I like try it.

4zFB2uj.png
 

AhoyNC

Well-known Member
Joined
Oct 10, 2011
Messages
4,723
Office Version
  1. 365
Platform
  1. Windows
Pivot table is the easy way, but here is a formula.

Formula below is an array formula and must be entered with CTRL-SHIFT-ENTER.
Copy down column as needed. Change ranges to match your data if needed.

Code:
=IFERROR(INDEX($B$2:$B$13,SMALL(IF($C$2:$C$13=$G$6,ROW($B$2:$B$13)-ROW($B$2)+1),ROWS($B$2:B2))),"")
 

PCL

Well-known Member
Joined
Jul 15, 2008
Messages
1,348
Pivot table can work but if you want to review the data through several sheets it will be more difficult and certainly is needed a macro.
Does data always in the same column for each sheet?
What do you want to show when there is duplicate?
 

tulls

New Member
Joined
Jun 10, 2015
Messages
3
Thanks guys.
AhoyNC, thank you but this formula, isn't right for me. I know, my mistake, I didn't write that data aren't on same sheet.

PCL, thank you for your interest.

This is sheet1 with dates about orders
TzIOgOr.png


This is sheet2 with informations about client.
gcOX9Ow.png


And I want all dates and infos on CLIENT CARD. It means something as easy CRM.
And to second question: If is duplicate, i need see all dates.

If is here some PREMIUM section, please let me know. I realize, that it is complicated, so I like something pay.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,307
Messages
5,600,869
Members
414,411
Latest member
Snowmanaus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top