- Hot Topics
Excel Excel Formula
Hi, I am a novice to excel. I have provided some mock information below, column A the Grade, B the score, I have calculated the column C using this function =IF(B2:B100>A2:A100,"Exceeding",IF(B2:B100 However, my issue is that I need to display the data in column C on a separate sheet. I cannot have it displayed on this sheet next to column B as the data is extensive in reality and this column will confuse the users. So my question is what formula do I need so that I can generate the column C information in sheet 2. Hope this is clear. Thanks A B C Grade Score 1 3 Exceeding 1 1 At 1 1 At 2 1 Below 2 2 At 1 0 Below
This question generated 20 answers. To proceed to the answers, click here.
This thread is current as of June 17, 2014.
For more resources for Microsoft Excel:
This article includes the following tags:
- Microsoft Excel