Dear ajnabe_maqbool, By combining several formulas (though a bit more complicated), we can create an array formula without auxiliary fields. With still reference to your data sources
Hope can help as expected (see attachment) Regards, YouSee ________________________________ Dari: ajnabe_maqbool <[email protected]> Kepada: [email protected] Dikirim: Selasa, 30 Oktober 2012 18:54 Judul: ]] XL-mania [[ how can i calculate - &+ figure of the same person from a different columns Dear Member, I have Xell Sheet, 1 asim 50 2 maqbool -25 3 shah 65 4 javed 0 1 asim -15 2 maqbool 25 3 shah -35 4 javed -15 4 javed 10 Required For example : what is the formula: Code Name -Figure +Figure 1 Asim -15 50 2 3 4 Thanks for anybody who provide assistance [email protected] [email protected] S
Figure with split data (YouSee).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
