children

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

<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...

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...

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...

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?

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...

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...