Search and Display

[jacknjob]

I am trying to generate the Results page from the Database page. Anyone can help to point out how do I do that?

* Take note the Results Page is manual display of what I want it to look like, I have no idea how to make it look like this using formula.

[Bryan Hessey]

I am trying to generate the Results page from the Database page. Anyone can help to point out how do I do that?

* Take note the Results Page is manual display of what I want it to look like, I have no idea how to make it look like this using formula.

Hi,

In Results insert a new column B and in B2 put

=IF(A2<>"",A2,B1)

and formula fill that as far as required. You can then hide column B if required.

In the new cell D2 (Jan, Alan) put

=SUMPRODUCT(--(Database!$A$2:$A$65536=$B2)*(--(Database!$B$2:$B$65536=$C2)*(Database!C$2:C$65536)))

and adjust the 65536 to your required range, then formula fill down and across as required.

hth
---

[jacknjob]

Hi Bryan,

Thanks but sumproduct is not what I am looking for...

I have difficulties generating the "Results" Page - as in whole page, not just the formula column because:-

1.) I do not know how many Owners will Database have.
2.) I do not know how many Cost Type the owners have.

This problem is more towards dynamic display of result rows.

Thanks for sumproduct anyway, it will come in handy when someone crack both the problems above

Regards,
Jack

[Bryan Hessey]

Hi Bryan,

Thanks but sumproduct is not what I am looking for...

I have difficulties generating the "Results" Page - as in whole page, not just the formula column because:-

1.) I do not know how many Owners will Database have.
2.) I do not know how many Cost Type the owners have.

This problem is more towards dynamic display of result rows.

Thanks for sumproduct anyway, it will come in handy when someone crack both the problems above

Regards,
Jack

so why would that affect the formula shown?


or did you mearly want a sorted representation of the Database sheet?



--

[jacknjob]

Hi Bryan,

Sorry if I didn't make myself clear. I sorta change the Result Page to reflect more accurately of what I am looking for. Look at the input column, I want the Results to change according to what my inputs are.

You will notice if I input different Owner names, it will reuslt in multiple dynamic rows, which I don't know how to get that done.