PDA

View Full Version : Solved: mergesheet with formula



slamet Harto
10-22-2010, 10:50 AM
Hi there,

Hope you are doing good.

Can you help me if I want to combine all sheets into 1 sheet using formula.
See the attached for your reference.

Thanks in advance.

mdmackillop
10-22-2010, 11:37 AM
Can you use MAX(A:A) in your formulae to get the indexing?

slamet Harto
10-22-2010, 06:49 PM
Hi Malcom

Thanks for reapons and would be appreciate it if you can show me how to do? I'm totally getting stuck.

thanks so much

mdmackillop
10-23-2010, 02:57 AM
Will you have more than two sheets? I think there are limits on what can be done.

slamet Harto
10-23-2010, 11:46 AM
yes, i agree with you. but can you advise me only for those (two) sheets. I really want to know how to use Max function to indexing the data.

Have a great day!

mdmackillop
10-23-2010, 03:55 PM
Something like this

slamet Harto
10-24-2010, 01:03 AM
hi malcom
thank you and appreciated it so much.