Sorting the data

[Shi]

Hai Friends...

In my attached file I have a problem can You please anyone help me..

In "sort customer sheet"..
When I select the option "ALL" in "Month" drop down list, I want all the month of data from the above list items..

[martindwilson]

try
=IF(D2&E2&TEXT(A2,"yy")&IF('Sort-Customer'!$B$5="all","all",TEXT(A2,"mmm"))='Sort-Customer'!$B$2&'Sort-Customer'!$B$3&'Sort-Customer'!$B$4&IF('Sort-Customer'!$B$5="all","all",TEXT('Sort-Customer'!$B$5,"mmm")),ROW(),"")

[Shi]

Thank you friend..

If I add "All" in "Year" Combo box can you please tell the formula...

[Debraj Roy]

Hi Shri,

You have to use martindwilson's formula in

'2012-2013 Sheet ' at M2

Drag downward.. and check the result in Sort-Customer Sheet..

[Shi]

That I already done..

I have to use the same in year combo box also.. but above formula it's only in month combo box

Thanks.....

[martindwilson]

sorry your original question has been answered,what do you mean "year" you have no option for "all" in year

[Shi]

see the attachment....

[Shi]

Friends...

When I select "ALL" in year combo box, Is it possible to get the data..

Thanx....

[martindwilson]

=IF('Sort-Customer'!$B$4="all",IF(AND('Sort-Customer'!$B$2=D2,'Sort-Customer'!$B$3=E2),ROW(),""),IF(D2&E2&TEXT(A2,"yy")&TEXT(A2,"mmm")='Sort-Customer'!$B$2&'Sort-Customer'!$B$3&'Sort-Customer'!$B$4&'Sort-Customer'!$B$5,ROW(),""))
but how are you going to handle year changes?

[Shi]

Thank you...

But it wont works.. If I select Year as "ALL" then Month as "Sep" , then it has to display the data of 2012 & 2013 sep's details..

Then If I select the Year as "12" Month as "ALL" then It has to display 2012 year's all month data

[martindwilson]

thats not what you asked for you said if you select all in year then you want all data that meets the criteria in cells b2 &b3

[Shi]

Option :

1. If I select "ALL" in "YEAR", then I select "SEP" in "Month" Then it'l dispaly the cell b2 & b3 criteria's details.
Ans : 2012 & 2013's september month's A party's A1 product's details

2. If I select "12" in "YEAR", then I select "ALL" in "Month" Then it'l dispaly the cell b2 & b3 criteria's details.
Ans : 2012's all month's A party's A1product's details

Is it possible friend...