Ok so i have this formula in excel, it works but the issue is that i want obly 1 row, not all the rows to show.
So I want to see if the country Spain in cell A2, exist in sheet Details, to look the data in sheet Details column J and only return "finalized" or "in progress". So if I have 1 cell that has In progress, it returns this, if all cells are with finalized to return finalized. Right now it returns all the rows for this country and returns the value.
=IF('Details'!A2:A1000=A2, IF('Details'!J2:J1000="In progress", "In progress", "Finalized"),"")
So is there a way with a formula to group the data. I guess I coyld do in VBA but really a unexpert in VBa, I understand the language, I am not able to write it.
So I want to see if the country Spain in cell A2, exist in sheet Details, to look the data in sheet Details column J and only return "finalized" or "in progress". So if I have 1 cell that has In progress, it returns this, if all cells are with finalized to return finalized. Right now it returns all the rows for this country and returns the value.
=IF('Details'!A2:A1000=A2, IF('Details'!J2:J1000="In progress", "In progress", "Finalized"),"")
So is there a way with a formula to group the data. I guess I coyld do in VBA but really a unexpert in VBa, I understand the language, I am not able to write it.