Excel Max If tweets
A Tom's Tip For #Excel:Alphanumeric items example ABC2357,item with max of last 4 digits. Array =MAX(IF(LEN(A1:A10) > 3,RIGHT(A1:A10,4)+0))
11 years ago
RT @TomUrtis: Tom's Tips For #Excel:Alphanumeric items example ABC2357, item with max of last 4 digits. Array =MAX(IF(LEN(A1:A10) > 3 ...
http://twitter.com/exceltricks
11 years ago
Tom's Tips For #Excel:Alphanumeric items example ABC2357, item with max of last 4 digits. Array =MAX(IF(LEN(A1:A10) > 3,RIGHT(A1:A10,4)+0))
11 years ago
@max_normal_ If you go to update field you get a different answer every time! I pasted it into Excel in the end.
11 years ago
@madaleine0livia yeah I'm nearly max and I've got to add things in haha, dunno if you count the words you used on excel? Eg Revenue..
http://twitter.com/MikeeyBoard
11 years ago
RT @TomUrtis: A Tom's Tip For #Excel: Sum a range having positive and negative numbers, but if sum is negative show zero, =MAX(0,SUM(A1: ...
http://twitter.com/rogerfisher
11 years ago
RT @TomUrtis: A Tom's Tip For #Excel: Sum a range having positive and negative numbers, but if sum is negative show zero, =MAX(0,SUM(A1: ...
http://twitter.com/exceltricks
11 years ago