Your scenario is different. This easy-to-understand formulas set-up (a potent
Criteria - "Extract n Pack-it-up" pair) will extract the desired results w/o
the concatenation in a matter of seconds. Might appeal to you.

Source data in cols A & C, from row1 down
In D1: =IF(C1="","",IF(C1<=0,ROW(),""))
In E1: =IF(ROW()COUNT(D:D),"",INDEX(A:A,SMALL(D:D,ROW()) ))
Copy D1:E1 down to cover the max expected extent of source data, say down to
E100? Minimize col C. The results that you seek from col A will automatically
appear neatly packed up at the top in col E.

Col D = Criteria (devote your attention here to build-in all requirements)
Col E = Extract n Pack-it-up (standard)

Click YES below to celebrate ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---
"ADIB" wrote:
Thanks Max, i was looking for this formula
please give me solution if in col. c1,c4& c5 having value <=0 then i need
answer for all three it would be 1&4&5 can it possible.