Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =IFERROR(INDEX(February!B5:B190,MATCH(MAX(SUMIF(February!B5:B190,February!B5:B190,February!C5:C190)),SUMIF(February!B5:B190,February!B5:B190,February!C5:C190),0)), "No Data")
- if there is no data in column B, this returns 0, instead of "NO Data".
- how can i make it return "No Data" instead of 0?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement