# school

1. ### Search and return a match from a range with a string of text

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...
2. ### Copying rows into different 2 different spreadsheets based on 2 colums

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...
3. ### If-Statements, Multiple Stipulations to Create one Output

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...
4. ### Calculate row % by subgroup in pivot table

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...
5. ### Compare two means and calculate p value with pivot table

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...
6. ### Compare two means and calculate p value with pivot table

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]...
7. ### Pivot Table count records for a day

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...
8. ### VBA Consolidate Headers to 1 Column

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...
9. ### Stock generate in drop down list

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...
10. ### Rounding to nearest specified day

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...
11. ### how to split multi line cell contents of two column into separated rows in excel using VBA

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...
12. ### Drop down list dependent on contents on a cell located in another workbook

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...
13. ### Power Query. Merged 2 tables, but after renaming column name from 2nd table, expand column does not select this renamed column

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...
14. ### Conditional Formatting

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...
15. ### How to List all For Loop variables in a MsgBox?

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...
16. ### constructing a database for a school

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...
17. ### excel vba about sum up number of multiple words

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...
18. ### Charting Multiple Clusters on same graph

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...
19. ### Pupil allocation

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...
20. ### Is this possible with a formula? Or multiple formulas?

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

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

### Which adblocker are you using?

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

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