Tom Urtis @TomUrtis Twitter profile

Last Seen Profiles

@patriarchmoriya

@jandakembangstw

@Broncoak47

@CloverGrant

@sweepr_tech

@louloubelllle

@mdermansky

@Stanford_HF

@khlinton1

@LyzeeBrown

@Amorus_Yoongus7

@BelgiansPlayers

@jjdeleeuw

@BeestonFilm

@EnactusGreenwch

@CoreyBrennanFF

@kogumachan1111

@raddkahn

@pt_token

@USAmbKyiv

@floydophone

@TammyTXpatriot

@Jxkrs

@Mochalattefox

@ribakoko

@ananbermudez

@Official_Leczy

@kathytre

@TavoParadox

@Arsaitagame

@ILCElSalvador

@DNGEE_YT

@Bocc_accio

@TRicucci98267

@NanaSweete

Tom Urtis

@TomUrtis

1 year

Explaining Excel’s HLOOKUP function.

4

177

874

Tom Urtis

@TomUrtis

1 year

Explaining the VLOOKUP function in reverse

6

181

794

Tom Urtis

@TomUrtis

8 months

Explaining Excel’s HLOOKUP function.

1

140

738

Tom Urtis

@TomUrtis

2 years

Conditionally format the largest number in each row. #TomsTips4Excel

2

103

431

Tom Urtis

@TomUrtis

9 months

Showing a formula that places a checkmark in a cell.

2

84

381

Tom Urtis

@TomUrtis

2 years

Calculating ages in years, months, and days. #TomsTips4Excel

0

84

380

Tom Urtis

@TomUrtis

8 months

Explaining the VLOOKUP function in reverse.

4

85

381

Tom Urtis

@TomUrtis

1 year

Doing a lookup using the INDEX and MATCH functions.

3

89

338

Tom Urtis

@TomUrtis

2 years

Summing and averaging numbers based on dates in a specified month. #TomsTips4Excel

2

75

317

Tom Urtis

@TomUrtis

1 year

Showing a formula that places a checkmark in a cell. #AskTomUrtis

1

67

323

Tom Urtis

@TomUrtis

11 months

Explaining Excel’s VLOOKUP function.

5

73

305

Tom Urtis

@TomUrtis

2 years

Conditionally format a month's number as even or odd based on dates.

0

77

294

Tom Urtis

@TomUrtis

1 year

Showing a reverse lookup using the VLOOKUP and CHOOSE functions.

2

72

299

Tom Urtis

@TomUrtis

1 year

Using the MIN and MAX functions for VLOOKUP criteria. #TomsTips4Excel

1

58

293

Tom Urtis

@TomUrtis

1 year

Doing a lookup using the INDEX and MATCH functions. #AskTomUrtis

3

65

298

Tom Urtis

@TomUrtis

1 year

Explaining Excel’s VLOOKUP function.

3

77

286

Tom Urtis

@TomUrtis

6 months

Using VLOOKUP without a lookup table.

0

50

261

Tom Urtis

@TomUrtis

8 months

Doing a lookup using the INDEX and MATCH functions.

2

50

254

Tom Urtis

@TomUrtis

1 year

Explaining Excel’s INDEX and MATCH functions for forward and reverse lookups.

1

43

247

Tom Urtis

@TomUrtis

8 months

Showing a reverse lookup using the VLOOKUP and CHOOSE functions.

2

51

244

Tom Urtis

@TomUrtis

11 months

Doing a lookup using the INDEX and MATCH functions.

0

64

242

Tom Urtis

@TomUrtis

1 year

Using the MIN and MAX functions for reverse VLOOKUP criteria. #TomsTips4Excel

2

45

225

Tom Urtis

@TomUrtis

1 year

Doing a reverse lookup using the INDEX and MATCH functions. #AskTomUrtis

1

41

230

Tom Urtis

@TomUrtis

1 year

Doing a reverse lookup using the INDEX and MATCH functions.

4

48

224

Tom Urtis

@TomUrtis

1 year

Using VLOOKUP without a lookup table.

1

38

223

Tom Urtis

@TomUrtis

10 months

Entering the current date or time using keyboard shortcuts.

2

43

216

Tom Urtis

@TomUrtis

1 year

Creating a new PowerPoint Presentation from Excel. #AskTomUrtis

2

38

205

Tom Urtis

@TomUrtis

2 years

Calculating the percentage of numbers in a list that are positive, negative, and zero.

1

55

198

Tom Urtis

@TomUrtis

2 years

Creating a named range with the keyboard shortcut Ctrl+Shift+F3. #AskTomUrtis

0

50

199

Tom Urtis

@TomUrtis

8 months

Explaining Excel’s VLOOKUP function.

1

55

194

Tom Urtis

@TomUrtis

7 months

Using the MIN and MAX functions for VLOOKUP criteria.

0

37

193

Tom Urtis

@TomUrtis

11 months

Showing a reverse lookup using the VLOOKUP and CHOOSE functions.

2

40

192

Tom Urtis

@TomUrtis

1 year

Using VLOOKUP to return sequential results from multiple lookup values.

2

35

186

Tom Urtis

@TomUrtis

1 year

Slide 33 [Showing Excel’s SUMIF function. #TomsTips4Excel

3

32

183

Tom Urtis

@TomUrtis

2 years

Generating a random whole number between any two numbers. #TomsTips4Excel

2

34

182

Tom Urtis

@TomUrtis

8 months

Showing Excel’s SUMIF function.

0

35

182

Tom Urtis

@TomUrtis

2 years

Looking up the oldest date for a specified name having many repeats. #TomsTips4Excel

0

38

179

Tom Urtis

@TomUrtis

7 months

Using the MIN and MAX functions for reverse VLOOKUP criteria.

0

38

181

Tom Urtis

@TomUrtis

2 years

Ranking to ignore zeroes and blank cells. #TomsTips4Excel

0

56

175

Tom Urtis

@TomUrtis

1 year

Case-sensitive lookup.

0

27

175

Tom Urtis

@TomUrtis

2 years

Right-clicking the status bar for additional edit, formatting, and analysis options. #TomsTips4Excel

0

36

172

Tom Urtis

@TomUrtis

8 months

Explaining Excel’s INDEX and MATCH functions for forward and reverse lookups.

1

43

172

Tom Urtis

@TomUrtis

2 years

Summing numbers in one column depending on text values in 3 other columns on the same row.

2

32

168

Tom Urtis

@TomUrtis

1 year

Counting unique values in one or more separate lists.

2

39

166

Tom Urtis

@TomUrtis

1 year

Showing a reverse lookup using the VLOOKUP and CHOOSE functions. #TomsTips4Excel

0

45

161

Tom Urtis

@TomUrtis

1 year

Using a VBA macro to sum noncontiguous ranges of varying rows in a column.

2

37

160

Tom Urtis

@TomUrtis

2 years

Summing every other cell along a row. #AskTomUrtis

1

34

163

Tom Urtis

@TomUrtis

1 month

Explaining Excel’s HLOOKUP function.

0

42

163

Tom Urtis

@TomUrtis

1 year

Conditional formatting top 5 scores (5 highest numbers) in a list.

1

28

159

Tom Urtis

@TomUrtis

2 years

Finding the row and column with the largest and smallest number. #AskTomUrtis

0

47

156

Tom Urtis

@TomUrtis

10 months

Showing examples of the SUM, SUMIF, and SUMIFS functions.

1

42

155

Tom Urtis

@TomUrtis

1 year

Using the INDEX, MATCH, and CELL functions when the lookup value and the lookup range are in the same column.

2

31

152

Tom Urtis

@TomUrtis

7 months

Creating a new PowerPoint Presentation from Excel.

0

29

151

Tom Urtis

@TomUrtis

1 year

Consolidating a range of data into a single list. #AskTomUrtis

4

37

151

Tom Urtis

@TomUrtis

2 years

Showing your computer's System information with a keyboard shortcut.

0

23

152

Tom Urtis

@TomUrtis

2 years

Looking up the column and row header labels of minimum and maximum numbers in a range.

0

41

148

Tom Urtis

@TomUrtis

1 year

Returning the last positive or negative number in a list. #TomsTips4Excel

1

42

149

Tom Urtis

@TomUrtis

2 years

Finding the row of the first empty cell in a list.

1

30

145

Tom Urtis

@TomUrtis

1 year

Calculating elapsed time across midnight. #AskTomUrtis

0

24

145

Tom Urtis

@TomUrtis

1 year

Returning the row, cell address, and value of the last number or text item in a list.

2

30

138

Tom Urtis

@TomUrtis

22 days

Using the MIN and MAX functions for reverse VLOOKUP criteria.

3

35

147

Tom Urtis

@TomUrtis

1 year

Calculating elapsed time across midnight.

0

36

135

Tom Urtis

@TomUrtis

2 years

Counting multiple criteria items in a list with various other items. #TomsTips4Excel

0

27

143

Tom Urtis

@TomUrtis

2 years

Toggling to show or hide the Ribbon -- two methods. #AskTomUrtis

0

31

139

Tom Urtis

@TomUrtis

1 year

Counting unique values in one or more separate lists. #AskTomUrtis

1

36

141

Tom Urtis

@TomUrtis

1 year

Returning the row, cell address, and value of the last number or text item in a list. #TomsTips4Excel

1

25

141

Tom Urtis

@TomUrtis

1 year

Conditional Formatting examples for repeated items in a list.

0

23

137

Tom Urtis

@TomUrtis

2 years

Formatting cell values to their column width without changing font size or column width.

0

19

136

Tom Urtis

@TomUrtis

2 years

Creating a list without blanks from a list with blanks. #AskTomUrtis

3

26

138

Tom Urtis

@TomUrtis

8 months

Doing a reverse lookup using the INDEX and MATCH functions.

1

28

138

Tom Urtis

@TomUrtis

24 days

Using the MIN and MAX functions for VLOOKUP criteria.

0

44

140

Tom Urtis

@TomUrtis

11 months

Doing a reverse lookup using the INDEX and MATCH functions.

1

35

133

Tom Urtis

@TomUrtis

7 months

Using the DATEDIF function for elapsed time in years, months, and/or days.

1

33

134

Tom Urtis

@TomUrtis

1 year

Lookup highest number in one column to return value in the cell on that same row in another column. #AskTomUrtis

2

23

131

Tom Urtis

@TomUrtis

2 years

Fusing 2 staggered lists into 1 list with Paste Special's Skip blanks.

1

27

123

Tom Urtis

@TomUrtis

1 year

Showing examples of the SUM, SUMIF, and SUMIFS functions. #TomsTips4Excel

0

36

125

Tom Urtis

@TomUrtis

2 years

Averaging numbers between upper and lower limits. #AskTomUrtis

0

30

128

Tom Urtis

@TomUrtis

11 months

Using the DATEDIF function for elapsed time in years, months, and/or days

1

31

128

Tom Urtis

@TomUrtis

1 year

Counting and summing data between dates in Excel. #AskTomUrtis

0

23

125

Tom Urtis

@TomUrtis

1 year

Consolidating a range of data into a single list.

1

24

126

Tom Urtis

@TomUrtis

2 years

Counting for a month, and for a year and month, in a list of dates.

0

31

126

Tom Urtis

@TomUrtis

1 year

Using a formula to create a unique list from a larger list of duplicates.

2

16

119

Tom Urtis

@TomUrtis

8 months

Consolidating a range of data into a single list.

2

30

118

Tom Urtis

@TomUrtis

2 years

Filling the space in a cell from its left edge to the start of its numeric contents. #TomsTips4Excel

1

25

116

Tom Urtis

@TomUrtis

7 months

Showing the SUBTOTAL function on visible and filtered cells.

0

27

118

Tom Urtis

@TomUrtis

1 year

Calculating the maximum difference between two lists of numbers, and finding its row.

0

29

117

Tom Urtis

@TomUrtis

1 year

Looking up the maximum number and associated field value for a multiple instance criterion.

0

29

115

Tom Urtis

@TomUrtis

1 year

Stamping your changed cells with time and date.

0

21

112

Tom Urtis

@TomUrtis

8 months

Keyboard shortcuts to select the entire active row and entire active column.

1

20

117

Tom Urtis

@TomUrtis

7 months

Separating a date and time in the same cell using custom formats with text or an asterisk.

0

32

116

Tom Urtis

@TomUrtis

2 years

Counting dates in a list that fall into a specified year. #TomsTips4Excel

0

27

112

Tom Urtis

@TomUrtis

7 months

Using a VBA macro to sum noncontiguous ranges of varying rows in a column.

1

19

114

Tom Urtis

@TomUrtis

2 years

Counting weekdays in a list of dates. #TomsTips4Excel

0

28

110

Tom Urtis

@TomUrtis

1 year

Showing examples of the AVERAGE, AVERAGEIF, and AVERAGEIFS functions. #AskTomUrtis

2

19

112

Tom Urtis

@TomUrtis

1 year

Replacing a cell’s formula with its static value without copying or pasting.

1

13

106

Tom Urtis

@TomUrtis

1 year

Transposing a two-column vertical list into a single-row horizontal list.

0

28

102

Tom Urtis

@TomUrtis

2 years

Using the last number in a list in a formula. #TomsTips4Excel

0

21

105

Tom Urtis

@TomUrtis

19 days

Creating a new PowerPoint Presentation from Excel.

1

21

108

Tom Urtis

@TomUrtis

9 months

Finding the minimum number in a list that is greater than a minimum floor.

3

19

104

Tom Urtis

@TomUrtis

1 year

Case-sensitive lookup. #TomsTips4Excel

1

17

105