Forum Discussion
Solved
Question related to Formulas of 3 sheet in Formula.xlsx workbook
Hello Everyone, In COURSE SHEET, there is a question - Q1 >>> How many have neither REGISTERED nor COMPLETED any of the 3 courses? Q2 >>> How many have REGISTERED or TRAINING in atleast 2 of t...
A 1 in the Select column indicates that this row is included in the set.
A 0 indicates that the row is not included.
The formula in D33 calculates the sum of all included shortages.
I started by entering 0 in all rows, then replaced them by 1 from the top, as described in my previous reply.
sir, what is SELECT column? And why we write SELECT column?
And how it will come 1 or 0?
like -
A 1 in the Select column indicates that this row is included in the set.
A 0 indicates that the row is not included.
The formula in D33 calculates the sum of all included shortages.
I started by entering 0 in all rows, then replaced them by 1 from the top, as described in my previous reply.
- Thank you so much sir😊😊