Bring data in another sheet without blanks between rows

[alexxl]

Hello guys i would like to bring data from other sheet without bringing blanks on rows.
My curent formula is conditioned by column d:d.

HidroElectrica_Raport solicitari_inbound_model_Bring data without blanks.xlsx

[etaf]

are you still using version 2010

if a later version then you can use the FILTER() function - like 365
=FILTER('Raport CRM Orange'!A:D,'Raport CRM Orange'!D:D="Raspuns in curs de procesare prin CRM")

I'll have to look into further if you are still on 2010 version

depending on country version , you may need to replace the , in the formula with ;

I have had a play and research and this formula for versions without filter should work - not sure if works in 2010 ,
=IFERROR(INDEX('Raport CRM Orange'!A$2:A$10000,SMALL(IF('Raport CRM Orange'!$D$2:$D$10000="Raspuns in curs de procesare prin CRM",ROW(A$2:A$10000)),ROW(1:1))-1,1),"")
needs control shift enter used to enter as an array
and then you get {} around the formula

added to the sample sheet

you do need to update your profile if NOT 2010 version as later versions of excel now have a LOT of additional functions to simplify some of this type of function

[Glenn Kennedy]

You can use an ordinary formula (just ENTER):

=IFERROR(INDEX('Raport CRM Orange'!A:A,AGGREGATE(15,6,ROW('Raport CRM Orange'!$D$2:$D$1500)/('Raport CRM Orange'!$D$2:$D$1500="Raspuns in curs de procesare prin CRM"),ROWS(A$2:A2))),"")

in A2, copied across and down. See file. Try to adhere to forum guidlelines about sample files (10-20 rows maximum).