Things to know before admitting your kids to school

Here are few things that you must know or take care of before admitting your kids to school. If you are not taking care of these things, you might be putting you children to wrong school, risking life. Only irresponsible parents do this mistake who all do not love their children or one who are not serious about their children or one who are uneducated. So, let me guide you to few thins that you need to take care of before admitting your children to school. 1. See if school is registered to local registerer (respective government). 2. Check the classroom, bathroom, playground, kitchen, it needs to be clean. 3. Sit in the classroom for 5 to 10 min., see how they lecture children. 4. Check the school fee, other fee, transportation fee, see if you can afford. 5. Check the food they fed to children, how many times, they give food to children. 6. Check the school duration, start and end time, usually for children 4 to 8 hours, see for how long your student can sit in class. 7. Ask for holida...

How to Remove Specific Columns and Rows from a Large Array in Excel

In Excel 365 with dynamic arrays, the "DROP" function is used to remove specified rows or columns from a range or array. It returns a new array with the specified rows or columns removed.

Syntax: DROP(array, num, [type])

Here, 

·        array: The array or range of cells to drop rows or columns from.

·      num: A number or an array of numbers indicating the row or column index to drop. If type is not specified, num specifies the row index to drop. If type is set to 1, num specifies the column index to drop.

·    [type]: Optional. A logical value that determines whether to drop rows or columns. Set to 0 or omitted to drop rows, set to 1 to drop columns.

Suppose you have a table of data in cells A1:E5, and you want to remove column A, and last two rows. You can use the following formula:

How to Remove Specific Columns and Rows from a Large Array in Excel

This formula will return a new array that excludes the last two rows and first column of the original range.

 

Popular posts from this blog

Top international payment gateway transaction fee comparison (2024)

How to Manage Boot Configuration of Windows using CMD

How to Get Inverse of a Matrix in Excel