Forum Discussion
trying to simplify a formula
Formula works if we have 1 in all cells in column B
Have no idea if they need for something else. If not, we could do bit other way. If to keep, don't merge cells - that's always bad idea - use Center across selection starting from C
Please check in attached
Here is a sample of what i am doing.
Your formula doesn't seem to work with it or I might be doing something wrong.
thank you. does it work around merged cells? I tried what you gave and it worked, then I added some more information and merged cells and it doesn't work now.
see attached file.
Formula works if we have 1 in all cells in column B
Have no idea if they need for something else. If not, we could do bit other way. If to keep, don't merge cells - that's always bad idea - use Center across selection starting from C
Please check in attached
- understood.
Thank you all for all your help. Your help has been greatly appreciated
