| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting with a formula
what do you mean array-enter it? How do you do this?
"Bob Phillips" wrote: Did you array-enter it? -- HTH Bob Phillips (remove nothere from email address if mailing direct) " wrote in message ... I am just getting "#VALUE", and am not getting the cell to change. When I go to fx at the top it shows the value of 7 as I expected, but it does not show in the cell. It asks whether it is an array or a reference. "Bob Phillips" wrote: You could use a formula of =INDEX($E$2:$E$200,MATCH(J2&K2,$A$2:$A$200&$B$2:$B $200,0)) which is an array formula, committed with Ctrl-Shift-Enter -- HTH Bob Phillips (remove nothere from email address if mailing direct) " wrote in message ... I am a teacher working with EXCEL. I have a list - 3 classes each alphabetical, but not with final grades. I want a list - 1 list with grade and then alphabetical listing. I am trying to set this up before the final grades are list (and subject to change). The original list has last name (A), first name (B), student ID (C), class 9 thru 12 (D), and I want to put the average in (E). I am copying CTRL-C and CTRL-V from A-D and moving to G-J and then I tried in cell K3 the formula =E3 and dragged that down thru the column. When I sorted G thru K based on J and A and B the K column stayed in the same order while the other columns sorted. How do I get the K column to 'sort' like the other (I) columns did? I tried the idea of putting a '$' on the number part of the formula, but I know that will not drag down. Instead of =E3, I made it =E$3, and that one moved but K3 now was still = E3. Is there an easy way to put the dollar sign on all (the whole column) ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
