i have a list of customers rows 1-500 column B, with their purchases showing in columns u-AB and based on the maximum purchases done under a specific column (u-ab), the customer will be tagged as such. example:
if customer in row 10 buys: 33 of P1, 20 of P2, 44 of P4, none of P3, p5-p8... we tag him to be a "P4" customer since that is the product he has purchased the most during the year.
i had this formula...
=HLOOKUP(MAX(U9:AB9),U9:AB313,COUNTA($A$1:$A$306)-ROW(A9)+1,0)
customer of row 9, maximum of U9-ab9. due to Hlookup must copy titles onto the last row too.
this formula is inconsistent, after some row, it just gives "0". I need consistent report!
the logic is: "see the max under a column, and return the column title in this cell".
i am sure max, index match , will do the trick... but don't know HOW....
HELP!!! thanks in advance