Hello, I have some data in the spreadsheet,...

(Brian Tanutama Z) #1


I have some data in the spreadsheet, this data is come from “filter” formula (so when one coloumn in book A meet the condition, this row will be copied to this book)

the problem is from more than 5 rows in the spreadsheet, it just shown 2 rows?

why this happened?

Thank you.

(Aleksi Alkio) #2

Check your key column’s values. You have probably the same key column’s value more than once.

(Brian Tanutama Z) #3

work like magic. thank you very much for your help

(Aleksi Alkio) #4

You’re welcome