hi all,
I want to calculate the data from the sheet "data 1", "data 2" and "data 3" at the same time (3 sheets should only have 1 sheet, because the row data is more than 500 thousand, it is divided into several sheets). From these 3 sheets I want to retrieve data from the "eff_date" column in all sheets, where the formula is to calculate the amount of data with the number "5" in the "BUCKET_FROM" column in all sheets divided by the total number of data in these columns per each date. please provide an efficient formula for this.
sample : attached
thank you,
Regard
Dolphino
Bookmarks