children

  1. Collington

    Creating a daily register based on a different worksheet

    Hey folks, Can you help me with a question for my school? We have children who attend breakfast club. On one sheet we list ALL the children and how many days that term will attend breakfast club (e.g. 5 Mondays, 6 Tuesdays) - this is so we can bill correctly. I want this to automatically...
  2. K

    Student Choice

    Hi, I am trying to make a process a little easier at the school I work in. 1 hour a week we have an enrichment time where different activities are offered to the children on a 6 week basis, they pick their preferences on a slip, then 2 staff members sift through all the slips and allocate them...
  3. B

    Best way to show data that can be drilled down?

    I have data that sort of looks like this 1 or many items -- > 0 or many children items ----> 0 or many children items ------> 0 or many children items --------> 0 or many children items In other words, the data is a hierarchical tree structure, where each brand has data needed. Some of these...
  4. B

    Excel stopped accepting array formula

    I'm not entirely sure how to explain this issue, so apologies if the title is confusing or misleading. I have a spreadsheet with a fairly large number of array formulas. Maybe there is a more efficient way of doing it but this is where I'm at for the moment. The formulas were working. However...
  5. B

    countif formula

    Hi I am struggling to get a countif / countifs formula to work for me. I need to count values in one column if they match a value in another column. Example below: <tbody> Age Mon Tues Wed Thurs 3 1 1 1 2 1 1 3 1 1 Total </tbody> So I need to know how many children age 2...
  6. M

    Modify text string with count, tokenizing and more user readable format

    Hello, I would like to ask for help with following problem. I have a list of strings in column A, from row 1 to row 3100, the text expresses a relation between Operators and Elements. Example: OR, Con1 SEQ, Con2 OR, Con3 PX, Con3 PX, Con2 OR, Con6 2xPX, Con6 PX, Con6 DD, Con1 SEQ...
  7. K

    Time Conversion Explanation

    Hello, I had a question about what a particular time conversion is called if it's called anything at all. Example: The formula I'm using is =((A2*60)+B2)/60 If your children did homework for 4 hours and 30 mins. That can be converted to 4.5 or 4.50 If your children watched TV for 1 hour and...
  8. M

    Copying Data from Specific Sheet of a Multiple Workbooks to Specific Sheet of a One Workbook

    Hello Folks, i need to copy datas from a specific sheet(Summary) of multiple workbooks in a folder to a specific sheet(Summary) of the parent workbook. I will run the macro from the parent file. I tried by best, it is beyond my basic knowledge. I leave it to you guys. My inputs: 1. Sheets name...
  9. Y

    New database

    am a beginner in access using access 2010, I am trying to build a database of our church, we are more than 500 families and total members are above 1330 persons. <!-- accessforums, first post, 728x90, green style --> <ins class="adsbygoogle" style="width: 728px; height: 90px; display...
  10. R

    Replacing one value to multiple values in rotations

    Hi I would like to replace one value with multiple values in rotation, In sheet 1, I have a value "DATA 10" in column A, row 2, 5, 7, 10, 15, 20, 23 and so on. How can i replace this value (DATA 10) with multiple values (10 LADY, 10 CHILDREN, 10 MAN and 10 HAZMAT) in rotation, so that row 2...
  11. A

    Multi-level Sum Rollup

    <tbody> Hello. I'm trying to write a formula that would achieve the values in the "Parent SUMs" column, but it's proving a bit of a challenge. Essentially, my goal is to sum all "children" or sub-level values under each "parent" (including the value that resides...
  12. M

    Show: "children" if value in cell is between 0 to 12...

    Hello, everyone. I looked all over the internet and found no solution to this issue. I want my cell to show a text depending on the value the previous one is showing. To be precise: Show: "children" if value in cell is between 0 to 12..., "adolescent" if value in cell is between 13 to 17 and...
  13. M

    autohide and auto-unhide rows based on a zero value in column a

    I have a spreadsheet that I would like to AUTO-HIDE, AND AUTO-UN-HIDE the row based if the Column 1 value in that Row s 0. I have 20 Rows dispersed throughout 100 rows I would like to do this with, so that A1=1, Row A will auto=unhide, but if I have A1=0(or not answered yet), Row A will be...
  14. A

    Changing view of data in the table

    Hello, example will show everything. I have table with parents and children, there is 1-8 children and I need to make from left table right table. Could you help me how?
  15. C

    How to find the type of VBA collection?

    Hello everyone! We know how to iterate a Range object because of Google (A range has "Cell" children). We know how to iterate an array of strings because of Google (It has "String" children). But how do we iterate something if we don't know the type of it's children? How do we find it out? I...
  16. C

    Choose a parent and return a list of bottom level children.

    I have a large flat hierarchy table. I am looking for a method to select a parent and return a list of my lowest level children. I am somewhat familiar with VBA but I don't know where to begin coding this. Thanks so much for any help I am able to receive on this. This has been a great learning...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top