I get a #VALUE! error when trying to use two LOOKUP functions in one cell.
Solved by F. S. in 18 mins
Not allowing me to combine a sumproduct and sumif function in excel. Both the sumproduct and sumif functions have multiple criteria
Solved by E. W. in 26 mins
Multiple IF functions nested in same cell, e.g. if value of A1 = x then write "1", if value of A1 is between y and z then write "2", etc.
Solved by C. H. in 15 mins
I need to combine multiple csv files into one worksheet of continuos record, in weekly chronological order and with a new label in column C and save it in an xls format. I have assembled the files in one folder. I am not that familiarised with the specialised functions of excel. I have excel 2010 for mac 2011. I need to submit this tomorrow ASAP.