What if excel 2011

You should upgrade or use an alternative browser. Joined Jun 11, Messages 2. Hi everyone, I am trying to analyse a large amount of data. My issue is that each three letter prefix in column A is an individual. The numbers after that are accounting generated codes. Column B shows how many of a particular product they bought. Excel Facts. Lock one reference in a formula. Click here to reveal answer. Need 1 part of a formula to always point to the same range?

Weazel Well-known Member. Joined Dec 24, Messages 3, If you'd like to know more, contact us or watch Solver. How does the Solver engine talk to Excel, if it runs as a separate application? Solver uses Apple's new Scripting Bridge technology to "talk to" Excel. Excel exposes an object model through Scripting Bridge, that Solver can access. Scripting Bridge is generally faster than AppleScript. But since it crosses process boundaries, it cannot be as fast as a computational add-in running inside the Excel process.

The most important consequence is that it's possible -- but certainly not advisable -- to make changes in Excel or your workbook while the Solver engine is solving your problem. Because Solver is trying to talk to Excel at the same time, the results will be unpredictable -- including crashes in Solver or Excel.

The important message is: Don't make changes yourself in Excel or your workbook while Solver is solving. Free Trial. Search form X. Contact Us Login. Live Chat Help Desk. To cover the case in which the data cell does not contain either A or B or 0 , use these formulas in B1 and C1 :. If you can guarantee that A1 contains either A or B or 0 , then you don't need a complex If structure. You can use:. Thank you so much Gary and Chip, you rock!

I found out that if I keep the formula the same for both cells then I get a different result which is what I want. Why does this happen, I have no idea. Sign up to join this community. The best answers are voted up and rise to the top.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Ask Question. Asked 6 years, 4 months ago. Active 6 years, 4 months ago. Viewed 2k times. Improve this question. Gary's Student