school

Hi, I need to search for a match between a range of text and strings of data in a table. If a match is found then I wish to return that match into the next column. I have tried this formula =IF(ISNUMBER(SEARCH(Schools,[@Tags])),Schools,"") but it will only return data for cells on the same...

Hi First post so hopefully I can give enough information for someone to help me :) Im trying to set up a spreadsheet that will allow a colleague to enter information on the MASTER that will then feed into other sheets. The below a copy from the master sheet...… <tbody> <tbody> Date...

I have a reference chart that has many columns with many rows of information i have created a formula to read the chart and output an answer based on what it reads, but after further review I need the output to have one more stipulation...

How do I calculate row percentage by subgroup within a pivot table? <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="58"><col width="152"><col width="112"><col...

Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <tbody> #d9d9d9[/URL] "] #d9d9d9[/URL] "]s_male #d9d9d9[/URL] "]Values #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #d9d9d9[/URL] "] #666666[/URL] , align: right"]0...

Hi, I've built this table: <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style> <colgroup><col style="width: 178px"><col width="171"><col width="152"><col width="112"><col width="171"><col width="152"><col width="112"></colgroup><tbody> #d9d9d9[/URL] "] #d9d9d9[/URL]...

I have a table which has one row for every school student who is absent for a day. It shows the date, what school year they are in and their gender. I have also on each row, the "number of students" for that school year and gender. In the pivot table I need to show the absent %. I can easily...

Good afternoon, I have data that is pulled from a program that has different headers but those headers are alike. For example Bereavement Immed and Bereave Near Relativ they are one in same. I need to sum and consolidate those to 1 field. Personal w/Approval and Personal W/OApproval are one in...

Hi Good evening, I am always happy to get your magical solutions for challenging questions... I am working in a excel which contains school bag, travel bag & lunch bag inward informations as below.. <tbody> s no date bag description rate qty total value selling price 1 01/12/2018...

Hi, I've a bunch of school term dates, and each school has their own method of stating what is the first day or last day of the month (some will say the day before is the first day, some will say the day after, some will say the last week day, etc) & to allow me to better compare i want to be...

Hi All, I'm Currently facing issue in splitting my Multi-Line cell contents into separate Rows in excel VBA. I tried searching in Internet the solution which i could find is for only one column Multi-line cell, i have two column multi line cell and i want to split the same. For more clarity I...

Hello, I've been googling extensively to try and find a solution to my problem without success. Perhaps someone here can help me. I have a worksheet in Workbook1 that I would like to create a drop down list dependent on specific contents located in Workbook2. Workbook2 is referenced by other...

Hi, I have two tables, Table 1 and Table 2. <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> INDEX Sex Age 0 M 10 1 F 10 2 M 12 </tbody> <colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> INDEX Name...

Hello to you all and weekend wishes. I am devising a Gantt Chart for flying school and ground school. in one row I have the number 18 in certain cells and this represents cadets in ground school in the row beneath I have cells that have 18 in and this determines cadets in flight school and then...

Hi all, I am just starting my VBA journey and am 4 weeks into a class to learn it. I'm trying to show the entire list of variables in the For Next Loop in a message box, a la: 1 School MASCOT 2 School MASCOT 3 School MASCOT ... But I can only get it to show the last school in the loop...

I’m still working on my workbook for the school I oversee. Iam looking for some more help though as I’ve hit an end to what I know and I’mlooking for ways I can make the operations easier for whoever comes in nextafter me. So far I have multiple spreadsheets, adobe, and word documents that Imake...

Hi, How do i write a code to count total of "blue" and "red" in each school? The sum of blue and red have to be written at the cell next to the school. Colors other than blue and red are ignored. The rows in each school is inconsistent. <tbody> AB School 4 Blue Blue Red Red CD...

Hello, I don't have much experience with charts in excel and I'm not sure how to build this chart I want with my data set. Below is a sample of the data: <colgroup><col><col><col><col><col></colgroup><tbody> School ID Grade Level Size $ Per Pupil Poverty Level 2010 High School Medium...

Hi all, A Change of job has left me not using excel for a number of years so just after a pointer to get me in the right direction to help a school out. So I have a list of 90 pupils that are joining from another school. Each pupil has been allowed to name 3 friends they would like to be...

Hello, Thanks in advance for your help. I am wondering if this is possible to do. Currently I have a master worksheet with many student names and information about the student. What I need to do is calculate the amount of commission we receive based off the tuition amount and other factors...