Create a criteria range by copying the range A1:I1 and pasting it in cell A44. Create conditions for Senior Accounting majors on row 45 and an OR condition for Junior Accounting majors in the respective cells on row 46
"I have completed the copying range A1:I11 and pasted to cell A44, but need urgent help for remaining part
Home Insert Drew Page Layout Formulas Data Review View Tell me Share Comments V TUT v Connections Properties Edit Links 21 0 Y 1 2 Sart Filter Clear & Reapply h Advanced Flash Fill EX Data Validation Text to Ramove Duplicates - Concelldate E Columns Hall Data from Refresh Picture All # xv fx all Group al Ungrouo Subtotal Analysis Tools F Data Analysis ? 2 Solvar Stocks Currencies Geography Get Dala what if Analysis L30 A E L L M N O P a R 5 1 w X 11 43501696 a 44815 181 5181 9 11282378 2378 10 66076816 6916 1596 12 55128275 8275 13 50305930 5930 14 92812678 2078 15 18507740 7740 16 34844410 4410 17 42681350 1350 18 48161142 1142 1989016650 6560 000 20 33864244 4244 21 43691928 1928 22 20219463 9463 23 51836743 6243 24 21212682 2582 25 23092790 2780 26 55854472 4472 27 99045951 5051 28 64596712 6712 29 94455099 5099 30 12787204 7204 31 47305021 5021 32 18058129 8129 33 90525704 3704 34 62496396 6306 3592975050 5950 36 22095477 5477 37 59309642 9642 38 60188653 8653 39 35430107 0187 40 G6228275 8275 41 36141293 1293 42 93036397 6307 43 44 Student ID Last 4 4 45 16 47 48 49 50 51 Info C Judy Tonya Craig Edna Paul Christina Timothy Kevin Rita Edith Willie Rodney Earl Veronica Angela June Dana willie Jesse Yolanda Angela Erica Debre Julie Diana Stephanie Jennifer Peter Bradley Jus Carolyn Fred Rhonda Bernard Joel Toward Anderson Thompson Garcia Rowe Schmidt Moss Wood Patterson Powell Heynolds Scott Rese Durcan Durns Hipnes Spencer Jam Lox Santiago Mcgen Silva Riley Oliver williams Hawkins Carroll Neal Cox Ferguson McDanie Sharp Patton Horton Mullins Junior Scnlos Junior Senior Senior Senior Senior Junior Freshman Junior Junior Sophomore Sophomare Senior Senior Sophomore Junior Junior Senior Freshman Junior Sophomore Sophumore Senior Junior Sophomore Junior Freshman Junior Senior Sani Freshman Freshman Sophomare Sophomore Freshman Economics Accounting Accounting History Marketing English Firance Chemistry Ecanomics Communications English Marketing Communications History Marketing Biology Chemistry Biolo Pre- Corrmunications History Bilo Biology Accountine English Biology Accounting Marketing Chemistry Communications Biology Prel Pralan Marketing Biology H 3.75 31.95 2.00 3.00 31.85 2.25 4.00 3.75 2.00 3.50 4.00 4.00 3.15 2.00 3.90 2.21 3.00 3.00 3.75 3.on 2.95 3.10 3.75 3.0 3.45 3.45 2.75 3.00 2.50 4.00 3.00 4.00 4.00 $4,000 $ $4,500 $3,000 $4,500 $4,500 $4,500 $4,500 $1,000 $3,000 $4,000 $4,000 $3,500 $3,500 $ $4,500 $4,500 $3,500 $4,000 $3,000 $3,000 $3,000 $4,000 $3,500 $3,500 $4,500 $3,000 $3,500 $3,500 $3,000 $4,000 $3,000 $3,000 $3,000 $3,500 $3,500 $3,000 C 4.00 Name Status Major Update GPA Tuition Students + Ready * PL + 100%
