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<A2:A100,"Below",IF(B2:B100=A2:A100,"At")))
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
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<A2:A100,"Below",IF(B2:B100=A2:A100,"At")))
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