Get short, timely messages from Tom Urtis/Atlas.

Twitter is a rich source of instantly updated information. It's easy to stay updated on an incredibly wide variety of topics. Join today and follow @TomUrtis.

Get updates via SMS by texting follow TomUrtis to 40404 in the United States
Codes for other countries

Two-way (sending and receiving) short codes:
Country Code For customers of
Australia
  • 0198089488 Telstra
Canada
  • 21212 (any)
United Kingdom
  • 86444 Vodafone, Orange, 3, O2
Indonesia
  • 89887 AXIS, 3, Telkomsel
Ireland
  • 51210 O2
India
  • 53000 Bharti Airtel, Videocon
Jordan
  • 90903 Zain
New Zealand
  • 8987 Vodafone, Telecom NZ
United States
  • 40404 (any)

TomUrtis

  1. Tom's Tips For #Excel: Dates in A, sum #s B May1-July 31: =SUMPRODUCT((A1:A20 > =DATE(2011,5,1))+0,(A1:A20 < =DATE(2011,July,31))+0,B1:B20) about 7 hours ago via Crowdbooster
  2. Tom's Tips For #Excel:Address 1st cell holds "Tom": =(ADDRESS(MATCH("Tom",D1:D100,0),4)) Last: array =ADDRESS(MATCH(2,1/(D1:D100="Tom")),4) about 7 hours ago via Crowdbooster
  3. Tom's Tips For #Excel: While on Sheet1 you want the last number listed in column A of Sheet2. =LOOKUP(9.99999999999999E+307,Sheet2!A:A) about 8 hours ago via Crowdbooster
  4. A Tom’s Tutorial For #Excel: Horizontal SUMPRODUCT bit.ly/wpfzAK #MSExcel about 8 hours ago via Crowdbooster
  5. Tom's Tips For #Excel:List of numbers return first non-zero non-error value. Array Ctrl+Shift+Enter =INDEX(A2:A50,MATCH(TRUE,A2:A50 > 0,0)) about 9 hours ago via Crowdbooster
  6. A Tom’s Tutorial For #Excel: SUMIF For Days Past Last Date bit.ly/xwaKdZ #MSExcel about 9 hours ago via Crowdbooster
  7. Tom's Tip For #Excel: List named ranges: Alt+F11 > Ctrl+G > Type in > Range("A1").ListNames > hit Enter > Alt+Q #MSExcel about 9 hours ago via Crowdbooster
  8. Tom's Tips For #Excel:Columns A & B contain numbers, count how many rows for # in B greater than # in A. =SUMPRODUCT((B1:B100 > A1:A100)+0) about 10 hours ago via Crowdbooster
  9. Tom's Tips For #Excel: VBA display column letter of active cell: MsgBox Split(ActiveCell.Address, "$")(1) #MSExcel about 10 hours ago via Crowdbooster
  10. Tom’s Tutorials For #Excel: Horizontal SUMPRODUCT bit.ly/wpfzAK #MSExcel about 10 hours ago via Crowdbooster
  11. Tom's Tips For #Excel: Print a userform without opening it. Alt+F11 > Ctrl+G > Type in > UserForm1.PrintForm > hit Enter > Alt+Q about 11 hours ago via Crowdbooster
  12. @MrExcel_East @Tnash10 @HolyMacroBooks @AxelKoster @randomhouse @GKTWVillage @MrExcel Have a nice weekend everyone! about 11 hours ago via web in reply to MrExcel_East
  13. Tom's Tips For #Excel: Count all entries in column A beginning with Excel. =COUNTIF(A:A,"Excel*") Along row 3 it's =COUNTIF(3:3,"Excel*") about 11 hours ago via Crowdbooster
  14. Tom's Tips For #Excel: VBA: Select index sheet #'s 1 & 2: Sheets(Array(1, 2)).Select || Select index #'s 3 & 6: Sheets(Array(3, 6)).Select about 11 hours ago via Crowdbooster
  15. Tom’s Tutorials For #Excel: SUMIF For Days Past Last Date bit.ly/xwaKdZ #MSExcel about 12 hours ago via Crowdbooster
  16. Tom's Tips For #Excel: Format cell with date to show its weekday: Right-click cell > Format Cells > Number tab > Custom > Type DDDD > OK about 12 hours ago via Crowdbooster
  • Name Tom Urtis/Atlas
  • Location San Francisco CA
  • Web http://www.atlasp...
  • Bio Excel MVP / consulting, tips, tricks, advice for Excel users from individuals to business / Stanford & Michigan St football fiend/ Tom's Tips for Excel
1,205 Following 1,457 Followers 86 Listed
Topo.ly ㋡ Miko Matsumura™ eijaz sheikh sue matuszak Neil Pettinger OfficeWriter LJ Computers Ltd Tim Nash TNash TheITService Zack Barresse William Devereux Gašper Mramor Emma Cox antoniograziano James Murrell Al Johnston Get Report Help Rick Anderson Chandoo.org Excel Answers Herbert Fidesser Learning Pool Sean Fallon ALFREDO NAJAR Blythe Baldwin xlsxhelp.com PIMP MY CHART Austin Dahl Simon Sinek CIPD Nathan Yau Aaron Biebert John Bolyard Joyce M Washington Wonder Dave