I created a table and pasted a flawed formula in one of the cells in the top row. Now every time I add a row the flawed formula is replicated in the corresponding cell. I can edit it each time, but that obviously is not an optimal solution. Can anyone advise how to alter the formula so it will be created correctly?
Have you considered converting the table to a range and then fixing the formula. Once the formula is fixed, convert the range back to a table.
These links might help http://office.microsoft.com/en-us/ex...010067555.aspx
http://www.cedarville.edu/help/Excel...an-Excel-Table
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Interesting! I will let you know how it turns out!!!
Worked perfect, thank-you!
Last edited by brucemc777; 05-10-2014 at 04:01 PM.
Glad it worked. Thanks for the Rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks