Need formula for -- If Text = 1 and Text =-1 adjust running total

**Boharris** · 05-13-2009, 06:05 PM

example:

1312 (total)

SS 1311 (new total)
LA 1310 (new total)
LB 1309 (new total)
LS 1310 (new total)

LS =+1
SS, LA, LB =-1

**JBeaucaire** · 05-13-2009, 06:16 PM

If those are formulas in a column, then something like:

Please Login or Register  to view this content.

Note: The alphastrings have to be sorted in this order for this to work, put the matching values in the matching positions in the second array.

**Boharris** · 05-14-2009, 09:28 AM

AWSOME!

Worked first time....now it's tweak time....

Thanks JB

**JBeaucaire** · 05-14-2009, 10:31 AM

Check the Excel Help files (Press F1) on LOOKUP and you'll see different ways you can implement this.

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].

(Also, use the "scales" icon in our posts to leave Feedback, it is appreciated)