example, in col A, i have list of text. lets say A to Z (might repeat). col B, i have number. 1-100 (will repeat). in col C. i have dollar value. There are no blank. I will have a drop down list in D1 that shows A to Z. lets say i choose R. i want a formula in E1 that show the biggest number in col B if Col A is R. in F1, sum up all the number in col C that is R in col A and the largest number in Col B.
Bookmarks