Hi all,
My company has updated Excel to 2010 from 2003, now when creating a few formula's with Excel 2003 i found that there were easyier ways to do it in 2010 but cannot remember what these ways where, Below is a list of the different formula's, is there any changes i can make to simplify them using the updates in 2010?
=IF(ISNA(VLOOKUP(F2,ALIGNMENT,4,FALSE)),"",VLOOKUP(F2,ALIGNMENT,4,FALSE))
=(SUMPRODUCT(--(Tracker!E2:E1000="LANDROVER"),--(Tracker!T2:T1000="YES")/COUNTIF(Tracker!E2:E1000,"LANDROVER")))
=B3-SUMPRODUCT(--(Tracker!E2:E1000="LANDROVER"),--(Tracker!P2
1000=""))
I think in those last 2 i should be able to use COUNTIFS which would simplify things.
What do you think or are these ok and just to leave them alone?
My company has updated Excel to 2010 from 2003, now when creating a few formula's with Excel 2003 i found that there were easyier ways to do it in 2010 but cannot remember what these ways where, Below is a list of the different formula's, is there any changes i can make to simplify them using the updates in 2010?
=IF(ISNA(VLOOKUP(F2,ALIGNMENT,4,FALSE)),"",VLOOKUP(F2,ALIGNMENT,4,FALSE))
=(SUMPRODUCT(--(Tracker!E2:E1000="LANDROVER"),--(Tracker!T2:T1000="YES")/COUNTIF(Tracker!E2:E1000,"LANDROVER")))
=B3-SUMPRODUCT(--(Tracker!E2:E1000="LANDROVER"),--(Tracker!P2

I think in those last 2 i should be able to use COUNTIFS which would simplify things.
What do you think or are these ok and just to leave them alone?