Excel Max If tweets

Tom Urtis/Atlas

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))

http://twitter.com/TomUrtis

11 years ago

Heiko Heimrath

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 Urtis/Atlas

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))

http://twitter.com/TomUrtis

11 years ago

Real Penguin

@max_normal_ If you go to update field you get a different answer every time! I pasted it into Excel in the end.

http://twitter.com/RealPengy

11 years ago

Mike Board

@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

Roger Fisher

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

Heiko Heimrath

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

Sites related to Excel Max If

VAU-MAX - Das kostenlose Performance-Magazin