Well I have an excel table (Table 1) with numerous entries (names) in its columns A and B. Now I need to calculate the average from column C bassed upon certain criteria. Let us suppose that if we select Ram from column A (yellow marked cells) , it will display the corresponding values of column C. All we want that along with displaying the values against the column A, it should also display the values against the cells of column B containing Ram (Green marked cells) in them. Output should be like table 2 and table 3, if we select Ram /John each time .
Bookmarks