SOLVED

# i need a formula to bring all the data informations to summary sheet based on the date

Copper Contributor

# i need a formula to bring all the data informations to summary sheet based on the date

HI ,

i need help to write a formula to get my worksheet done.

there are two sheets in my worksheet "Day Production" and "Summary" I need to get all the information to the summary sheet which I entered into the day production sheet based on the given date at the top.

I've attached my worksheet. can anyone write a formula in the attachment itself?

10 Replies

# Re: i need a formula to bring all the data informations to summary sheet based on the date

I miss the expected output.

best response confirmed by RavinduEB (Copper Contributor)
Solution

# Re: i need a formula to bring all the data informations to summary sheet based on the date

See if you can use this as starting point.

# Re: i need a formula to bring all the data informations to summary sheet based on the date

@HansVogelaar this is perfecta. thank you for the update. but I can't edit your formula

# Re: i need a formula to bring all the data informations to summary sheet based on the date

and can I use the same table format? because I need to add slicers

# Re: i need a formula to bring all the data informations to summary sheet based on the date

can i use this under table format? i need to add slicers

# Re: i need a formula to bring all the data informations to summary sheet based on the date

Unfortunately, you cannot use this formula in a table, it would cause a @#SPILL! error

# Re: i need a formula to bring all the data informations to summary sheet based on the date

Are any other alternative formulas with you?

# Re: i need a formula to bring all the data informations to summary sheet based on the date

The problem is that the result will have a variable number of rows. A table cannot expand or shrink automatically to accommodate those rows.

# Re: i need a formula to bring all the data informations to summary sheet based on the date

Yes. got it. thank you
1 best response

Accepted Solutions
best response confirmed by RavinduEB (Copper Contributor)
Solution

# Re: i need a formula to bring all the data informations to summary sheet based on the date

See if you can use this as starting point.