ST Alpha - "I do tons of nested if statements. Started using things like sumproduct to reduce them" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "please ignore" by coffee jones

I do tons of nested if statements. Started using things like sumproduct to reduce them

Posted by zork Aug 15 '12, 09:51

=D2&": "&sumproduct(index((index(H:H)="w")*(index(D:D)=D2))>0)&" - "&sumproduct(index((index(H:H)="l")*(index(D:D)=D2))>0)&" - "&sumproduct(index((index(H:H)="d")*(index(D:D)=D2))>0)

Responses:

that's great. have a nice day. -- nm - coffee jones Aug 15, 09:52 3
- ok - zork Aug 15, 09:57 2
  - without an explanation, that wasn't useful. sorry. thanks for trying to help. -- nm - coffee jones Aug 15, 10:02 1
    - note that I'm not currently asking for an explanation. -- nm - coffee jones Aug 15, 10:02

Post a message top

I do tons of nested if statements. Started using things like sumproduct to reduce them

Replies are disabled on threads older than 7 days.