Forum Discussion
Excel formulas
I am trying to pull a row number that is associated with a student record into a formula in a second sheet. The names are alphabetical in one and by classroom in the other
madgateI wasn't able to download your sample for some reason...got a bunch of error and warning messages. but here finally is a quick example of a sortable list that should illustrate another possible solution. You can sort this by name OR by classroom....
There's a brief explanatory comment on the sheet
| Last Name | First Name | Teacher | Room | School ID | Family Total | Total Lunches September | Total Lunch Spent September | Total Milk | Total Milk Spent September | Total Family Spent September | Total Deposits September | Date Deposits September | End of Month Balance |
| Adgate | Mary | mccool | k0-2 | $10.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $10.00 | |||
| Adams | Amos | O'Reilly | K0-1 | $0.00 | 0 | $0.00 | 0 | $0.00 | $0.00 | $40.00 | Monday, June 3, 2019 | $40.00 | |
| Anderson | Drew | Griswald | 6-16 | $23.00 | 1 | $3.00 | 1 | $0.50 | $3.50 | $19.50 | |||
| Andrews | Owen | Barrows | K1-5 | $33.50 | 0 | $0.00 | 0 | $0.00 | $0.00 | $33.50 |