| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If function limitations help
I am created an advanced gradebook program for excel and was wondering if
anyone had an idea of a better way to accomplish the following Column2 Column2 a 3 b 2 c 5 d 10 etc... with the output being in one row a a a b b c c c c c d d d d d d d d d d The idea is to have the teacher type the subject and how many times it appears as a heading but after the 4th I have to many if functions nested. I am using: if b2=1,a2 for the first return and =IF(B2=2,A2,IF(B2=1,A3)) for the second, =IF(B2=3,A2,IF(B2=2,A3,IF(AND(B2=1,B3=2),A3,A4)) ) for the third etc but I cannot go as far as I want to with this. If anyone has an idea please let me know. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternative to the limitations of the 'IF' function in Excel? | Excel Worksheet Functions | |||
| function nesting limitations | New Users to Excel | |||
| Tab Name Limitations | Excel Discussion (Misc queries) | |||
| Indirect function - Limitations | Excel Worksheet Functions | |||
| function cell range limitations | Excel Worksheet Functions | |||
Threaded Mode
