Formula help

b777rky

New Member
Joined
Oct 25, 2018
Messages
1
Hello,

Let s say we have this columns and rows
1. A. B. C. D.
2. Name. 01.04.2018. 03.04.2018 2
3. Name. 05.04.2018 10.04.2018 5

This is the Main Page on my worksheet.
My questions is, i need to sort all period only 'month' and all names from that period i want must be în other Sheet , how to do that? Tried with vlookup.. Index&match but no luck.
If you could tell me please... I can t sort...because i have another criteria for sort:(
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
If you do not know Pivot Tables, try to learn the basics of Pivot Tables, watch a short video on Youtube. If you create a Pivot Table, you may choose to show column A and Group B by months as a Filter or Rows in a Table. It can be done in minutes, but you need to discover the wonders of the pivot tables. I hope it helps!
 
Upvote 0

Forum statistics

Threads
1,223,098
Messages
6,170,103
Members
452,302
Latest member
TaMere

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
Back
Top