1300+ Excel formula examples

1300+ Excel formula examples

This webpage contains a list of formula examples sorted in categories, the left sidebar shows the category names.

A formula example may show up in multiple categories. No numbers on duplicate formula examples.

#, hashtag

1. IMSINH function not working #NUM error

2. IMSIN function not working - #NUM error

3. IMSECH function not working - #NUM error

4. IMSEC function not working - #NUM error

5. The IMLOG10 function not working - #NUM error

6. The IMLN function not working - #NUM error?

7. IMCOT function not working - #NUM error

8. IMCOS function not working - #NUM error

9. IMAGE function - #CONNECT error

10. IMAGE function - #BUSY error

11. CHOOSECOLS function returns a #VALUE! error

12. TEXTSPLIT function - remove #N/A errors

13. Why does the RANDARRAY function return a #SPILL! error?

14. The RANDARRAY function returns a #NAME! error?

15. Why does the SEQUENCE function return a #SPILL! error?

16. The SEQUENCE function returns a #NAME! error?

17. Why does the SORTBY function return a #SPILL! error?

18. The SORTBY function returns a #NAME! error?

19. Why does the SORT function return a #SPILL! error?

20. Why does the FILTER function return a #NAME? error?

21. The FILTER function returns a #SPILL! error, why?

22. Why does the FILTER function return a #CALC! error?

23. Filter function - #CALC! error returns [if_empty] argument

24. ACCRINT function #VALUE! error

25. #NAME! error

26. MAX function ignore #N/A error

27. What is #N/A error

28. CODE function returns #VALUE! error!

29. MIN function ignore #NA error

30. AVERAGE ignore #N/A for non-contiguous cell ranges

31. Formula not working - #NAME! error

32. The OR function returns a #NAME! error

33. The OR function returns a #VALUE! error

34. YEAR function returns #NAME! error

35. YEAR function returns #VALUE! error

36. YEAR function returns #NUM! error

37. Hashtag character lets you hide extra zeros

38. VLOOKUP returns #N/A

39. How to use the number sign or hashtag (#)

40. How to catch the #N/A Error?

41. How to catch the #VALUE! error?

42. How to catch the #REF Error?

43. How to catch the #DIV/0 Error

44. How to catch the #NUM Error

45. How to catch the #NAME Error

46. How to catch the #NULL Error

47. Tracking a stock portfolio #2

48. Monthly calendar template #2

2D, two-dimensional, two-way

49. Two-dimensional lookup using two tables

50. How to perform two-way lookup in multiple tables - 2D

51. Reverse two-way lookups

52. Reverse two-way lookups in a cross reference table [Excel 2016]

53. Reverse two-way lookups in a cross reference table [All excel versions]

54. Reverse two-way lookup in a cross reference table

55. Two-dimensional arrays

56. Create a hyperlink linked to the result of a two-dimensional lookup

57. Two-way lookup in multiple cross reference tables simultaneously

58. Two-way lookup using multiple tables - Excel 365 LAMBDA function

59. How to perform a two-dimensional lookup

3D, multiple worksheets, multiple sheets

60. Join multiple non-adjacent cell ranges and return given columns (3D range) - Excel 365

61. VSTACK function - 3D range

62. How to extract the k-th largest number in a 3D range

63. How to average across sheets - 3D range

64. How to make the LOOKUP function work with multiple worksheets

65. FREQUENCY and 3d ranges

66. SUMIF across multiple sheets

67. SUMIF across multiple sheets - Excel 365 formula

68. Vlookup across multiple sheets

69. Count unique distinct numbers across multiple sheets

70. Lookup and find the most recent date on multiple sheets

71. Print consecutive page numbers across multiple worksheets

365

72. How to combine specific cell range columns - Excel 365

73. How to combine specific columns based on a given value - Excel 365

74. How to combine columns using negative values - Excel 365

75. Extract values from given columns and return the list in random order - Excel 365

___Join multiple non-adjacent cell ranges and return given columns (3D range) - Excel 365

76. Get date ranges from a schedule - Excel 365

77. Extract n-th word in cell value - Excel 365

78. Sum overlapping time - Excel 365

79. List combinations - Excel 365 formula

80. Identify all characters in a cell value - Excel 365

81. Extract column letter - Excel 365

82. How to remove numbers from a cell value (Excel 365)

83. INDEX and MATCH - multiple criteria and multiple results (Excel 365)

84. Find cells containing all conditions (Excel 365)

85. SMALL function - INDEX MATCH (Excel 365)

86. SMALL function - ignore zeros (Excel 365)

87. SMALL function for text - Excel 365

88. SMALL function with duplicates (Excel 365)

89. Extract filtered values - Excel 365

90. Filter delimited values not in list (Excel 365)

91. INDEX MATCH - partial text multiple conditions Excel 365

92. Add grand totals that only sums cells populated with formulas - Excel 365

93. Single column to a multi-column cell range - Excel 365

94. Extract a case sensitive unique list from a column - Excel 365

95. Count unique distinct values based on a condition - Excel 365

96. Lookup a date range and a condition - return multiple values - Excel 365

97. Extract a list of alphabetically sorted duplicates based on a condition - Excel 365

98. Extract duplicate values without exceptions - Excel 365

99. Filter duplicate values using criteria - Excel 365

100. Unique distinct list sorted alphabetically based on a condition - Excel 365

101. Unique distinct list sorted alphabetically based on a range - Excel 365

102. Extract multiple values based on a search value sorted from A to Z (Excel 365)

103. Concatenate unique distinct values - Excel 365

104. Match each substring to a table - Excel 365

105. Filter rows containing at least one digit in any cell on the same row (Excel 365 formula)

106. Calendar, monthly view - Excel 365

107. List permutations with repetition and how many to choose from (Excel 365 formula)

108. Sort items by adjacent number in every other value - Excel 365 formula

109. Excel 365 dynamic array formulas

110. Excel 365 users can enter the TRANSPOSE function as a regular formula

111. Find empty dates in a set of date ranges - Excel 365

112. Dynamic scoreboard - Excel 365

113. How to split expenses evenly (Excel 365)

114. Find numbers closest to sum - Excel 365

115. Find numbers in total with a condition - Excel 365

116. Sort by multiple columns using the SORTBY function (Excel 365)

117. Lookup and return multiple sorted values based on corresponding values in another column - Excel 365

118. Identify rows of overlapping records - Excel 365

119. Compare two columns and extract differences - Excel 365

120. Wildcard lookups and include or exclude criteria - Excel 365

121. How to count cells based on conditionally formatted background color [Excel 365]

122. Count cells based on conditionally formatted background color using Filter tool and SUBTOTAL function [Excel 365]

123. How to count cells with a specific background color (Excel 365)

124. Find all sequences of consecutive dates - Excel 365

125. List non consecutive dates - Excel 365

126. Spilled array - Excel 365

127. COUNTIF Function - Dynamic array formula (Excel 365)

128. Substitute multiple text strings - Excel 365 recursive LAMBDA function

129. Lookup multiple values in one cell - Excel 365

130. Search for values in a related table - Excel 365

131. Sum values in a related table - Excel 365

132. Unique distinct records sorted based on count - Excel 365

133. List unique distinct values in a filtered Excel defined Table - Excel 365

134. Rearrange data - Excel 365 LAMBDA function

____Two-way lookup using multiple tables - Excel 365 LAMBDA function

____SUMIF across multiple sheets - Excel 365 formula

135. VLOOKUP - Return multiple unique distinct values (Excel 365)

136. Filter unique rows case sensitive - Excel 365 LAMBDA function

137. Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

138. How to calculate word frequency in a given cell range - Excel 365 LAMBDA function

139. Fuzzy lookups - Excel 365 recursive LAMBDA function

140. Fuzzy VLOOKUP - Excel 365 LAMBDA function

141. Split words in a cell - Excel 365 formula

142. Split words in a cell - Excel 365 formula - any delimiting character(s)

143. Filter words containing a given string in a cell range - Excel 365 LAMBDA function

144. Filter overlapping date ranges - Excel 365

145. Ignore duplicates [Excel 365]

146. Compare two columns and return differences - Excel 365

147. Compare two columns and return differences sorted from A to Z - Excel 365

148. Sort rows based on frequency and criteria - Excel 365

149. Filter unique strings in a range - Excel 365

150. Lookup with multiple matches returns different values - Excel 365

151. Split words in a cell range into a cell each - Excel 365

152. List unique distinct sorted values removing blanks based on a condition - Excel 365

153. Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

154. Extract dates from overlapping date ranges - Excel 365

155. Convert date ranges into dates - Excel 365

156. List dates outside specified date ranges - Excel 365

157. List empty gaps as date ranges - Excel 365

158. Merge two columns with possible blank cells - Excel 365

159. List all unique distinct rows in a given month and year (Excel 365)

160. List all rows in a given month and year (Excel 365)

161. Extract unique distinct year and months from dates - Excel 365

162. Extract sorted unique distinct years and months based on a list of dates - Excel 365

163. Match two criteria and return multiple records [Excel 365]

164. Extract unique distinct values if the value contains the given string - Excel 365

165. Filter values distributed horizontally - Excel 365

166. Extract unique distinct values sorted based on sum of adjacent values - Excel 365

167. Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

168. Extract all rows from a range based on range criteria - Excel 365

169. Extract all rows from a range based on multiple conditions - Excel 365

170. Unique distinct values sorted based on frequency - Excel 365

171. Extract numbers from a column - Excel 365

172. Extract unique distinct values A to Z from a range and ignore blanks - Excel 365

173. How to find the largest duplicate number - Excel 365

174. How to find the smallest duplicate number - Excel 365

175. How to find the largest unique number - Excel 365

176. How to find the smallest unique number - Excel 365

177. Reverse a list ignoring blanks - Excel 365

178. Filter common values between two nonadjacent cell ranges - Excel 365

179. Extract duplicates from a range - Excel 365

180. Search for a text string in a data set and return multiple records [Excel 365]

181. Merge two columns - Excel 365

182. Merge three columns into one list - Excel 365

183. Extract a list of duplicates from three columns combined - Excel 365

184. Extract duplicates - Excel 365

185. Extract a unique distinct list from three columns - Excel 365

186. Extract a unique distinct list from three columns with possible blanks - Excel 365

187. List unique distinct values in two columns - Excel 365

188. Count unique distinct values in a cell range with blanks - Excel 365

189. Count unique distinct values in multiple nonadjacent cell ranges - Excel 365

190. Partial match with two conditions and return multiple search results - Excel 365

191. Filter unique distinct values based on a date range (Excel 365)

192. Sort column by frequency - Excel 365

193. Partial match for multiple strings - AND logic - returns all matches (Excel 365)

194. Sort a column - Excel 365

195. Two columns sorting by the second column - Excel 365

196. Extract unique distinct values from a multi-column cell range - Excel 365

197. Extract a unique distinct list and ignore blanks (Excel 365)

198. Filter rows using array formulas based on a date range - Excel 365

199. Extract shared values between two columns - Excel 365

200. Extract values that exist only in one of the two columns - Excel 365

201. Find closest value - Excel 365

202. Find closest values - Excel 365

Address

203. How to use the ADDRESS function

204. ADDRESS Function example

205. ADDRESS function not working

206. Get value based on row and column number - ADDRESS function alternative

207. Create an address to a cell range and return values from that cell range

208. INDIRECT function - Address

209. Get the cell address of the largest/smallest number

210. How to extract email addresses from an Excel sheet

Alternative

211. TAKE Function alternative

212. WRAPCOLS Function alternative

213. WRAPROWS Function alternative

214. TOROW Function alternative

215. TOCOL Function alternative

216. VSTACK Function alternative

217. TEXTAFTER Function alternative (all Excel versions)

218. TEXTAFTER Function alternative

219. TEXTAFTER Function alternative case sensitive

220. TEXTBEFORE Function alternative (all Excel versions)

221. TEXTBEFORE Function alternative

222. TEXTBEFORE Function alternative case sensitive

223. Is there an alternative to the SEQUENCE function?

224. IFS function alternative

225. INT function alternative

226. COMBIN function alternative

____Get value based on row and column number - ADDRESS function alternative

227. DAY function alternative

228. MONTH function alternative

229. REPT function alternative

230. CHOOSE function alternative

231. Alternative regular formula

232. Alternative function - SEARCH function

233. Alternative formula

234. VLOOKUP alternatives

235. Alternative array formula [Excel 2007]

And logic

236. How to multiply boolean values - apply AND logic

237. Filter values based on a condition per column - AND logic

238. SMALL function - multiple conditions AND logic

239. SMALL function - match records AND logic

240. VLOOKUP function with two conditions applied to two columns (AND logic)?

241. XLOOKUP - two conditions in two columns (AND logic)?

242. Highlight records containing text strings (AND Logic)

243. Highlight records [AND logic]

244. Sum based on OR – AND logic

245. Perform multiple partial matches and return records – AND logic

246. Partial match for multiple strings – AND logic

247. Partial match for multiple strings - AND logic - returns the first match

248. Partial match for multiple strings - AND logic - returns all matches

____Partial match for multiple strings - AND logic - returns all matches (Excel 365)

249. Partial match for multiple strings - AND logic - returns all corresponding values

Autofilter

250. Enable Autofilter

251. Filter duplicate values using criteria - Autofilter

252. Wildcard lookups and include or exclude criteria - autofilter

253. List unique distinct values - Autofilter

254. Most frequent value between two dates - Autofilter

255. How to enable the Autofilter

256. How to apply a condition to the Autofilter

257. How to know if the data is filtered - Autofilter

258. How to clear a filter - Autofilter?

259. Lookup and return multiple values [AutoFilter]

260. Extract all rows from a range based on range critera [AutoFilter]

261. Filter rows based on a date range - Autofilter

Average

262. How to calculate a moving average

263. Highlight above average values

264. How to use the DAVERAGE function

265. How to use the AVERAGEA function

266. How the average and the median can differ

267. LARGE function - calculate an average based on the three largest numbers

268. How to use the AVERAGEIFS function

269. AVERAGEIFS function not working

270. AVERAGEIFS Function example

271. AVERAGEIFS function - wildcard characters

272. AVERAGEIFS Function - begins with

273. AVERAGEIFS Function - ends with

274. AVERAGEIFS Function - contains

275. AVERAGEIFS function - nested functions and arrays

276. How to use the AVERAGEIF function

277. AVERAGEIF function not working

278. How to use wildcard characters in the AVERAGEIF function

279. AVERAGEIF function - begins with

280. AVERAGEIF function - ends with

281. AVERAGEIF function - contains

282. AVERAGEIF function - match a specific number of characters

283. Is the criteria argument in the AVERAGEIF function case sensitive?

284. AVERAGEIF function - comparison operators

285. AVERAGEIF function - larger than

286. AVERAGEIF function - smaller than

287. AVERAGEIF function - not equal to

288. AGGREGATE function - AVERAGE

289. Calculate an average based on a case sensitive condition

290. Convert negative numbers to positive and calculate the average

291. AVERAGE based on criteria

292. AVERAGE - AND OR logic

293. AVERAGE ignore NA()

294. AVERAGE function can't handle errors

295. AVERAGE ignore NA() - Excel 2007 and later versions

296. AVERAGE ignore NA() - earlier versions

____AVERAGE ignore #N/A for non-contiguous cell ranges

297. How to AVERAGE time

298. How to AVERAGE time hh mm ss

299. AVERAGE ignore blanks

300. Average - ignore blanks and errors

301. Average - ignore blanks in non-contiguous cells

302. Weighted average ignore blanks

303. Average ignore 0 (zeros) and blanks

304. How to use the AVERAGE function

305. AVERAGE Function Example

306. How to average a column containing some text values

307. Are zeros counted in the AVERAGE function?

308. Are boolean values ignored in the AVERAGE function?

309. How to average absolute values

____How to average across sheets - 3D range

310. How to average by group

311. How to average by month

312. How to average blank as zero

313. How to average excluding high and low

314. How to exclude some cells from average

315. SUMPRODUCT - weighted average based on percentages

316. SUMPRODUCT - weighted average

317. How to calculate an average based on filtered data?

318. Follow stock market trends – Moving Average

319. Calculate moving average

320. Plot moving average turning points

321. How to extract the moving average turning dates

322. Calculate running average of last 10 data with random blank cells

323. AVERAGE ignore 0 (zero)

Blank, space

324. TOROW Function - blanks and errors

325. TOCOL Function - blanks and errors

326. How to create blanks in a sequence of numbers?

327. Extract unique distinct values ignoring blanks

328. Extract unique distinct values sorted from A to Z ignoring blanks

329. Extract unique values ignoring blanks

330. Extract unique values sorted from A to Z ignoring blanks

331. Extract unique distinct rows ignoring blank rows

332. Extract unique distinct rows sorted from A to Z ignoring blank rows

333. Extract unique rows ignoring blank rows

334. Extract unique rows sorted from A to Z ignoring blank rows

335. How to count blank cells

336. MINIFS function not blank

337. How to find blank cells

338. How to quickly select blank cells

339. Count cells with text excluding cells containing a space character

340. How to use the ISBLANK function

341. How to use the COUNTBLANK function

342. COUNTBLANK function example

343. Count blanks in an array

344. Count blanks based on a condition

345. Count blanks based on a list

346. Count blanks in a text string

347. Count blanks in multiple cell ranges

348. LEFT function until space

349. LEFT function until second space

____AVERAGE ignore blanks

____Average - ignore blanks and errors

____Average - ignore blanks in non-contiguous cells

____Weighted average ignore blanks

____Average ignore 0 (zeros) and blanks

____How to average blank as zero

350. SUMPRODUCT if not blank

351. SUMPRODUCT returns nothing (blank)

352. How to check if there is a blank value in a cell range

353. How to use the COUNTIF function to count not blank cells

354. Count not blank cells - COUNTIF function

355. Count not blank cells - COUNTA function

356. Count not blank cells - SUMPRODUCT function

357. Delete blanks in the array

358. Trim space characters

359. How to select and delete blank cells

360. Select and delete blank cells

361. Macro deletes formulas returning a blank

362. Macro deletes entire row if the formula returns blanks

363. Cell range contains numbers, text, and blanks?

364. IF function - How to check if a cell is blank?

365. IF function - How to check if a cell is not blank?

366. IF function - keep blank?

367. Insert blank rows for missing values

368. Filter unique distinct values, sorted and blanks removed from a range

____Calculate running average of last 10 data with random blank cells

369. Combine cell ranges ignore blank cells

370. Split words in a cell - blank as a delimiting character

371. Break up values in a cell range into separate cells based on a space character as a delimiter

372. Extract a unique distinct list sorted from A to Z ignore blanks

373. Extract a unique distinct list sorted from A to Z and ignore blanks

374. Create a unique distinct sorted list containing both numbers and text removing blanks with a condition

____List unique distinct sorted values removing blanks based on a condition - Excel 365

____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

375. Merge two columns with possible blank cells

____Merge two columns with possible blank cells - Excel 365

376. Merge two columns with possible blank cells - earlier versions

377. Create a numbered list ignoring blank cells

378. Extract unique distinct values A to Z from a range and ignore blanks

____Extract unique distinct values A to Z from a range and ignore blanks - Excel 365

____Extract unique distinct values A to Z from a range and ignore blanks

379. Create a list of dates with blanks between quarters

380. Reverse a list ignoring blanks

____Reverse a list ignoring blanks - Excel 365

381. Reverse a list ignoring blanks - manual steps

382. Extract a unique distinct list from three columns with possible blanks

____Extract a unique distinct list from three columns with possible blanks - Excel 365

383. List unique distinct values in two columns, no blanks

____Count unique distinct values in a cell range with blanks - Excel 365

384. Count unique distinct values in a cell range with blanks

385. How to ignore blank cells

386. Delete blanks and errors in a list

387. Extract a unique distinct list and ignore blanks

____Extract a unique distinct list and ignore blanks (Excel 365)

388. Filter unique distinct row records but not blanks

389. Remove blank cells

____Create a numbered list ignoring blank cells

390. Rotate text to save space

Calendar

391. How to create a dynamic calendar using the SEQUENCE function?

392. Create a dynamic calendar using the DAY function

393. Calendar – monthly view

____Calendar, monthly view - Excel 365

394. Add event to the monthly calendar

395. How to add recurring events to the calendar

396. Pivot Table calendar

397. Yet another Excel Calendar

398. How to use this Excel Calendar

399. How I built this calendar

400. Worksheet Calendar

401. Heat map yearly calendar

402. Highlight events in a yearly calendar

403. Use a calendar to filter an Excel defined Table

404. Plot date ranges in a calendar part 2

405. Create a drop down calendar

406. Weekly appointment calendar

____Monthly calendar template #2

407. Monthly calendar template

408. Count groups in calendar

409. Schedule recurring expenses in a calendar in excel (Personal Finance)

410. Plot date ranges in a calendar

Case

411. TEXTAFTER Function - case sensitive example

____TEXTAFTER Function alternative case sensitive

412. TEXTBEFORE Function - case sensitive example

____TEXTBEFORE Function alternative case sensitive

413. Is the SORT function case sensitive?

414. Is the FILTER function case sensitive?

415. Filter values based on a condition - case sensitive

____Is the criteria argument in the AVERAGEIF function case sensitive?

416. Convert every other letter to upper or lower case

417. How to perform a case sensitive count based on a condition

____Calculate an average based on a case sensitive condition

418. Calculate a sum based on a case sensitive condition

419. Calculate the median based on a case sensitive condition

420. Case sensitive condition not equal to

421. INDEX MATCH – Case sensitive

422. How to do a case sensitive INDEX MATCH - array formula

423. How to do a case sensitive INDEX MATCH - regular formula

424. How to do a case sensitive partial match using INDEX and MATCH functions

425. How to do a partial case sensitive match using two conditions in two columns

426. Match two columns and return another value on the same row - case sensitive

427. If cell equals value from list - case sensitive

428. How to extract a case sensitive unique list from a column

429. Extract a case sensitive unique list from a column

____Extract a case sensitive unique list from a column - Excel 365

430. How to make the LIKE operator case insensitive?

431. IF function - exact match case sensitive

432. How to do a case sensitive match

433. Count specific multiple text strings in a given cell range - case sensitive

434. Count specific multiple text strings in a given cell range - case insensitive

435. Filter unique distinct records case sensitive

____Filter unique rows case sensitive - Excel 365 LAMBDA function

436. Count unique distinct rows case sensitive

____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

____Count unique distinct rows case sensitive

437. Case sensitive lookup and return multiple values

438. VLOOKUP and return multiple values - case sensitive

439. Count text string in a range (case sensitive)

440. Count unique distinct values (case sensitive)

441. Count unique values (case sensitive)

442. Extract unique distinct values (case sensitive) [Formula]

443. Count how many times a string exists in a cell range (case insensitive)

444. Extract shared values between two columns (case sensitive)

Character

445. How to use the asterisk character

446. Partial match VLOOKUP - asterisk character (wildcard)

447. Split characters horizontally to a cell each

448. Split string using multiple delimiting characters

449. How to create a string containing column and row delimiting characters

450. How to shuffle characters in a text string randomly

451. How to convert from formal Unicode notation U+XXXX to its corresponding Unicode character

____Count cells with text excluding cells containing a space character

452. How to convert binary 8 bit to the ANSI character set

453. How to add delimiting characters to the CONCAT function

454. Match a range value containing both text and numerical characters

455. Check if a cell contains nonprintable characters

456. Check if a cell range contains nonprintable characters

457. Highlight cells containing nonprintable characters

458. How to remove unwanted characters in a cell

459. Count characters based on condition example 1

460. Count characters based on condition example 2

461. Count characters based on a list

462. Count characters in a formula

463. Count total characters in multiple cell ranges combined

464. Identify all characters in a cell value

____Identify all characters in a cell value - Excel 365

465. How to convert comma delimiting numbers to a string of characters

466. How to list all characters based on ANSI code

467. How to identify a new line character in an Excel formula

468. How to create superscript characters in an Excel formula

469. List all characters based on ANSI numbers - CODE Function

____AVERAGEIFS function - wildcard characters

____How to use wildcard characters in the AVERAGEIF function

____AVERAGEIF function - match a specific number of characters

470. Change upper letter to lower letter for the position of a given character

471. Change all upper letters to lower letters for a given character

472. How to change lower letter to upper letter for the position of a given character

473. How to change lower letter to upper letter for a given character

474. How to change all lower letters to upper letters for a given character

475. Split characters to a cell each horizontally counting backwards

476. LEFT until character

477. LEFT function remove characters

478. MID function between two characters

479. MID function - split characters into an array

480. MID function - reverse characters in value

____Hashtag character lets you hide extra zeros

481. How to align numbers by decmial point - ? (question mark character)

482. How to format a number as a percentage - % character

483. How to use text in the TEXT function - @ at character

484. Add delimiting character

485. VLOOKUP function - tilde character escapes wildcard characters

486. What characters can you use as a pattern?

487. Combining pattern characters

488. How to join cell values without a delimiting character

489. TEXTJOIN function - how to add row delimiting characters

____Trim space characters

490. How to count the number of values separated by a given character?

491. Insert random characters

492. How to shuffle characters in the alphabet

493. Insert random characters based on key

494. Merge data sets based on a partial match - wildcard character

495. SEARCH function - wildcard characters

496. COUNTIFS function - Partial match using wildcard characters

497. COUNTIF Function - How to count cells containing x number of characters?

498. How to do a partial match - wildcard character

499. Match cell that begins with a specific string and ends with another string - any number of characters in between

500. Match cell that begins with string and ends with another string - a single character in between

501. Sort values in a cell based on a delimiting character

502. Sort values in a cell based on a delimiting character (Formula)

503. Sort values in a cell based on a delimiting character (Macro)

____Split words in a cell - blank as a delimiting character

504. Split words in a cell - any delimiting character(s)

____Split words in a cell - Excel 365 formula - any delimiting character(s)

505. Split words in a cell - Rick Rothstein's formula - Any delimiting character(s)

506. Split words in a cell - FILTERXML function - any a delimiting character

507. Create delimiting character

508. How to change delimiting character

509. Searching for the first characters in a text string [Array Formula]

510. Extract unique distinct values based on the 4 last characters

____Break up values in a cell range into separate cells based on a space character as a delimiter

511. Identify missing three character alpha code numbers

Column

512. How to count the top 10 numbers in a cell range (column-wise) per row

513. How to count the top 10 numbers in a cell range per column

514. How to count the bottom 10 numbers in a cell range per column

515. Extract a unique distinct list across multiple columns and rows sorted based on frequency

____How to combine specific cell range columns - Excel 365

____How to combine specific columns based on a given value - Excel 365

____How to combine columns using negative values - Excel 365

____Extract values from given columns and return the list in random order - Excel 365

____Join multiple non-adjacent cell ranges and return given columns (3D range) - Excel 365

516. DROP Function example - exclude columns

517. DROP Function example - exclude columns and rows

518. TAKE Function example - return columns

519. TAKE Function example - return columns and rows

520. WRAPCOLS Function example - by column

521. TOROW Function example - by column

522. TOCOL Function example - by column

523. Extract unique distinct columns from multiple cell ranges

____How to create a string containing column and row delimiting characters

524. How to calculate the relative position of column and row

525. Put XML data in different columns based on XML tags?

526. How to sort by multiple columns?

527. Sort by another column

528. How to sort a multicolumn cell range

529. Sort based on values in an adjacent column

530. Sort by column (vertically)?

531. How to sort by column header?

____How to sort a multicolumn cell range

____Filter values based on a condition per column - AND logic

532. Filter values based on a condition per column - OR logic

534. Unique distinct columns

535. Unique columns

536. Sum a column using a formula

537. Sum a given column using a formula

538. How to create a sparkline – Column

539. Sort columns based on the geometric mean

540. Convert column number to column letter

541. Sort columns based on the median values

542. How to filter using OR logic between columns [Formula]

543. Rearrange values in a cell range to a single column

544. Count non-empty cells per column

545. Sort columns based on the number of non-empty cells

546. How to use the COLUMNS function

547. COLUMNS function example

548. Count columns in an array

549. Count columns in a string

550. Count columns in multiple cell ranges

551. Count columns in multiple Excel Tables

552. Get the highest number within each column

553. Sort columns by their highest number within each row

554. Count numbers per column

555. Sort columns based on numbers

556. How to use the COLUMN function

557. COLUMN Function Example

558. How to convert a column number to a column letter?

559. How to convert a column letter to a column number?

560. How can the Column function return an array?

561. Column function and VLOOKUP

562. Column function of other functions

563. Column function with a cell ref to a cell range?

564. Column function and SMALL function

565. Get value based on row and column number

____Get value based on row and column number - ADDRESS function alternative

566. Get value based on a row and column number and a worksheet name

____Extract column letter - Excel 365

567. TRIM function for the entire column

____How to average a column containing some text values

____How to do a partial case sensitive match using two conditions in two columns

568. Compare two columns and highlight differences

569. Match two columns and return another value on the same row

570. Match two columns and return another value on the same row (array formula)

571. Match two columns and return another value on the same row (regular formula)

____Match two columns and return another value on the same row - case sensitive

572. Match two columns and return another value on the same row - partial match

573. INDEX MATCH - partial match multiple columns

574. Sum by column value

575. How to sum based on a condition in another column

576. Multi-column cell range to a single column cell range

577. Single column to a multi-column cell range

____Single column to a multi-column cell range - Excel 365

____How to extract a case sensitive unique list from a column

____Extract a case sensitive unique list from a column

____Extract a case sensitive unique list from a column - Excel 365

578. Find last value in a column

579. Return a hyperlink to the last value in a column

580. Return the row number of the last value in a column

581. Extract a corresponding value next to the last value in a column

582. How to add numbers in a column and return a total (SUM function)?

583. How to sum a column with text (SUM function)?

584. How to sum a filtered column?

585. How to sum the entire column?

586. How to sum a column and ignore errors?

587. VLOOKUP - What if the lookup value is not in the leftmost column?

588. VLOOKUP on two columns

589. VLOOKUP returns multiple columns

590. How to add a column

591. How to delete an Excel Table column

592. Reference column headers

593. Reference a column

594. Count identical values on the same row comparing values in n columns

595. Compare two columns in different worksheets

596. Compare two columns in different worksheets (Excel 2016)

597. Sort values by corresponding text arranged in a column

598. Color all stacked columns

599. What happens if you transpose a range with the same number of columns and rows?

600. Adjust column gap width and transparency

601. How to create an INDIRECT to a column number?

602. How to use the TEXTTOCOLUMNS method

603. Extract the most repeated adjacent values in a column

604. How to change column width for multiple columns simultaneously?

605. Compare two lists and filter unique values where the sum in one column doesn’t match the other column

606. Column transposition cipher

607. Sort by multiple columns

608. Sort by multiple columns using an Excel Table

____Sort by multiple columns using the SORTBY function (Excel 365)

609. Sort by multiple columns using formula (Previous Excel versions)

610. Lookup and return multiple sorted values based on corresponding values in another column

____Lookup and return multiple sorted values based on corresponding values in another column - Excel 365

611. Lookup and return multiple sorted values based on corresponding values in another column - previous Excel versions

612. Lookup and return multiple sorted values based on corresponding values in another column - Excel Table

613. Compare two columns and extract differences

____Compare two columns and extract differences - Excel 365

614. Compare two columns and extract differences - earlier versions

615. Helper column

616. Cell ranges with an equal number of rows and columns

617. Cell ranges with different number of rows and columns, ex 1

618. Cell ranges with different numbers of rows and columns, ex 2

619. Calculate totals column-wise

620. ROW function - duplicate columns

621. How to return all values in a row or column in a given cell range with the INDEX function

622. Get a value in a given cell range based on a row and column number

623. How to return an column of values in a given cell range using the INDEX function

624. Add a column to an Excel Table

625. VLOOKUP and return multiple values across columns

____VLOOKUP function with two conditions applied to two columns (AND logic)?

626. VLOOKUP function with two conditions applied to two columns (OR logic)?

627. VLOOKUP function with many conditions applied to one column (OR logic)?

628. VLOOKUP across multiple columns?

629. What if I don't have the lookup column in the left-most column?

630. VLOOKUP - Select column using a drop-down list

____XLOOKUP - two conditions in two columns (AND logic)?

631. XLOOKUP - two conditions in two columns (OR logic)?

632. XLOOKUP - multiple conditions in one column (OR logic)?

633. XLOOKUP across multiple columns?

____What if I don't have the lookup column in the left-most column?

634. Filter values that exists in all three columns

635. Create comment if cell value is larger than column

636. Lookup multiple values across columns and return a single value

637. Disable autofit column widths for Pivot table

638. Partial match in multiple columns and return adjacent values

639. Auto resize columns as you type

640. Search each column for a string each and return multiple records – OR logic

641. Count unique distinct records with a date and column criteria

642. Text to columns: Split words in a cell

643. Concatenate cell values in a column into a single cell

644. Concatenate a multi-column and multi-row cell range

645. Highlight duplicate columns

646. Compare two columns and return differences

647. Compare two columns and return differences sorted from A to Z

____Compare two columns and return differences - Excel 365

____Compare two columns and return differences sorted from A to Z - Excel 365

648. Sort records based on two columns

____Merge two columns with possible blank cells

____Merge two columns with possible blank cells - Excel 365

____Merge two columns with possible blank cells - earlier versions

649. Sort two columns

650. VLOOKUP/XLOOKUP of three columns to pull a single record

651. VLOOKUP of three columns to pull a single record

652. XLOOKUP of three columns to pull a single record

653. Lookup two index columns

654. Extract all rows from a range that meet criteria in one column

655. Unique distinct list from a column sorted A to Z

656. Extract numbers from a column

____Extract numbers from a column - Excel 365

657. Extract numbers from a column - earlier Excel versions

658. Filter common values from three separate columns

659. Extract a list of alphabetically sorted duplicates from a column

660. Extract duplicates from a multi-column cell range

661. Add columns

662. Sort text cells alphabetically from two columns

663. Sort text from two columns combined (array formula)

664. Merge two columns

____Merge two columns - Excel 365

665. Merge two columns - earlier Excel versions

666. Merge three columns into one list

____Merge three columns into one list - Excel 365

667. Merge three columns into one list - earlier Excel versions

668. Merge three columns into one list - Excel 2003 and earlier versions

669. Extract a list of duplicates from three columns combined

____Extract a list of duplicates from three columns combined - Excel 365

670. Extract a list of duplicates from three columns combined - earlier Excel versions

671. Extract a list of duplicates from a column

672. Extract a list of duplicates from two columns combined

673. Extract a unique distinct list from three columns

____Extract a unique distinct list from three columns - Excel 365

____Extract a unique distinct list from three columns with possible blanks

____Extract a unique distinct list from three columns with possible blanks - Excel 365

674. Extract a unique distinct list from two columns

____List unique distinct values in two columns - Excel 365

675. List unique distinct list values in two columns - earlier version 1

676. List unique distinct list in two columns - earlier version 2

____List unique distinct values in two columns, no blanks

677. Identify missing numbers in two columns based on a numerical range

678. Identify missing numbers in a column

679. Count unique distinct values in two columns

680. Highlight duplicates in two columns

681. Compare two columns and highlight values in common

682. Highlight missing values between to columns

683. Sort column based on frequency

684. Sort column based on the frequency

____Sort column by frequency - Excel 365

685. Get the column header name that contains the largest/smallest value

686. Extract unique values from two columns

687. How to extract unique distinct values from a column [Formula]

688. How to extract unique distinct values from a column [Old array Formula]

689. Sort a column alphabetically

____Sort a column - Excel 365

690. Sort a column using array formula

____Two columns sorting by the second column - Excel 365

691. Two columns sorting by the second column

692. Extract unique distinct values from a multi-column cell range

____Extract unique distinct values from a multi-column cell range - Excel 365

693. Extract unique distinct values from a multi-column cell range - earlier Excel versions

694. How to extract not shared values in two columns

695. Extract shared values between two columns

____Extract shared values between two columns - Excel 365

____Extract shared values between two columns (case sensitive)

____Filter common values from three separate columns

696. How to search for a string in a column

697. Extract values that exist only in one of the two columns

____Extract values that exist only in one of the two columns - Excel 365

Combination, combin

698. How to use the COMBINA function

699. How to use the COMBIN function

700. COMBIN function example

____COMBIN function alternative

____List combinations - Excel 365 formula

701. Test combinations (Solver)

____Combining pattern characters

702. Return all combinations

Complex, imaginary

703. What are complex numbers?

704. What are the applications for complex numbers?

705. IMTAN function example 3 - real and imaginary coefficients

706. How to calculate the sum of two complex numbers in rectangular form?

707. How to plot the sum of two complex numbers?

708. How to calculate the midpoint of two complex numbers?

709. How to calculate the difference between two complex numbers in rectangular form?

710. How to graph the difference between two complex numbers?

711. How to calculate the distance between two complex numbers?

712. How to calculate the second solution of the square root of a complex number?

713. How is the square root of a complex number calculated in detail?

714. How to calculate the sine of a complex number in detail?

715. Calculate the complex determinant of a 2x2 matrix

716. Multiply complex number by i

717. Calculate a given complex number raised to a power in detail

718. What are quadrants in the complex plane?

719. Calculate the n-th root of a complex number

720. How to calculate the base 2 logarithm of a complex number in detail?

721. How to enter negative complex numbers in Excel

722. How is the exponential of a complex number calculated in detail?

723. The exponential function of a complex number produces a wave

724. How to perform division between two complex numbers

725. How to convert from complex number in polar form to rectangular form

726. How to convert complex numbers to polar form?

727. How is the complex conjugate calculated?

728. How to calculate the product of a complex number and its complex conjugate

729. How to calculate the modulus of a complex conjugate

730. How to calculate the conjugate of a conjugate complex number

731. How to use the IMAGINARY function

732. IMAGINARY function example

733. When to use the IMAGINARY function?

734. How imaginary numbers were invented

735. How to use the COMPLEX function

736. COMPLEX function example

737. What is the general form of complex numbers?

738. Describe different forms of complex numbers?

739. COMPLEX Function error

740. How to navigate quickly in a complex workbook using hyperlinks

Concatenate, combine, merge, join, append

____How to combine specific cell range columns - Excel 365

____How to combine specific columns based on a given value - Excel 365

____How to combine columns using negative values - Excel 365

____Join multiple non-adjacent cell ranges and return given columns (3D range) - Excel 365

741. How to use the CONCATENATE function

742. CONCATENATE function - example

743. CONCATENATE function not working

____Count total characters in multiple cell ranges combined

744. REPT function based on list and concatenated

745. Concatenate cell values based on a condition

746. Concatenate all values in the array

747. Concatenate unique distinct values

748. Concatenate unique distinct values - Excel 2019

____Concatenate unique distinct values - Excel 365

749. Concatenate unique distinct values - Earlier Excel versions

750. Merge two data sets using the VLOOKUP function

751. How to use the TEXTJOIN function

____How to join cell values without a delimiting character

752. How to concatenate cell values ignoring empty cells

753. Concatenate values based on a condition

754. Can I enter an array formula in merged cells?

755. How to enter array formulas in merged cells

756. Merge tables based on a condition

757. How to join data sets using the VLOOKUP function

758. Merge data using the INDEX and MATCH functions

____Merge data sets based on a partial match - wildcard character

759. How to merge data using two or more criteria with the COUNTIFS function

760. SMALL and ROWS function combined?

761. Merge two relational data sets

762. Can you concatenate VLOOKUP results?

763. Can you concatenate XLOOKUP results?

764. Prepare data for Pivot Table – How to split concatenated values?

765. Use a drop down list to filter and concatenate unique distinct values

____Combine cell ranges ignore blank cells

766. Merge matching rows

767. Concatenate cell values

768. Concatenate cell values in a row into a single cell

____Concatenate cell values in a column into a single cell

____Concatenate a multi-column and multi-row cell range

769. Lookup and return multiple values concatenated into one cell

770. Lookup and return multiple values concatenated into one cell [Excel 2019]

771. Lookup and return multiple dates concatenated into one cell [Array Formula]

772. Lookup within a date range and return multiple values concatenated into one cell [Array Formula]

____Merge two columns with possible blank cells

____Merge two columns with possible blank cells - Excel 365

____Merge two columns with possible blank cells - earlier versions

____Sort text from two columns combined (array formula)

____Merge two columns

____Merge two columns - Excel 365

____Merge two columns - earlier Excel versions

____Merge three columns into one list

____Merge three columns into one list - Excel 365

____Merge three columns into one list - earlier Excel versions

____Merge three columns into one list - Excel 2003 and earlier versions

____Extract a list of duplicates from three columns combined

____Extract a list of duplicates from three columns combined - Excel 365

____Extract a list of duplicates from three columns combined - earlier Excel versions

____Extract a list of duplicates from two columns combined

Conditional formatting, cf, highlight

773. Apply conditional formatting

774. Highlight unique distinct records

775. Highlight current date

776. How to highlight dates based on day of week

777. Highlight unique/duplicates [Conditional formatting]

778. How to highlight weekends [Conditional Formatting]

779. Highlight cells equal to

780. Highlight a date occuring [Conditional formatting]

781. Highlight a date occurring...

782. Highlight a date occurring yesterday

783. Highlight a date occurring today

784. Highlight a date occurring tomorrow

785. Highlight a date occurring in the last 7 days

786. Highlight a date occurring last week

787. Highlight a date occurring this week

788. Highlight a date occurring next week

789. Highlight a date occurring last month

790. Highlight a date occurring this month

791. Highlight a date occurring next month

792. Highlight rows/records

793. Highlight a row if the date is yesterday

794. Highlight a row if the date is today

795. Highlight a row if the date is tomorrow

796. Highlight a row if the date is in the last 7 days

797. Highlight a row if the date is last week

798. Highlight a row if the date is in this week

799. Highlight a row if the date is in next week

800. Highlight a row if the date is in the last month

801. Highlight a row if the date is in this month

802. Highlight a row if the date is in the next month

____Highlight above average values

803. Highlight top 10 % values

804. Highlight top 10 values

805. Highlight cells containing string [Conditional formatting]

806. How to insert icons representing cell values [Conditional formatting]

807. How to create color scales [Conditional Formatting]

808. Highlight text values

809. Highlight cells based on coordinates

810. Highlight opposite numbers

____Highlight cells containing nonprintable characters

811. Highlight numbers stored as text

812. Sort highlighted numbers

813. Highlight empty cells

814. How to apply conditional formatting

815. Highlight cells containing errors

____Compare two columns and highlight differences

816. OR function conditional formatting

817. AND function Conditional formatting

818. How to apply Conditional Formatting

819. Highlight cells based on ranges

820. Highlight weekends

821. Grid pattern - Conditional Formatting

822. Conditional formatting

823. How to apply Conditional Formatting to an Excel table

824. How to apply cell background color using conditional formatting?

825. Highlight every n-th row?

826. Highlight every other group? Example 1

827. Highlight every other group? Example 2

828. Highlight unique values in a filtered Excel table

829. Example 3 - Scroll Bar and Conditional Formatting

830. Conditional formatting formula

831. Sort highlighted values

832. Highlight consecutive dates using Conditional Formatting

833. Highlight duplicates in a filtered Excel Table

834. Conditional formatting formulas

835. CF formula examples

____Highlight events in a yearly calendar

836. Highlight lookups in relational tables

837. How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas

838. Working with Conditional Formatting formulas

839. Highlight lookup values

840. How to highlight differences in price lists

841. How to apply CF formola

____Highlight records containing text strings (AND Logic)

____Highlight records [AND logic]

842. Highlight records – multiple criteria [OR logic]

843. Highlight closest number

844. Compare tables: Highlight records not in both tables

845. Compare two lists of data: Highlight common records

____Highlight duplicate columns

846. Highlight duplicate records

847. Highlight duplicate records - Excel 2007 and later versions

848. Highlight duplicate records - Excel 2003 and previous versions

849. How to create a conditional formatting formula

850. How the conditional formatting formula works

851. Highlight duplicates except for the first one

852. Highlight records based on overlapping date ranges and a condition

853. Highlight specific time ranges in a weekly schedule

854. Highlight overlapping date ranges using conditional formatting

855. Highlight duplicates with same date, week or month

856. Highlight odd/even months

857. How to highlight MAX and MIN value based on month

858. Highlight more than once taken course in any given day

859. Highlight smallest duplicate number

860. Highlight duplicate values in a cell range

861. Highlight unique values and unique distinct values in a cell range

____Highlight duplicates in two columns

____Compare two columns and highlight values in common

____Highlight missing values between to columns

862. How to highlight duplicate values

863. Highlight the smallest duplicate number

864. Highlight every other row

865. Highlight dates in a date range

866. How to highlight unique distinct values

867. How to highlight the largest and smallest value

868. Highlight unique distinct values [Conditional Formatting]

869. How to hide duplicate values [Conditional Formatting]

870. Put unique distinct values at the top of the list [Conditional Formatting]

871. Highlight unique values [Conditional Formatting]

Count

872. How to count the top 10 numbers in a cell range per row

873. How to count the bottom 10 numbers in a cell range per row

____How to count the top 10 numbers in a cell range (column-wise) per row

____How to count the top 10 numbers in a cell range per column

____How to count the bottom 10 numbers in a cell range per column

874. Sort based on row count

875. Sort based on item count

876. Count distinct values

____How to count blank cells

877. Count complete hours between two times

878. How to count workdays between two dates

879. Count a given pattern in a cell value

880. How to use the DCOUNTA function

881. How to use the DCOUNT function

882. Count cells with text

____Count cells with text excluding cells containing a space character

883. Count text values returned from an Excel function

884. Count text values excluding numbers stored as text

885. Count rows with data

886. Count cells equal to any value in a list

887. How to count cells in a cell reference

888. How to count cells in multiple refs

____Count characters based on condition example 1

____Count characters based on condition example 2

____Count characters based on a list

____Count characters in a formula

____Count total characters in multiple cell ranges combined

____How to use the COUNTBLANK function

____COUNTBLANK function example

____Count blanks in an array

____Count blanks based on a condition

____Count blanks based on a list

____Count blanks in a text string

____Count blanks in multiple cell ranges

889. How to use the COUNTA function

890. COUNTA function example

891. Count non-empty values in an array

892. Count non-empty values based on a condition

893. Count non-empty values based on a list

894. Count non-empty values in a string

895. Count non-empty cells in multiple cell ranges

896. Count non-empty cells per row

____Count non-empty cells per column

____Count columns in an array

____Count columns in a string

____Count columns in multiple cell ranges

____Count columns in multiple Excel Tables

897. Count rows in an array

898. Count rows based on a condition

899. Count rows in a string

900. Count rows in multiple cell ranges

901. How to use the COUNT function

902. COUNT function - example

903. COUNT function - count numbers in an array

904. COUNT function - count digits

905. COUNT function - count digits in cell range

906. COUNT function - count negative numbers

907. COUNT function - count positive numbers

908. COUNT function - count numbers in a given range

909. Count numbers per row

____Count numbers per column

910. AGGREGATE function - COUNT

911. AGGREGATE function - COUNTA

912. Count weekdays in a month

913. Count specific WEEKDAYS between two dates

____How to perform a case sensitive count based on a condition

____Split characters to a cell each horizontally counting backwards

914. Count cells containing text from list

____Are zeros counted in the AVERAGE function?

915. Does the SUBTOTAL function avoid double counting?

916. How to count the number of cells containing numbers based on filtered data?

917. How to count the number of not empty cells based on filtered data?

____How to use the COUNTIF function to count not blank cells

____Count not blank cells - COUNTIF function

____Count not blank cells - COUNTA function

918. COUNTIF and COUNTA function return unexpected results

____Count not blank cells - SUMPRODUCT function

919. OR function COUNTIF

920. Use IF + COUNTIF to evaluate multiple conditions

921. Use IF + COUNTIF to evaluate multiple conditions and different outcomes

922. Count unique distinct values based on a condition

____Count unique distinct values based on a condition - Excel 365

923. Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

924. Use price ranges to determine discount

925. How do I calculate a discount based on a linear equation?

926. How can I use multiple tables to calculate a discount based on different price levels?

927. Count matching strings using regular expressions

928. Count identical values if they are on the same row

929. Count identical values if they are on the same row (Array formula)

930. Count identical values if they are on the same row (Regular formula)

____Count identical values on the same row comparing values in n columns

931. Count overlapping days across multiple date ranges

932. Count value per row

933. Dynamic counting per row sorted from large to small

934. Count overlapping days in multiple date ranges, part 2

935. Count the number of overlapping date ranges for each date

936. Count dates overlapped by two or more date ranges

937. Count overlapping days in multiple date ranges

938. Count overlapping days for all date ranges

939. Count all overlapping days

940. How to count repeating values

941. How to count any contiguous value

942. How to count a specific contiguous value

943. How to count the number of values separated by a delimiter

944. How to count the number of values separated by a delimiter in a cell?

945. How to count the number of values separated by a delimiter in a cell range?

____How to count the number of values separated by a given character?

____How to merge data using two or more criteria with the COUNTIFS function

946. Count Conditionally Formatted cells

____How to count cells based on conditionally formatted background color [Excel 365]

947. How to count cells based on conditionally formatted background color [Previous Excel versions]

____Count cells based on conditionally formatted background color using Filter tool and SUBTOTAL function [Excel 365]

948. Count cells based on background color

____How to count cells with a specific background color (Excel 365)

949. How to count cells with a specific background color (Previous Excel versions)

950. Count unique distinct values by cell color

951. How to use the COUNTIFS function

952. COUNTIFS function example

____COUNTIFS function - Partial match using wildcard characters

953. COUNTIFS function - using two conditions

954. COUNTIFS function - Logical operators

955. COUNTIFS function - Count duplicate records

956. COUNTIFS function - return an array identifying records based on multiple conditions

957. COUNTIFS function - OR logic

958. COUNTIFS function - how to use dates

959. COUNTIFS function - after a date

960. COUNTIFS function - before a date

961. How to make the COUNTIFS function work with a dynamic range

962. How to count entries in Excel by date and an additional condition

963. How to use the COUNTIF function

964. COUNTIF Function - How to count cells equal to a condition?

965. COUNTIF Function - Count cells larger/less than a criterion

966. COUNTIF Function - Count cells containing a text string - partial match (wildcard)

967. COUNTIF Function - Absolute and relative cell reference

968. How to use the COUNTIF function with multiple values (array formula)

____COUNTIF Function - How to count cells containing x number of characters?

____COUNTIF Function - Dynamic array formula (Excel 365)

969. Count specific multiple text strings in a given cell range

____Count specific multiple text strings in a given cell range - case sensitive

____Count specific multiple text strings in a given cell range - case insensitive

970. Count unique distinct values in a filtered Excel defined Table

971. Unique distinct records sorted based on count or frequency

____Unique distinct records sorted based on count - Excel 365

972. Unique distinct records sorted based on count - Pivot Table

973. Unique distinct records sorted based on count or frequency - earlier Excel versions

974. Count groups of repeated values per row

975. Count a specific weekday in a date range

976. Count weekday within date range except holidays

977. Count cells between specified values

978. Count entries based on date and time

979. Count unique distinct values that meet multiple criteria

980. How to count unique distinct items based on a condition and a date condition?

981. Count unique distinct values in an Excel Pivot Table

982. Count unique distinct records (rows) in a Pivot Table

983. Count unique distinct records - Pivot Table

984. Count duplicate records - Pivot Table

____Count unique distinct records with a date and column criteria

____Count unique distinct rows case sensitive

985. Count digits and ignore duplicates

986. Count unique distinct records

987. Count cells based on a condition and month

____Count groups in calendar

988. Count unique distinct values within same week, month or year

989. How to count unique distinct values based on a date

____Count unique distinct numbers across multiple sheets

990. Create a number sequence to count records by year and month (sorted list)

991. Create a number sequence to count records by year and month (unsorted list)

992. Create a number sequence to count dates based on year

993. Create a number sequence to count items

994. Create a number sequence to count prices within given amounts

995. Create a number sequence to count records by individual products and years

996. Count cells between two values

997. How to count VLOOKUP results

998. Count unique distinct months

____Count text string in a range (case sensitive)

999. Count a specific text string in a cell

____Count text string in a range (case sensitive)

____Count a given pattern in a cell value

____Count unique distinct values in two columns

1000. Count unique distinct values

_____Count unique distinct values in a cell range with blanks - Excel 365

_____Count unique distinct values in multiple nonadjacent cell ranges - Excel 365

_____Count unique distinct values in a cell range with blanks

_____Count unique distinct values (case sensitive)

_____Count unique distinct values in two columns

_____Count unique values (case sensitive)

1001. Count dates inside a date range

_____Count how many times a string exists in a cell range (case insensitive)

Countif

_____How to use the COUNTIF function to count not blank cells

_____Count not blank cells - COUNTIF function

_____COUNTIF and COUNTA function return unexpected results

_____OR function COUNTIF

_____Use IF + COUNTIF to evaluate multiple conditions

_____Use IF + COUNTIF to evaluate multiple conditions and different outcomes

_____How to use the COUNTIF function

_____COUNTIF Function - How to count cells equal to a condition?

_____COUNTIF Function - Count cells larger/less than a criterion

_____COUNTIF Function - Count cells containing a text string - partial match (wildcard)

_____COUNTIF Function - Absolute and relative cell reference

_____How to use the COUNTIF function with multiple values (array formula)

_____COUNTIF Function - How to count cells containing x number of characters?

_____COUNTIF Function - Dynamic array formula (Excel 365)

Countifs

_____How to merge data using two or more criteria with the COUNTIFS function

_____How to use the COUNTIFS function

_____COUNTIFS function example

_____COUNTIFS function - Partial match using wildcard characters

_____COUNTIFS function - using two conditions

_____COUNTIFS function - Logical operators

_____COUNTIFS function - Count duplicate records

_____COUNTIFS function - return an array identifying records based on multiple conditions

_____COUNTIFS function - OR logic

_____COUNTIFS function - how to use dates

_____COUNTIFS function - after a date

_____COUNTIFS function - before a date

_____How to make the COUNTIFS function work with a dynamic range

Criteria, multiple conditions, conditions

1002. Filter values based on criteria

1003. MINIFS function multiple criteria ex 1

1004. MINIFS function multiple criteria ex 2

1005. Get largest number based on multiple conditions

1006. MAXIFS function - criteria

1007. LARGE function - based on criteria

_____Is the criteria argument in the AVERAGEIF function case sensitive?

1008. SUMIFS function multiple criteria

1009. INDEX and MATCH – multiple criteria and multiple results

1010. INDEX and MATCH - multiple criteria and multiple results

_____INDEX and MATCH - multiple criteria and multiple results (Excel 365)

_____AVERAGE based on criteria

1011. Find cells containing all conditions

_____Find cells containing all conditions (Excel 365)

1012. SMALL function – multiple conditions

_____SMALL function - multiple conditions AND logic

1013. SMALL function - multiple conditions OR logic

1014. SUMPRODUCT – multiple criteria

1015. SUMPRODUCT - multiple conditions and a date range

_____How to do a partial case sensitive match using two conditions in two columns

1016. INDEX MATCH with multiple criteria

1017. INDEX MATCH - multiple criteria

_____INDEX MATCH - partial text multiple conditions Excel 365

1018. OR function - multiple conditions

_____Use IF + COUNTIF to evaluate multiple conditions

_____Use IF + COUNTIF to evaluate multiple conditions and different outcomes

1019. IF function with AND function – multiple conditions

1020. How to add criteria

1021. How to simplify nested IF functions based on conditions

1022. How to sum numbers using a list of conditions

1023. Filter duplicate values based on criteria

1024. Filter duplicate values using criteria - earlier Excel versions

_____Filter duplicate values using criteria - Excel 365

_____Filter duplicate values using criteria - Autofilter

1025. Filter duplicate values using criteria - Excel Table

1026. Lookup and match last value - two conditions AND - logic

1027. Find the last matching value - two conditions OR - logic

1028. SUM with multiple conditions

1029. Using multiple criteria in VLOOKUP

_____How to merge data using two or more criteria with the COUNTIFS function

1030. Lookup value based on two critera – second criteria is the adjacent value and its position in a given list

1031. Wildcard lookups and include or exclude criteria

_____Wildcard lookups and include or exclude criteria - Excel 365

1032. Wildcard lookups and include or exclude criteria - array formula

_____Wildcard lookups and include or exclude criteria - autofilter

1033. Lookup with any number of criteria

1034. Lookup with an unknown number of criteria [Array Formula]

1035. How to use multiple conditions in the SUMPRODUCT function

1036. How to use SMALL function with criteria?

_____COUNTIFS function - using two conditions

_____COUNTIFS function - return an array identifying records based on multiple conditions

1037. Lookup using multiple conditions

1038. Repeat the range according to criteria in loop

1039. How to use VLOOKUP/XLOOKUP with multiple conditions

_____VLOOKUP function with two conditions applied to two columns (AND logic)?

_____VLOOKUP function with two conditions applied to two columns (OR logic)?

_____VLOOKUP function with many conditions applied to one column (OR logic)?

_____XLOOKUP - two conditions in two columns (AND logic)?

_____XLOOKUP - two conditions in two columns (OR logic)?

_____XLOOKUP - multiple conditions in one column (OR logic)?

1040. Perform thousands of conditions to a data set

1041. Find entry based on conditions

1042. Filter unique distinct records using criteria

_____Count unique distinct values that meet multiple criteria

1043. Sum cells based on criteria

_____Count unique distinct records with a date and column criteria

1044. Running totals based on criteria

1045. Running totals based on criteria - formula

1046. Running totals based on criteria - formula and Excel Table

1047. Running totals based on criteria - Excel Table

_____Highlight records – multiple criteria [OR logic]

1048. Sort rows based on frequency and criteria

_____Sort rows based on frequency and criteria - Excel 365

1049. Sort rows based on frequency and criteria - earlier versions

1050. Get the smallest number larger than a given number and criteria

1051. Match two criteria and return multiple records

1052. Match two criteria and return multiple records [Array Formula]

_____Match two criteria and return multiple records [Excel 365]

1053. Match two criteria and return multiple records [Excel defined Table]

1054. FILTER records based on three conditions

1055. Vlookup with 2 or more lookup criteria and return multiple matches

1056. Lookup and find the most recent date using multiple conditions

1057. Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

1058. Extract records where all criteria match if not empty

_____Extract all rows from a range that meet criteria in one column

1059. Extract all rows from a range based on range criteria (Array formula)

_____Extract all rows from a range based on range criteria - Excel 365

1060. Extract all rows from a range based on multiple conditions (Array formula)

_____Extract all rows from a range based on multiple conditions - Excel 365

1061. How to create a unique distinct list based on two conditions

1062. Partial match based on two conditions

1063. Partial match with two conditions and return multiple results

1064. Partial match with two conditions and return multiple search results

_____Partial match with two conditions and return multiple search results - Excel 365

1065. Create a unique distinct list based on criteria

Date

1066. Calculate dates for each date range

1067. Get historical stock prices based on ticker/symbol and date range

1068. How to split date value

1069. How to create a sequence of dates based on a start date?

_____Highlight current date

_____How to highlight dates based on day of week

_____Highlight a date occuring [Conditional formatting]

_____Highlight a date occurring...

_____Highlight a date occurring yesterday

_____Highlight a date occurring today

_____Highlight a date occurring tomorrow

_____Highlight a date occurring in the last 7 days

_____Highlight a date occurring last week

_____Highlight a date occurring this week

_____Highlight a date occurring next week

_____Highlight a date occurring last month

_____Highlight a date occurring this month

_____Highlight a date occurring next month

_____Highlight a row if the date is yesterday

_____Highlight a row if the date is today

_____Highlight a row if the date is tomorrow

_____Highlight a row if the date is in the last 7 days

_____Highlight a row if the date is last week

_____Highlight a row if the date is in this week

_____Highlight a row if the date is in next week

_____Highlight a row if the date is in the last month

_____Highlight a row if the date is in this month

_____Highlight a row if the date is in the next month

1070. Calculate the number of weeks between given dates

1071. Calculate the number of weeks and days between given dates

1072. Calculate the number of weeks and days between given dates - dynamic text values

1073. How to calculate the number of months between dates

1074. How to calculate the number of years between dates

_____How to count workdays between two dates

1075. Get date ranges from a schedule

_____Get date ranges from a schedule - Excel 365

1076. Get date ranges from a schedule - earlier Excel versions

1077. MINIFS function date

1078. Sum overlapping time based on a date range

1079. How to use the EDATE function

1080. DATEVALUE function not working

1081. Verify your date and time settings

1082. Convert a text date to an Excel date using a formula

1083. CONCAT function and date and time values

1084. How to round a date to the nearest given weekday?

1085. How to round a date to the nearest upcoming weekday?

1086. How to use the DATEVALUE function

1087. How to use the DATEDIF function

1088. Split date from a date and time value

1089. Split time from a date and time value

_____Count specific WEEKDAYS between two dates

1090. WEEKDAYS between dates

1091. Filter dates based on day

1092. Filter dates based on month

1093. Days between two dates

1094. SUMPRODUCT if between two dates

_____SUMPRODUCT - multiple conditions and a date range

1095. SUMPRODUCT - multiple date ranges

1096. Sum numbers between two dates

1097. How to simplify nested IF functions based on date ranges

1098. Calculate year from date?

1099. Extract year when the date is located at the end of the text string

1100. Extract year when the date is located somewhere in the middle of the text string

1101. Extract year when the date is located at the beginning of the text string

1102. Is date an Excel date?

1103. How to calculate years between dates?

1104. How to convert year to a date?

1105. Year and month to date?

1106. How to use the DATE function

1107. Date function example

1108. What does the Date function do?

1109. Date function format

1110. Date function not working

1111. How to make Excel order by date

1112. Date function add days

1113. Date function subtract days

1114. Date function add months

1115. Date formats

1116. How to sum based on a date

1117. How to sum if a date is later than a given condition

1118. How to sum if a date is earlier than a given condition

1119. Lookup based on a date range and a condition return multiple values

1120. Lookup a date range and a condition - return multiple values

_____Lookup a date range and a condition - return multiple values - Excel 365

1121. Find the last matching date based on a date range

1122. How to sum values by date?

1123. How to sum values between two dates?

1124. VLOOKUP between dates

1125. See all events on a specific date

_____How to extract the moving average turning dates

1126. Create a date range

1127. Find and return the highest number and corresponding date based on a condition

_____Count overlapping days across multiple date ranges

1128. Calculate date given weekday and week number

1129. Calculate date given weekday and week number (week starts on Sunday)

1130. Calculate date given weekday and week number (week starts on Monday)

_____Count overlapping days in multiple date ranges, part 2

_____Count the number of overlapping date ranges for each date

_____Count dates overlapped by two or more date ranges

_____Count overlapping days in multiple date ranges

_____Count overlapping days for all date ranges

1131. Find empty dates in a set of date ranges

_____Find empty dates in a set of date ranges - Excel 365

1132. Find empty dates in a set of date ranges - earlier versions

1133. Working with overlapping date ranges

1134. Calculate the number of overlapping date ranges

1135. Use a drop-down list to select a date range to see overlapping date ranges

1136. Find most overlapped date range

1137. Least overlapped date range

1138. Most overlapped date

1139. Least overlapped date

1140. Find earliest and latest overlapping dates in a set of date ranges based on a condition

1141. Find all sequences of consecutive dates

_____Find all sequences of consecutive dates - Excel 365

_____List non consecutive dates - Excel 365

1142. Find all sequences of consecutive dates - earlier Excel versions

1143. List non consecutive dates - earlier Excel versions

_____Highlight consecutive dates using Conditional Formatting

_____COUNTIFS function - how to use dates

_____COUNTIFS function - after a date

_____COUNTIFS function - before a date

_____How to count entries in Excel by date and an additional condition

1144. How to calculate totals of stock transactions based on dates

1145. Prevent overlapping date and time ranges using data validation

1146. Find date range based on a date

1147. How to use VLOOKUP with dates?

1148. How to use XLOOKUP with dates?

1149. Search related table based on a date and date range

_____Plot date ranges in a calendar part 2

1150. Create date ranges that stay within month

_____Count a specific weekday in a date range

1151. Schedule project dates based on a finish date

1152. How to create random numbers, text strings, dates and time values

1153. Random date values

1154. Extract week ranges based on a given date range

_____Count weekday within date range except holidays

_____Count entries based on date and time

_____How to count unique distinct items based on a condition and a date condition?

1155. 7 days (weekly) date ranges using a formula

_____Count unique distinct records with a date and column criteria

1156. Filter records based on a date range and a text string

1157. Filter overlapping date ranges

_____Filter overlapping date ranges - Excel 365

1158. Tracking a stock portfolio in excel (auto update)

_____Lookup and return multiple dates concatenated into one cell [Array Formula]

_____Lookup within a date range and return multiple values concatenated into one cell [Array Formula]

1159. Automate Excel: Update list with new values

_____Highlight records based on overlapping date ranges and a condition

1160. Extract dates from a cell block schedule

1161. Extract dates from overlapping date ranges

_____Extract dates from overlapping date ranges - Excel 365

1162. Convert date ranges into dates

_____Convert date ranges into dates - Excel 365

1163. Convert date ranges into dates - earlier Excel versions

1164. Convert dates into date ranges

1165. List dates outside specified date ranges

_____List dates outside specified date ranges - Excel 365

_____List empty gaps as date ranges - Excel 365

_____Plot date ranges in a calendar

_____Highlight overlapping date ranges using conditional formatting

1166. Identify overlapping date ranges

1167. Identify overlapping date ranges based on a condition

_____Highlight duplicates with same date, week or month

1168. Filter duplicates within same date, week or month

_____How to count unique distinct values based on a date

1169. Remove duplicates based on date

1170. Extract unique distinct year and months from dates

_____Extract unique distinct year and months from dates - Excel 365

_____Extract sorted unique distinct years and months based on a list of dates - Excel 365

1171. Extract unique distinct year and months from dates - older Excel versions

1172. How to create a series of dates

1173. How to create a series of dates based on a given period

_____Create a number sequence to count dates based on year

1174. Formula for matching a date within a date range

1175. Match a date when a date range is entered in a single cell

1176. Match a date when a date range is entered in two cells sorted in ascending order

1177. Match a date when a date range is entered in two cells with gaps not sorted

1178. Use VLOOKUP to search date in date ranges and return value on the same row

1179. Match a date when date ranges sometimes overlap and return multiple results

1180. Find the most recent date that meets a particular condition

1181. Lookup a value and find the most recent date

1182. Lookup a value and find the most recent date (Pivot Table)

1183. Lookup all values and find the most recent dates

_____Lookup and find the most recent date using multiple conditions

_____Lookup and find the most recent date on multiple sheets

1184. Lookup and find the most recent date, return another value on the same row

1185. Sum values between two dates and based on a condition

1186. Most frequent value between two dates

_____Most frequent value between two dates - Autofilter

1187. Lookup min max values within a date range

1188. Create a quartely date range

1189. Create a quarterly date range using a clever built-in feature in Excel

1190. Quarterly date ranges using a formula

1191. Quarterly date ranges in one cell each

1192. Create a monthly date range

_____Create a list of dates with blanks between quarters

1193. List values with past date

1194. Filter duplicate values and sort by corresponding date

1195. Filter unique values and sort based on adjacent date

1196. Advanced custom date filter

1197. Create a date range [Formula]

1198. Sort dates within a date range

1199. Lookup the nearest date

1200. Filter unique distinct values based on a date range

_____Filter unique distinct values based on a date range (Excel 365)

_____Highlight dates in a date range

_____Count dates inside a date range

1201. Extract records between two dates

_____Filter rows using array formulas based on a date range - Excel 365

1202. Filter rows using array formulas based on a date range - earlier Excel versions

1203. Filter rows using an Excel table based on a date range

_____Filter rows based on a date range - Autofilter

1204. How to calculate a date based on specific weekday in a month

1205. How to identify two consecutive dates in a list

1206. Calculate last date of a given month

1207. Find the most recent date in a list

Day

_____How to highlight dates based on day of week

_____Highlight a date occurring yesterday

_____Highlight a date occurring today

_____Highlight a date occurring in the last 7 days

_____Highlight a row if the date is yesterday

_____Highlight a row if the date is today

_____Highlight a row if the date is in the last 7 days

_____Calculate the number of weeks and days between given dates

_____Calculate the number of weeks and days between given dates - dynamic text values

1208. How to use the NETWORKDAYS.INTL function

_____How to count workdays between two dates

1209. How to use the WORKDAY function

1210. How to use the DAYS function

_____How to round a date to the nearest given weekday?

_____How to round a date to the nearest upcoming weekday?

1211. How to use the TODAY function

1212. How to use the NETWORKDAYS function

1213. NETWORKDAYS Function example

1214. Create a list of weekdays only

_____Count weekdays in a month

_____Count specific WEEKDAYS between two dates

1215. How to use the WEEKDAY function

1216. WEEKDAY Function Video

1217. WEEKDAY Function example

1218. WEEKDAY Function not working

1219. WEEKDAY function - show weekday name

_____WEEKDAYS between dates

1220. How to use the DAY function

1221. DAY Function example

1222. DAY Function not working

_____DAY function alternative

_____Filter dates based on day

_____Create a dynamic calendar using the DAY function

1223. How do I sum values between n-th weekday this month and n-th weekday next month?

_____Days between two dates

1224. The year begins on what weekday?

1225. Add or subtract months and days

_____Date function add days

_____Date function subtract days

1226. Last day of a given month

_____Count overlapping days across multiple date ranges

_____Calculate date given weekday and week number

_____Calculate date given weekday and week number (week starts on Sunday)

_____Calculate date given weekday and week number (week starts on Monday)

1227. How to sum time across days with a start and end time each day

_____Count overlapping days in multiple date ranges, part 2

_____Count overlapping days in multiple date ranges

_____Count overlapping days for all date ranges

_____Count all overlapping days

1228. Calculate total cost based on different rates per hour across days

1229. Worksheet Day

_____Count a specific weekday in a date range

_____Count weekday within date range except holidays

_____7 days (weekly) date ranges using a formula

_____Highlight more than once taken course in any given day

_____How to calculate a date based on specific weekday in a month

Decimal

1230. How to round a number to n decimals?

1231. How to convert large decimal numbers to binary?

1232. How to use the DECIMAL function

1233. Split string and remove decimals

1234. How to insert 0 (zeros) to the right of the decimal point

1235. How to add 0 (zeros) to the right and left of the decimal point

1236. How to remove decimals from a division?

1237. How to remove decimals from a number?

1238. How to remove whole number and return decimal?

1239. Random numbers with a decimal

1240. Random negative numbers with two decimals

1241. Random negative numbers with three decimals

1242. Can a decimal number be used as a logical expression?

Delete, remove

_____TEXTSPLIT function - remove #N/A errors

_____Split string and remove decimals

_____How to remove unwanted characters in a cell

1243. How to remove numbers from a cell value

1244. How to remove numbers from a cell value (Excel 2016)

_____How to remove numbers from a cell value (Excel 365)

_____LEFT function remove characters

_____Delete blanks in the array

1245. How to delete an Excel Table value

1246. How to delete an Excel Table row

_____How to delete an Excel Table column

1247. How to delete an Excel Table and keep values

1248. Delete secondary y-axis

1249. Adjust and remove vertical axis

1250. Remove legend and major horizontal gridlines

_____How to remove decimals from a division?

_____How to remove decimals from a number?

_____How to remove whole number and return decimal?

1251. Remove totals

1252. How to remove checkboxes?

1253. Remove print preview lines (Page Breaks)

_____How to select and delete blank cells

1254. Delete a value

1255. Delete a cell

_____Select and delete blank cells

1256. Select and delete formulas returning a given condition

_____Macro deletes formulas returning a blank

_____Macro deletes entire row if the formula returns blanks

1257. Remove common records between two data sets

1258. Remove common rows between two Excel defined tables

1259. Remove common rows using an array formula between two data sets

_____Filter unique distinct values, sorted and blanks removed from a range

1260. Remove duplicates within same month or year

_____Remove duplicates based on date

1261. Remove errors, Excel version 2007 and later

1262. Remove errors, Excel version 2003 and earlier

_____Delete blanks and errors in a list

_____Remove blank cells

Digit

1263. How to sort by the first letter/digit?

1264. How to sort by the first digit - Example 3

1265. Convert multiple binary digit groups

_____COUNT function - count digits

_____COUNT function - count digits in cell range

1266. Identify digits in a string

1267. How to separate digits by a comma

1268. How to extract rows containing digits [Formula]

1269. Filter rows containing at least one digit in any cell on the same row (Array formula)

_____Filter rows containing at least one digit in any cell on the same row (Excel 365 formula)

1270. Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)

1271. Sum all digits in a number - (formula)

1272. Sort and return unique distinct single digits from cell range

_____Count digits and ignore duplicates

Dynamic

1273. EXPAND Function example - extend array dynamically

_____How to create a dynamic calendar using the SEQUENCE function?

_____Calculate the number of weeks and days between given dates - dynamic text values

_____Create a dynamic calendar using the DAY function

1274. Build dynamic named ranges

_____Excel 365 dynamic array formulas

_____Dynamic counting per row sorted from large to small

1275. Dynamic scoreboard

_____Dynamic scoreboard - Excel 365

_____How to make the COUNTIFS function work with a dynamic range

_____COUNTIF Function - Dynamic array formula (Excel 365)

1276. How to build a dynamic cell reference using the INDEX function

1277. Apply drop-down lists dynamically

1278. Create a dynamic named range

1279. Create a dynamic range

1280. Dynamic named range formula

1281. How to create a dynamic pivot table and refresh automatically

1282. Dynamic team generator

1283. Populate cells dynamically in a weekly schedule

1284. Dynamic formatting

Empty

1285. Rearrange values to the left if the cell is empty as far as possible

1286. Rearrange values to fill empty cells

_____Filter function - #CALC! error returns [if_empty] argument

_____Count non-empty values in an array

_____Count non-empty values based on a condition

_____Count non-empty values based on a list

_____Count non-empty values in a string

_____Count non-empty cells in multiple cell ranges

_____Count non-empty cells per row

1287. Sort rows based on the number of non-empty cells

_____Count non-empty cells per column

_____Sort columns based on the number of non-empty cells

_____Highlight empty cells

_____How to count the number of not empty cells based on filtered data?

1288. Find empty cells and sum cells above

1289. How to select empty cells in a cell range

1290. Populate empty cells with a formula

1291. Find the last non-empty cell with short cut keys

_____How to concatenate cell values ignoring empty cells

_____Find empty dates in a set of date ranges

_____Find empty dates in a set of date ranges - Excel 365

_____Find empty dates in a set of date ranges - earlier versions

1292. Navigate to first empty cell using a hyperlink formula

1293. Find empty hours in a weekly schedule

_____List empty gaps as date ranges - Excel 365

_____Extract records where all criteria match if not empty

Equal, condition, criterion

1294. Filter values based on a condition

_____Filter values based on a condition - case sensitive

1295. Filter values based on a condition sorted from A to Z

_____Filter values based on a condition per column - AND logic

_____Filter values based on a condition per column - OR logic

1296. How to do tiered calculations in one formula based on a condition

_____Highlight cells equal to

_____Count cells equal to any value in a list

1297. Why is i equal to the square root of -1?

_____Count characters based on condition example 1

_____Count characters based on condition example 2

_____Count blanks based on a condition

_____Count non-empty values based on a condition

_____Count rows based on a condition

1298. Get largest number based on a condition

1299. MAX function second-highest number based on a condition

1300. LARGE function - based on a condition

_____How to perform a case sensitive count based on a condition

_____Calculate an average based on a case sensitive condition

_____Calculate a sum based on a case sensitive condition

_____Calculate the median based on a case sensitive condition

1301. Find cells containing at least one condition

1302. SMALL function with duplicates based on a condition

1303. If cell equals value from list

1304. If cell equals value from list - regular formula

1305. If cell equals value from list - array formula

_____If cell equals value from list - case sensitive

1306. How to sum based on a condition

_____How to sum based on a condition in another column

1307. How to sum if a number is smaller than a given condition

1308. How to sum if a number is larger than a given condition

_____How to sum if a date is later than a given condition

_____How to sum if a date is earlier than a given condition

1309. Running totals with a condition

_____Count unique distinct values based on a condition

_____Count unique distinct values based on a condition - Excel 365

_____Lookup based on a date range and a condition return multiple values

_____Lookup a date range and a condition - return multiple values

_____Lookup a date range and a condition - return multiple values - Excel 365

1310. Extract a list of alphabetically sorted duplicates based on a condition

_____Extract a list of alphabetically sorted duplicates based on a condition - Excel 365

_____Concatenate cell values based on a condition

1311. Unique distinct list sorted alphabetically based on a condition

1312. Unique distinct list sorted alphabetically based on a condition - Earlier Excel versions

_____Unique distinct list sorted alphabetically based on a condition - Excel 365

1313. How to sum numbers based on a condition/label/item/category?

1314. How to insert a total to an Excel Table and sum using a condition

1315. List all permutations with a condition

_____Concatenate values based on a condition

_____Find and return the highest number and corresponding date based on a condition

1316. Find numbers in total with a condition

_____Find numbers in total with a condition - Excel 365

1317. Find the largest value in lookup_vector that is less than or equal to lookup_value

_____Merge tables based on a condition

_____Find earliest and latest overlapping dates in a set of date ranges based on a condition

_____Select and delete formulas returning a given condition

1318. FREQUENCY function with a condition

_____Cell ranges with an equal number of rows and columns

_____How to count entries in Excel by date and an additional condition

1319. Is 0 (zero) equal to FALSE in a logical expression?

1320. Is 1 equal to TRUE in a logical expression?

1321. Is -1 (negative number) equal to TRUE in a logical expression?

1322. IF function - equals

1323. IF function - equals multiple values

_____COUNTIF Function - How to count cells equal to a condition?

_____COUNTIF Function - Count cells larger/less than a criterion

1324. Match cell that ends with the condition

1325. Match cell that begins with the condition

1326. Group rows based on a condition

1327. Extract table headers based on a condition

1328. Compare two tables using a condition

_____How to count unique distinct items based on a condition and a date condition?

1329. Filter unique distinct records with a condition

_____Count cells based on a condition and month

_____Highlight records based on overlapping date ranges and a condition

1330. Extract a unique distinct list based on a condition [Pivot Table]

1331. Extract a unique distinct list and sum amounts based on a condition

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition

_____List unique distinct sorted values removing blanks based on a condition - Excel 365

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

_____Identify overlapping date ranges based on a condition

1332. Get the smallest number larger than a given number and a condition

1333. Create a number sequence and restart when a cell value equals a condition

1334. Filter duplicate values in a range using “contain” condition

_____Find the most recent date that meets a particular condition

_____Sum values between two dates and based on a condition

_____How to apply a condition to the Autofilter

1335. VLOOKUP - Extract multiple records based on a condition

1336. Sum cells containing numbers and text based on a condition

1337. Split values equally into groups

1338. Create a list of duplicates where adjacent cell value meets a condition

1339. How to rank uniquely based on a condition

1340. Extract unique distinct records based on a criterion

1341. Find closest value with a criterion

Error, problem

1342. IMTAN function error

_____IMSINH function not working #NUM error

_____IMSIN function not working - #NUM error

_____IMSECH function not working - #NUM error

_____IMSEC function not working - #NUM error

_____The IMLOG10 function not working - #NUM error

_____The IMLN function not working - #NUM error?

_____IMCOT function not working - #NUM error

_____IMCOS function not working - #NUM error

1343. BIN2HEX Function error

_____IMAGE function - #CONNECT error

_____IMAGE function - #BUSY error

1344. EXPAND Function example - errors

_____CHOOSECOLS function returns a #VALUE! error

1345. CHOOSEROWS Function errors

1346. DROP Function errors

_____TOROW Function - blanks and errors

_____TOCOL Function - blanks and errors

1347. HSTACK Function errors

1348. VSTACK Function errors

_____TEXTSPLIT function - remove #N/A errors

_____Why does the RANDARRAY function return a #SPILL! error?

_____The RANDARRAY function returns a #NAME! error?

_____Why does the SEQUENCE function return a #SPILL! error?

_____The SEQUENCE function returns a #NAME! error?

_____Why does the SORTBY function return a #SPILL! error?

_____The SORTBY function returns a #NAME! error?

_____Why does the SORT function return a #SPILL! error?

_____Why does the FILTER function return a #NAME? error?

_____The FILTER function returns a #SPILL! error, why?

_____Why does the FILTER function return a #CALC! error?

1349. Can the FILTER function handle error values?

_____Filter function - #CALC! error returns [if_empty] argument

1350. How to ignore error values using the SMALL function

1351. How to use the ERROR.TYPE function

1352. ERROR.TYPE function example

1353. Why is the VAR.P function returning an error?

1354. BIN2OCT Function error

_____BIN2HEX Function error

1355. BIN2DEC Function error

_____ACCRINT function #VALUE! error

1356. DEC2OCT Function error

1357. DEC2HEX Function error

1358. DEC2BIN Function error

1359. CONVERT Function error

_____COMPLEX Function error

1360. Why does the MODE.MULT function return an error?

1361. Monitor cell ranges for formula errors

1362. Excel error functions

1363. How to use the ISERROR function

1364. ISERROR function example

_____Excel error functions

1365. Error in data

_____#NAME! error

_____MAX function ignore #N/A error

_____What is #N/A error

1366. How to extract the largest number ignoring error values

1367. How to extract the largest number ignoring error values using arrays

_____CODE function returns #VALUE! error!

_____How to extract the largest number ignoring error values

1368. Can the ISNUMBER function handle error values?

1369. MIN function ignore errors

_____MIN function ignore #NA error

_____Highlight cells containing errors

_____AVERAGE function can't handle errors

_____Average - ignore blanks and errors

1370. SUMPRODUCT if not error

_____Formula not working - #NAME! error

_____The OR function returns a #NAME! error

_____The OR function returns a #VALUE! error

_____YEAR function returns #NAME! error

_____YEAR function returns #VALUE! error

_____YEAR function returns #NUM! error

1371. Reference isn't valid error

1372. Cannot open the specified file error

1373. Excel found a problem with one or more formula references

1374. Can it handle errors?

_____How to sum a column and ignore errors?

1375. How to handle VLOOKUP errors

1376. How to disable Data Validation error alert

1377. How to use the IFERROR function

1378. IFERROR function example

1379. What errors doesn't the IFERROR function catch?

_____How to catch the #N/A Error?

_____How to catch the #VALUE! error?

_____How to catch the #REF Error?

_____How to catch the #DIV/0 Error

_____How to catch the #NUM Error

_____How to catch the #NAME Error

_____How to catch the #NULL Error

1380. How can I find all errors in a worksheet?

1381. IFERROR function simplifies finding errors in formulas

_____Excel error functions

1382. IF function - How to check if a cell contains an error?

1383. INDEX function error

_____Remove errors, Excel version 2007 and later

_____Remove errors, Excel version 2003 and earlier

_____Delete blanks and errors in a list

1384. How to find errors in a worksheet

Extend, expand

1385. How to use the EXPAND function

1386. EXPAND Function example

1387. EXPAND Function example - how to extend an array up and left

_____EXPAND Function example - extend array dynamically

_____EXPAND Function example - errors

1388. EXPAND Function - values in random order

1389. Create auto expanding named ranges

1390. Create another two auto expanding named ranges on sheet "Calculation"

Extract, list, filter, get

1391. Get Excel *.xlsx file

_____Get historical stock prices based on ticker/symbol and date range

_____Enable Autofilter

_____Get Excel *.xlsx file

1392. Get Excel * .xlsx file

_____Get Excel *.xlsx file

1393. Show an image based on a drop-down list

1394. Add a drop down list

_____Get Excel *.xlsx file

1395. Extract values between two given delimiting strings

1396. Extract values between two given strings in a cell range

_____Extract a unique distinct list across multiple columns and rows sorted based on frequency

_____Extract values from given columns and return the list in random order - Excel 365

1397. Get every other row

_____Get Excel *.xlsx file

1398. Extract unique distinct values from a cell range

1399. Extract unique distinct values from multiple cell ranges

_____Get Excel *.xlsx file

_____Extract unique distinct columns from multiple cell ranges

_____Get Excel *.xlsx file

1400. Extract unique distinct rows from multiple cell ranges

_____Get Excel *.xlsx file

1401. Extract string between two substrings

_____Get Excel *.xlsx file

1402. How to get daily historical stock prices in Excel

1403. How to get weekly historical stock prices

1404. How to get historical monthly stock prices

1405. How to get historical closing stock prices

_____Get Excel *.xlsx file

1406. How to use the FILTERXML function

1407. FILTERXML Function example

1408. How to extract XML attribute?

1409. FILTERXML function not working

1410. How to create a list of unique distinct numbers sorted in random order

1411. How to reverse a list using the SEQUENCE function?

1412. How to sort by custom list?

1413. How to use the FILTER function

1414. FILTER Function example

_____Filter values based on a condition

_____Why does the FILTER function return a #NAME? error?

1415. Is the FILTER function available for Excel versions 2003, 2007, 2010, 2013, 2016, and 2019?

_____The FILTER function returns a #SPILL! error, why?

_____Why does the FILTER function return a #CALC! error?

1416. Can I use the FILTER function with an Excel Table and structured references?

_____Can the FILTER function handle error values?

_____Is the FILTER function case sensitive?

_____Filter values based on a condition - case sensitive

1417. Filter values if not equal to

1418. Filter values if smaller than

1419. Filter values if larger than

1420. Filter values if contains

1421. Filter values if not contain

1422. Filter values that begin with

1423. Filter values that end with

_____Filter values based on a condition sorted from A to Z

_____Filter values based on criteria

_____Filter values based on a condition per column - AND logic

_____Filter values based on a condition per column - OR logic

_____Filter function - #CALC! error returns [if_empty] argument

1424. Extract unique distinct values sorted from A to Z

_____Extract unique distinct values ignoring blanks

_____Extract unique distinct values sorted from A to Z ignoring blanks

1425. Extract unique values

1426. Extract unique values sorted from A to Z

_____Extract unique values ignoring blanks

_____Extract unique values sorted from A to Z ignoring blanks

1427. Extract unique distinct rows

_____Extract unique distinct rows ignoring blank rows

_____Extract unique distinct rows sorted from A to Z ignoring blank rows

1428. Extract unique rows

_____Extract unique rows ignoring blank rows

_____Extract unique rows sorted from A to Z ignoring blank rows

1429. How to copy every n-th row from a list

_____Get Excel *.xlsx file

1430. Extract the most frequent text value - MODE.SNGL function

_____Get Excel *.xlsx file

_____Get date ranges from a schedule

_____Get date ranges from a schedule - Excel 365

_____Get date ranges from a schedule - earlier Excel versions

1431. Extract unique distinct records from two data sets

_____Get Excel *.xlsx file

1432. Extract n-th word in cell value

_____Extract n-th word in cell value - Excel 365

1433. How to use the DGET function

_____Get Excel *.xlsx file

_____Count cells equal to any value in a list

_____Get Excel *.xlsx file

1434. Extract the most frequent text values

_____How to filter using OR logic between columns [Formula]

1435. Get the latest revision

_____Get Excel *.xlsx file

1436. How to extract numbers from a cell value

_____Get Excel *.xlsx file

1437. Extract the hour from a time value

1438. Extract the minute from a time value

_____Get Excel *.xlsx file

_____List combinations - Excel 365 formula

_____Get Excel *.xlsx file

1439. Create a list of permutations using an Excel formula

_____Count characters based on a list

_____Get Excel *.xlsx file

_____Count blanks based on a list

_____Count non-empty values based on a list

_____Get Excel *.xlsx file

_____Get largest number based on a condition

_____Get largest number based on multiple conditions

1440. Get most frequent value

1441. Get the highest number within each row

_____Get the highest number within each column

_____How to extract the largest number ignoring error values

_____How to extract the largest number ignoring error values using arrays

1442. LARGE function - based on a list

_____How to extract the k-th largest number in a 3D range

_____Get Excel *.xlsx file

_____How to list all characters based on ANSI code

_____Get Excel *.xlsx file

_____List all characters based on ANSI numbers - CODE Function

_____Get Excel *.xlsx file

_____How to extract the largest number ignoring error values

_____Get Excel *.xlsx file

_____Create a list of weekdays only

_____Get value based on row and column number

_____Get value based on row and column number - ADDRESS function alternative

_____Get value based on a row and column number and a worksheet name

_____Extract column letter - Excel 365

_____Get Excel *.xlsx file

_____Filter dates based on day

_____Filter dates based on month

_____Get Excel *.xlsx file

1443. REPT function based on list

_____REPT function based on list and concatenated

_____Get Excel *.xlsx file

1444. Extract last word in cell

1445. Extract the last word

1446. Extract the last letter

1447. Extract the last number

_____Get Excel *.xlsx file

1448. Extract first word in cell

1449. CHOOSE function from list

_____Get Excel *.xlsx file

1450. CHOOSE function drop-down list

_____CHOOSE function from list

_____Get Excel *.xlsx file

_____Count cells containing text from list

_____Get Excel *.xlsx file

1451. SUMPRODUCT - based on a list of values

_____Get Excel *.xlsx file

_____If cell equals value from list

_____If cell equals value from list - regular formula

_____If cell equals value from list - array formula

_____If cell equals value from list - case sensitive

_____Get Excel *.xlsx file

1452. How to sum filtered data?

_____How to count the number of cells containing numbers based on filtered data?

_____How to count the number of not empty cells based on filtered data?

1453. How to extract the largest number from filtered data?

1454. How to extract the smallest number from filtered data?

_____How to calculate an average based on filtered data?

_____Extract filtered values - Excel 365

1455. If cell contains text from list

1456. Check if the cell contains any value in the list

1457. Display matches if cell contains text from list (Excel 2019)

1458. Display matches if cell contains text from list (Earlier Excel versions)

_____Filter delimited values not in list (Excel 365)

1459. Check if cell contains value in the list and return the corresponding value

1460. Get Excel *.xlsx file

1461. How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

_____Get Excel *.xlsx file

_____How to sum numbers using a list of conditions

_____How to extract a case sensitive unique list from a column

_____Extract a case sensitive unique list from a column

_____Extract a case sensitive unique list from a column - Excel 365

1462. Get *.xlsx file

_____Extract a list of alphabetically sorted duplicates based on a condition

_____Extract a list of alphabetically sorted duplicates based on a condition - Excel 365

_____Get *.xlsx file

1463. Extract duplicate values with exceptions

1464. Extract duplicate values without exceptions

_____Extract duplicate values without exceptions - Excel 365

_____Get *.xlsx file

_____Filter duplicate values based on criteria

_____Filter duplicate values using criteria - earlier Excel versions

_____Filter duplicate values using criteria - Excel 365

_____Filter duplicate values using criteria - Autofilter

_____Filter duplicate values using criteria - Excel Table

_____Get *.xlsx file

1465. Extract the last value in a given cell range

_____Extract a corresponding value next to the last value in a column

_____Get *.xlsx file

_____Unique distinct list sorted alphabetically based on a condition

_____Unique distinct list sorted alphabetically based on a condition - Earlier Excel versions

_____Unique distinct list sorted alphabetically based on a condition - Excel 365

1466. Unique distinct list sorted alphabetically based on a range - Earlier Excel versions

_____Unique distinct list sorted alphabetically based on a range - Excel 365

_____Get *.xlsx file

1467. Find the last matching value based on a list of values

_____Get *.xlsx file

1468. Extract multiple values based on a search value sorted from A to Z

_____Extract multiple values based on a search value sorted from A to Z (Excel 365)

_____Get *.xlsx file

1469. Get *.xlsm file

_____How to sum a filtered column?

1470. Get Excel *.xlsm file

1471. Get Excel *.xlsm and *.xlsx files

1472. VLOOKUP and HLOOKUP together

_____Get Excel *.xlsm file

1473. Extract XML using a formula - FILTERXML (Excel 2013)

1474. How to filter an Excel Table

1475. List all tables in a workbook - Named ranges

1476. How to link a drop-down list to an Excel Table (Data validation)

1477. Working with filtered Excel Tables

1478. Extract cell references from a formula

_____How to extract rows containing digits [Formula]

_____Filter rows containing at least one digit in any cell on the same row (Array formula)

_____Filter rows containing at least one digit in any cell on the same row (Excel 365 formula)

_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)

1479. List permutations with repetition and how many to choose from

_____List permutations with repetition and how many to choose from (Excel 365 formula)

_____List all permutations with a condition

_____How to extract the moving average turning dates

_____Get Excel *.xlsx file

1480. Insert a drop down list

_____Use a drop-down list to select a date range to see overlapping date ranges

1481. How to automatically add new items to a drop down list

1482. Build a Drop-Down List

1483. Drop-Down List containing values sorted from A to Z

1484. Filter duplicate files in a folder and subfolders

_____Extract the most repeated adjacent values in a column

_____Compare two lists and filter unique values where the sum in one column doesn’t match the other column

_____Get Excel *.xlsx file

1485. Nihilist cipher

_____Highlight unique values in a filtered Excel table

_____Lookup value based on two critera – second criteria is the adjacent value and its position in a given list

1486. Find last matching value in an unsorted list

1487. Multi-level To-Do list template

1488. Insert and configure a drop-down list

1489. Extract values using formulas

_____Compare two columns and extract differences

_____Compare two columns and extract differences - Excel 365

_____Compare two columns and extract differences - earlier versions

_____Wildcard lookups and include or exclude criteria - autofilter

_____Count cells based on conditionally formatted background color using Filter tool and SUBTOTAL function [Excel 365]

1490. Random list

_____List non consecutive dates - Excel 365

_____List non consecutive dates - earlier Excel versions

1491. List consecutive numbers

1492. List non consecutive numbers

_____Get Excel *.xlsx file

_____Highlight duplicates in a filtered Excel Table

_____Get Excel *.xlsx file

1493. How to get a value in a given cell range based on a row number

_____Get a value in a given cell range based on a row and column number

1494. Sort data set using Excel's "Sort & Filter"

1495. How to change cell formatting using a Drop Down list

_____VLOOKUP - Select column using a drop-down list

1496. Extract unique distinct values from a relational table

_____How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas

_____Get Excel *.xlsx file

_____Filter values that exists in all three columns

_____Use a calendar to filter an Excel defined Table

1497. Populate drop down list with filtered Excel Table values

_____Count unique distinct values in a filtered Excel defined Table

_____Extract table headers based on a condition

_____Get Excel *.xlsx file

_____Use a drop down list to filter and concatenate unique distinct values

_____Apply drop-down lists dynamically

1498. Dependent drop-down lists in multiple rows

_____Extract week ranges based on a given date range

1499. Use a drop down list to search and return multiple values

1500. Change PivotTable data source using a drop-down list

1501. Extract unique distinct values in a filtered list

_____List unique distinct values in a filtered Excel defined Table - Excel 365

_____List unique distinct values - Autofilter

1502. List unique distinct values in a filtered Excel defined Table - earlier Excel versions

_____Get Excel *.xlsx file

_____Filter unique distinct records using criteria

1503. Extract unique distinct values based on a filtered Excel defined Table

1504. VLOOKUP in a filtered Excel Table and return multiple values

_____Filter unique distinct values, sorted and blanks removed from a range

_____Filter unique distinct records with a condition

_____Filter unique distinct records case sensitive

_____Filter unique rows case sensitive - Excel 365 LAMBDA function

_____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

1505. List all named ranges and their cell references

1506. Dependent drop down lists – Enable/Disable selection filter

_____Get *.xlsx file

_____How to filter an Excel Table

1507. How to clear an Excel Table filter

_____How to highlight differences in price lists

_____Filter records based on a date range and a text string

_____Split words in a cell - FILTERXML function - any a delimiting character

1508. Filter words containing a given string in a cell range

_____Filter words containing a given string in a cell range - Excel 365 LAMBDA function

1509. Cash drawer bill extractor

1510. Filter duplicate records

_____Filter overlapping date ranges

_____Filter overlapping date ranges - Excel 365

1511. Compare tables: Filter records occurring only in one table

_____Compare two lists of data: Highlight common records

1512. Filter shared records from two tables

1513. Extract duplicate records

1514. Get *.xls file

_____Automate Excel: Update list with new values

1515. Invoice template with dependent drop down lists

1516. Create dependent drop down lists containing unique distinct values in multiple rows

_____Extract unique distinct values based on the 4 last characters

1517. Apply dependent combo box selections to a filter

1518. Array Formula on Filter sheet

1519. Create a drop down list containing alphabetically sorted values

1520. Sort a list in random order in excel

1521. Create a random playlist

1522. Filter unique strings from a cell range

_____Filter unique strings in a range - Excel 365

_____Extract a unique distinct list based on a condition [Pivot Table]

_____Extract a unique distinct list and sum amounts based on a condition

_____Extract dates from a cell block schedule

1523. Create dependent drop down lists containing unique distinct values

_____Extract a unique distinct list sorted from A to Z ignore blanks

_____Extract a unique distinct list sorted from A to Z and ignore blanks

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition

_____List unique distinct sorted values removing blanks based on a condition - Excel 365

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

_____Extract dates from overlapping date ranges

_____Extract dates from overlapping date ranges - Excel 365

_____List dates outside specified date ranges

_____List dates outside specified date ranges - Excel 365

_____List empty gaps as date ranges - Excel 365

1524. List all unique distinct rows in a given month

1525. List all unique distinct rows in a given month and year

_____List all unique distinct rows in a given month and year (Excel 365)

1526. List all rows in a given month and year

_____List all rows in a given month and year (Excel 365)

_____Get Excel *.xlsx file

_____Filter duplicates within same date, week or month

_____Get the smallest number larger than a given number and a condition

_____Get the smallest number larger than a given number and criteria

_____Get Excel *.xlsx file

_____Extract unique distinct year and months from dates

_____Extract unique distinct year and months from dates - Excel 365

_____Extract sorted unique distinct years and months based on a list of dates - Excel 365

_____Extract unique distinct year and months from dates - older Excel versions

1527. Extract records containing negative numbers

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a numbered list ignoring blank cells

1528. Extract unique distinct values if the value contains the given string

_____Extract unique distinct values if the value contains the given string - Excel 365

1529. Extract unique distinct values if the value contains the given string - earlier Excel versions

_____FILTER records based on three conditions

_____Filter duplicate values in a range using “contain” condition

1530. Extract unique distinct text values containing string in a range

1531. Filter duplicate values from a range that begins with string

1532. Extract unique distinct values from cell range that begins with string

1533. Filter unique distinct values where adjacent cells contain search string

_____Filter values distributed horizontally - Excel 365

_____Most frequent value between two dates - Autofilter

_____How to enable the Autofilter

_____How to apply a condition to the Autofilter

_____How to know if the data is filtered - Autofilter

_____How to clear a filter - Autofilter?

_____VLOOKUP - Extract multiple records based on a condition

_____Lookup and return multiple values [AutoFilter]

1534. Extract unique distinct values sorted based on sum of adjacent values

_____Extract unique distinct values sorted based on sum of adjacent values - Excel 365

1535. Extract unique distinct values sorted based on sum of adjacent values - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

_____Get Excel *.xlsx file

1536. Filter unique values from a cell range

1537. Filter unique values sorted from A to Z

1538. Create a list with most recent data available

_____Extract records where all criteria match if not empty

_____Extract all rows from a range that meet criteria in one column

_____Extract all rows from a range based on range criteria (Array formula)

_____Extract all rows from a range based on range criteria - Excel 365

_____Extract all rows from a range based on multiple conditions (Array formula)

_____Extract all rows from a range based on multiple conditions - Excel 365

1539. Extract all rows from a range based on range critera [Excel defined Table]

_____Extract all rows from a range based on range critera [AutoFilter]

1540. Create unique distinct list sorted based on text length

_____Unique distinct list from a column sorted A to Z

_____Extract numbers from a column

_____Extract numbers from a column - Excel 365

_____Extract numbers from a column - earlier Excel versions

_____Extract unique distinct values A to Z from a range and ignore blanks

_____Extract unique distinct values A to Z from a range and ignore blanks - Excel 365

_____Extract unique distinct values A to Z from a range and ignore blanks

_____Create a list of dates with blanks between quarters

_____Get Excel *.xlsx file

_____Reverse a list ignoring blanks

_____Reverse a list ignoring blanks - Excel 365

_____Reverse a list ignoring blanks - manual steps

_____List values with past date

1541. Filter common values between two ranges

_____Filter common values between two nonadjacent cell ranges - Excel 365

1542. Filter common values between two nonadjacent cell ranges - Excel 2019

1543. Filter common values between two nonadjacent cell ranges

1544. Filter values occurring in range 1 but not in range 2

_____Filter common values from three separate columns

_____Filter duplicate values and sort by corresponding date

_____Filter unique values and sort based on adjacent date

_____Advanced custom date filter

1545. Extract a unique distinct list sorted from A-Z from range

_____Extract a list of alphabetically sorted duplicates from a column

_____Extract duplicates from a multi-column cell range

_____Extract duplicates from a range - Excel 365

1546. Extract duplicates from a range

1547. Filter Excel defined Table

1548. Apply filter

1549. How do I extract rows that contain a string in a data set or table?

1550. How do I filter rows that contain a string using an Excel Table?

1551. How to create a list of random unique numbers

_____Merge three columns into one list

_____Merge three columns into one list - Excel 365

_____Merge three columns into one list - earlier Excel versions

_____Merge three columns into one list - Excel 2003 and earlier versions

_____How to create a unique distinct list based on two conditions

_____Extract a list of duplicates from three columns combined

_____Extract a list of duplicates from three columns combined - Excel 365

_____Extract a list of duplicates from three columns combined - earlier Excel versions

_____Extract a list of duplicates from a column

1552. Extract duplicates

_____Extract duplicates - Excel 365

_____Extract a list of duplicates from two columns combined

_____Extract a unique distinct list from three columns

_____Extract a unique distinct list from three columns - Excel 365

_____Extract a unique distinct list from three columns with possible blanks

_____Extract a unique distinct list from three columns with possible blanks - Excel 365

_____Extract a unique distinct list from two columns

_____List unique distinct values in two columns - Excel 365

_____List unique distinct list values in two columns - earlier version 1

_____List unique distinct list in two columns - earlier version 2

_____List unique distinct values in two columns, no blanks

1553. Populate drop down list with unique distinct values sorted from A to Z

_____Filter unique distinct values based on a date range

_____Filter unique distinct values based on a date range (Excel 365)

_____Get Excel *.xlsx file

1554. Extract unique distinct values if adjacent cell is text

_____Create a list of duplicates where adjacent cell value meets a condition

_____Get Excel *.xlsx file

_____Create a unique distinct list based on criteria

1555. Extract a unique distinct list sorted from A to Z

1556. Get the largest/smallest number

_____Get the column header name that contains the largest/smallest value

_____Get the cell address of the largest/smallest number

_____Get Excel *.xlsx file

_____Extract unique values from two columns

1557. 5 easy ways to extract Unique Distinct Values

_____How to extract unique distinct values from a column [Formula]

_____Extract unique distinct values (case sensitive) [Formula]

1558. Filter unique distinct values, in place

_____Put unique distinct values at the top of the list [Conditional Formatting]

_____How to extract unique distinct values from a column [Old array Formula]

1559. How to filter unique values from a list [Formula]

1560. What is the easiest way to filter unique distinct values?

1561. Extract all rows that contain a value between this and that

_____Delete blanks and errors in a list

_____Extract unique distinct values from a multi-column cell range

_____Extract unique distinct values from a multi-column cell range - Excel 365

_____Extract unique distinct values from a multi-column cell range - earlier Excel versions

_____Extract a unique distinct list and ignore blanks

_____Extract a unique distinct list and ignore blanks (Excel 365)

_____Extract records between two dates

_____Filter rows using array formulas based on a date range - Excel 365

_____Filter rows using array formulas based on a date range - earlier Excel versions

_____Filter rows using an Excel table based on a date range

_____Filter rows based on a date range - Autofilter

_____How to extract not shared values in two columns

_____How to identify two consecutive dates in a list

_____Extract shared values between two columns

_____Extract shared values between two columns - Excel 365

_____Extract shared values between two columns (case sensitive)

_____Filter common values from three separate columns

_____Extract unique distinct records based on a criterion

_____How to extract email addresses from an Excel sheet

1562. Filter unique distinct records

1563. Filter unique distinct row records

_____Filter unique distinct row records but not blanks

1564. Filter unique distinct row records that does not begin with *string*

1565. Filter unique distinct row records that begins with *string*

1566. Filter unique distinct records [Pivot table]

1567. What values are missing in List 1 that exists i List 2?

_____Extract values that exist only in one of the two columns

_____Extract values that exist only in one of the two columns - Excel 365

_____Get Excel *.xlsx file

_____Find the most recent date in a list

1568. Find the smallest number in a list that is larger than a given number

_____Create a numbered list ignoring blank cells

_____List all named ranges and their cell references

Finance, stock, expense

1569. How to track sector performance in the stock market – Excel template

_____Get historical stock prices based on ticker/symbol and date range

1570. How to use the STOCKHISTORY function

_____How to get daily historical stock prices in Excel

_____How to get weekly historical stock prices

_____How to get historical monthly stock prices

_____How to get historical closing stock prices

_____Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

1571. Follow stock market trends – trailing stop

_____Follow stock market trends – Moving Average

1572. Split expenses calculator

_____How to split expenses evenly (Excel 365)

1573. All you need to know about calculating NAV units for your stock portfolio

_____How to calculate totals of stock transactions based on dates

1574. Compare the performance of your stock portfolio to S&P 500 using Excel

_____Tracking a stock portfolio #2

_____Tracking a stock portfolio in excel (auto update)

_____Schedule recurring expenses in a calendar in excel (Personal Finance)

1575. Calculate your stock portfolio performance with Net Asset Value based on units in excel

1576. Automate net asset value (NAV) calculation on your stock portfolio

First, last

1577. Search last to first

1578. How to perform a reverse search - starting with the last item

_____How to sort by the first letter/digit?

1579. How to sort by the first letter - Example 2

_____How to sort by the first digit - Example 3

1580. How to sort by the last word in a cell?

1581. How to sort by the first name?

1582. How to sort by the last name?

1583. INDEX MATCH – Last value

_____Highlight a date occurring in the last 7 days

_____Highlight a date occurring last week

_____Highlight a date occurring last month

_____Highlight a row if the date is in the last 7 days

_____Highlight a row if the date is last week

_____Highlight a row if the date is in the last month

_____Extract last word in cell

_____Extract the last word

_____Extract the last letter

_____Extract the last number

_____Extract first word in cell

_____Last day of a given month

_____Find last value in a column

_____Extract the last value in a given cell range

_____Return a hyperlink to the last value in a column

_____Return the row number of the last value in a column

_____Extract a corresponding value next to the last value in a column

_____Find the last non-empty cell with short cut keys

1584. Lookup and match last value – reverse lookup

1585. Lookup and match the last value

_____Lookup and match last value - two conditions AND - logic

_____Find the last matching value - two conditions OR - logic

_____Find the last matching value based on a list of values

_____Find the last matching date based on a date range

1586. Lookup week and match last value

1587. Lookup month and match last value

1588. Lookup year and match the last value

1589. How to calculate the first row number of two cells containing search values next to each other vertically?

_____Find last matching value in an unsorted list

_____Navigate to first empty cell using a hyperlink formula

_____Calculate running average of last 10 data with random blank cells

_____Highlight duplicates except for the first one

_____Searching for the first characters in a text string [Array Formula]

_____Extract unique distinct values based on the 4 last characters

_____Partial match for multiple strings - AND logic - returns the first match

_____Calculate last date of a given month

Group, category

_____Convert multiple binary digit groups

_____How to average by group

1590. Sum by group

1591. Sum by category

_____Sum by group

1592. Custom groups

_____How to sum numbers based on a condition/label/item/category?

1593. Rotating unique groups with no repeat

1594. How to group items by quarter using formulas

_____Highlight every other group? Example 1

_____Highlight every other group? Example 2

_____Group rows based on a condition

_____Count groups of repeated values per row

1595. Label groups of duplicate records

_____Count groups in calendar

_____Split values equally into groups

Hour

_____Count complete hours between two times

1596. How to round time to the nearest hour?

1597. How to round time to the nearest quarter of an hour?

1598. How to use the HOUR function

_____Extract the hour from a time value

1599. Hour value larger than 24

1600. TIME function - how to add hours

1601. How to calculate more than 24 hours?

1602. Convert time to 24 hour clock

1603. Calculate overlapping hours

1604. Calculate total cost based on different rates per hour

1605. Calculate total cost based on different rates per hour (smaller formula)

_____Calculate total cost based on different rates per hour across days

1606. Setting up your work hours in a weekly schedule

_____Find empty hours in a weekly schedule

Hyperlink, link

1607. How to use the HYPERLINK function

1608. How to select a cell containing a hyperlink?

1609. HYPERLINK function not working

1610. How to create a link to a cell

1611. How to create a link to a cell range

1612. How to create a link to another worksheet

1613. How to create a link to a workbook

1614. How to create a link to a named range

1615. How to create a link to an Excel Table

1616. How to create a link to a file

1617. How to create a link to a webpage

1618. How to create a link based on cell value

_____Return a hyperlink to the last value in a column

_____How to link a drop-down list to an Excel Table (Data validation)

1619. How to link a spin button to a cell value?

1620. How to link radio buttons to a cell

1621. Easily select data using hyperlinks

_____Navigate to first empty cell using a hyperlink formula

_____Create a hyperlink linked to the result of a two-dimensional lookup

1622. Locate lookup values in an Excel table [HYPERLINK]

1623. Use hyperlinks in a pivot table

1624. Create a link to the largest/smallest number

_____How to navigate quickly in a complex workbook using hyperlinks

If

_____Rearrange values to the left if the cell is empty as far as possible

1625. What amount is needed if I want x in future value, the interest rate is constant, and the number of periods is given?

1626. What amount is needed if I want x in future value, the interest rate is constant, the payment amount, and the number of periods are given?

_____Filter values if not equal to

_____Filter values if smaller than

_____Filter values if larger than

_____Filter values if contains

_____Filter values if not contain

_____Filter function - #CALC! error returns [if_empty] argument

1627. If cell has value

1628. If cell contains any text

_____Verify your date and time settings

1629. Test if a data set has a unique mode or multiple modes?

_____How the average and the median can differ

1630. INT function and IF function

_____Check if a cell contains nonprintable characters

_____Check if a cell range contains nonprintable characters

1631. If cell contains multiple values

_____If cell equals value from list

_____If cell equals value from list - regular formula

_____If cell equals value from list - array formula

_____If cell equals value from list - case sensitive

_____If cell contains text from list

_____Check if the cell contains any value in the list

_____Display matches if cell contains text from list (Excel 2019)

_____Display matches if cell contains text from list (Earlier Excel versions)

_____Check if cell contains value in the list and return the corresponding value

1632. IF with OR function

1633. Check if there is at least one number above a given value

_____How to check if there is a blank value in a cell range

1634. If cell contains text

1635. If cell contains partial text

1636. If cell contains partial text - hardcoded asterisks

1637. If cell contains text then return value

1638. If cell contains text then add text in another cell

1639. If cell contains text then sum

1640. If cell contains text add 1

1641. OR function with IF

1642. AND function in IF function example

_____IF function with AND function – multiple conditions

1643. IF with AND function - two logical expressions

1644. IF with AND function - multiple pairs of logical expressions

1645. How to simplify nested IF functions

1646. How to simplify nested IF functions based on a single numerical range

1647. How to simplify nested IF statements based on multiple numerical ranges

_____How to simplify nested IF functions based on conditions

_____How to simplify nested IF functions based on date ranges

_____How to sum if a number is smaller than a given condition

_____How to sum if a number is larger than a given condition

_____How to sum if a date is later than a given condition

_____How to sum if a date is earlier than a given condition

_____VLOOKUP - What if the lookup value is not in the leftmost column?

1648. VLOOKUP yes if true

1649. VLOOKUP zero if not found

_____Count identical values if they are on the same row

_____Count identical values if they are on the same row (Array formula)

_____Count identical values if they are on the same row (Regular formula)

_____What happens if you transpose a range with the same number of columns and rows?

1650. Bifid

1651. Trifid

1652. Modify Scroll Bar settings

_____Macro deletes entire row if the formula returns blanks

1653. How to use the IF function

1654. IF function example

1655. What happens if a text string is used in the logical expression?

_____IF function - How to check if a cell is blank?

_____IF function - How to check if a cell is not blank?

_____IF function - How to check if a cell contains an error?

1656. IF function - How to check if a cell is a text value?

1657. IF function - How to check if a cell is a number?

1658. IF function - if false do nothing?

1659. IF function - greater than

1660. IF function - smaller than

_____IF function - equals

_____IF function - equals multiple values

1661. IF function - does not equal

1662. IF function - begins with

1663. IF function - ends with

1664. IF function - contains

1665. IF function - contains any text

_____IF function - exact match case sensitive

1666. IF function - AND OR

1667. IF function between two sheets?

1668. IF function - copy cell value?

1669. IF function - add value?

1670. IF function - keep value?

_____IF function - keep blank?

1671. If function based on cell color?

1672. How to work with multiple values in the IF function? (arrays)

1673. IF function - between two numbers?

_____What if I don't have the lookup column in the left-most column?

_____Create comment if cell value is larger than column

1674. How many unique distinct products did Jennifer sell in January and in region South?

1675. Match if cell contains string [Array Formula]

_____Extract unique distinct values if the value contains the given string

_____Extract unique distinct values if the value contains the given string - Excel 365

_____Extract unique distinct values if the value contains the given string - earlier Excel versions

1676. Return multiple values if in range

1677. How to return a value if lookup value is in a range

1678. If value in range then return value - LOOKUP function

1679. If value in range then return value - VLOOKUP function

1680. If value in range then return value - INDEX + MATCH

_____How to know if the data is filtered - Autofilter

1681. VLOOKUP and return multiple values - if not equal to

1682. VLOOKUP and return multiple values - if smaller than

1683. VLOOKUP and return multiple values - if larger than

1684. VLOOKUP and return multiple values - if contains

1685. VLOOKUP and return multiple values - if not contain

_____Extract records where all criteria match if not empty

_____Extract unique distinct values if adjacent cell is text

Ifs

1686. How to use the MINIFS function

1687. MINIFS function example

1688. MINIFS Function not working

_____MINIFS function multiple criteria ex 1

_____MINIFS function multiple criteria ex 2

1689. MINIFS function greater than 0 (zero)

_____MINIFS function date

_____MINIFS function not blank

1690. How to use the IFS function

1691. IFS function example

_____IFS function alternative

1692. IFS function - convert month number to month name

1693. How to use the MAXIFS function

1694. MAXIFS function example

_____MAXIFS function - criteria

1695. MAXIFS function - smaller than

1696. Can you use other functions in the MAXIFS function?

1697. Can you perform calculations in the MAXIFS function?

_____How to use the AVERAGEIFS function

_____AVERAGEIFS function not working

_____AVERAGEIFS Function example

_____AVERAGEIFS function - wildcard characters

_____AVERAGEIFS Function - begins with

_____AVERAGEIFS Function - ends with

_____AVERAGEIFS Function - contains

_____AVERAGEIFS function - nested functions and arrays

1698. How to use the SUMIFS function

1699. SUMIFS function greater than

1700. SUMIFS function not equal

_____SUMIFS function multiple criteria

1701. SUMIFS function or

1702. SUMIFS Function example using partial match

1703. How to use logical operators in the SUMIFS function

_____How to merge data using two or more criteria with the COUNTIFS function

_____How to use the COUNTIFS function

_____COUNTIFS function example

_____COUNTIFS function - Partial match using wildcard characters

_____COUNTIFS function - using two conditions

_____COUNTIFS function - Logical operators

_____COUNTIFS function - Count duplicate records

_____COUNTIFS function - return an array identifying records based on multiple conditions

_____COUNTIFS function - OR logic

_____COUNTIFS function - how to use dates

_____COUNTIFS function - after a date

_____COUNTIFS function - before a date

_____How to make the COUNTIFS function work with a dynamic range

Ignore, avoid, prevent, exclude, hide

_____DROP Function example - exclude columns

_____DROP Function example - exclude columns and rows

_____How to ignore error values using the SMALL function

_____MAX function ignore #N/A error

1704. What values are excluded from the calculation?

1705. Which values are excluded in the calculation?

1706. What will the AGGREGATE function not exclude?

1707. Does the EXACT function ignore cell formatting?

1708. MIN function ignore 0 (zero)

_____MIN function ignore errors

1709. MIN function ignore negative numbers

1710. MIN function ignore text

_____MIN function ignore #NA error

1711. How to ignore zeros using the SMALL function

1712. SMALL function - ignore zeros (array formula)

1713. SMALL function - ignore zeros (regular formula)

_____SMALL function - ignore zeros (Excel 365)

1714. SMALL function - ignore negative numbers

_____AVERAGE ignore NA()

_____AVERAGE ignore NA() - Excel 2007 and later versions

_____AVERAGE ignore NA() - earlier versions

_____AVERAGE ignore #N/A for non-contiguous cell ranges

_____AVERAGE ignore blanks

_____Average - ignore blanks and errors

_____Average - ignore blanks in non-contiguous cells

_____Weighted average ignore blanks

_____Average ignore 0 (zeros) and blanks

_____Are boolean values ignored in the AVERAGE function?

_____How to exclude some cells from average

1715. SMALL function ignore duplicates

_____Does the SUBTOTAL function avoid double counting?

1716. How to exclude manually hidden values from the SUBTOTAL function?

_____Hashtag character lets you hide extra zeros

1717. How to hide specific values - TEXT function

1718. How to hide positive numbers

1719. How to hide negative numbers

1720. How to hide zeros

1721. How to hide text values

_____How to sum a column and ignore errors?

1722. How to hide cell values using cell formatting?

1723. Show / hide a picture using a button

_____Wildcard lookups and include or exclude criteria

_____Wildcard lookups and include or exclude criteria - Excel 365

_____Wildcard lookups and include or exclude criteria - array formula

_____Wildcard lookups and include or exclude criteria - autofilter

1724. Prevent duplicate records in a worksheet

1725. Hide values in cell F2:G2

_____Prevent overlapping date and time ranges using data validation

_____Combine cell ranges ignore blank cells

_____Count digits and ignore duplicates

1726. Ignore duplicates [Excel 2019]

_____Ignore duplicates [Excel 365]

_____Extract a unique distinct list sorted from A to Z ignore blanks

_____Extract a unique distinct list sorted from A to Z and ignore blanks

_____Extract unique distinct values A to Z from a range and ignore blanks

_____Extract unique distinct values A to Z from a range and ignore blanks - Excel 365

_____Extract unique distinct values A to Z from a range and ignore blanks

_____How to hide duplicate values [Conditional Formatting]

_____How to ignore blank cells

_____Extract a unique distinct list and ignore blanks

_____Extract a unique distinct list and ignore blanks (Excel 365)

_____AVERAGE ignore 0 (zero)

Image, picture

1727. How to use the IMAGE function

1728. IMAGE Function example

_____Show an image based on a drop-down list

1729. IMAGE function not working

_____IMAGE function - #CONNECT error

_____IMAGE function - #BUSY error

_____Show / hide a picture using a button

1730. Heat map using pictures

Index

1731. Example 1 - INDEX function

1732. Horizontal and vertical lookup - INDEX + MATCH

1733. How to use the INDEX function

1734. INDEX Function Example

1735. How to create array constants in the INDEX function

_____How to return all values in a row or column in a given cell range with the INDEX function

1736. How to use the [area_num] argument - INDEX function

1737. How to return the entire row in a given cell range using the INDEX function

_____How to return an column of values in a given cell range using the INDEX function

1738. How to return the entire specified cell range - INDEX function

_____How to build a dynamic cell reference using the INDEX function

_____INDEX function error

1739. Can you replace the VLOOKUP function with the INDEX function?

1740. Where do I use the INDEX - MATCH functions instead of VLOOKUP?

1741. Two index table

1742. If value in range then return value - INDEX + SUMPRODUCT + ROW

_____If value in range then return value - INDEX + MATCH

_____Lookup two index columns

Index match, index and match

_____INDEX MATCH – Last value

_____INDEX and MATCH – multiple criteria and multiple results

_____INDEX and MATCH - multiple criteria and multiple results

_____INDEX and MATCH - multiple criteria and multiple results (Excel 365)

1743. SMALL function – INDEX MATCH

1744. SMALL function - INDEX MATCH

_____SMALL function - INDEX MATCH (Excel 365)

_____INDEX MATCH – Case sensitive

_____How to do a case sensitive INDEX MATCH - array formula

_____How to do a case sensitive INDEX MATCH - regular formula

_____How to do a case sensitive partial match using INDEX and MATCH functions

1745. INDEX MATCH – multiple results

_____INDEX MATCH with multiple criteria

_____INDEX MATCH - multiple criteria

_____INDEX MATCH - partial text multiple conditions Excel 365

_____INDEX MATCH - partial match multiple columns

1746. VLOOKUP vs INDEX MATCH

_____Merge data using the INDEX and MATCH functions

Intersection

1747. Calculate the intersection of two cell ranges

Lambda

1748. Workaround for the TEXTSPLIT function – LAMBDA function

1749. How to use the LAMBDA function

1750. LAMBDA function example

1751. Build LAMBDA function

1752. Name the LAMBDA function

1753. Multiply cells - recursive LAMBDA function

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Rearrange data - Excel 365 LAMBDA function

_____Two-way lookup using multiple tables - Excel 365 LAMBDA function

_____Filter unique rows case sensitive - Excel 365 LAMBDA function

_____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

_____How to calculate word frequency in a given cell range - Excel 365 LAMBDA function

_____Fuzzy lookups - Excel 365 recursive LAMBDA function

_____Fuzzy VLOOKUP - Excel 365 LAMBDA function

_____Filter words containing a given string in a cell range - Excel 365 LAMBDA function

Large, larger, highest, greater

1754. How to sort from smallest to largest?

1755. How to sort from largest to smallest?

1756. Sum numbers based on items and return totals sorted from large to small

_____Filter values if larger than

_____MINIFS function greater than 0 (zero)

_____How to convert large decimal numbers to binary?

1757. SWITCH Function - how to use logical operators like larger than and smaller than

_____Get largest number based on a condition

_____Get largest number based on multiple conditions

1758. MAX function second highest

1759. MAX function second-highest number no duplicates

_____MAX function second-highest number based on a condition

_____Get the highest number within each row

1760. Sort rows by their highest number within each row

_____Get the highest number within each column

_____Sort columns by their highest number within each row

_____How to extract the largest number ignoring error values

_____How to extract the largest number ignoring error values using arrays

1761. How to use the LARGE function

1762. LARGE function - example

_____LARGE function - based on a condition

_____LARGE function - based on criteria

_____LARGE function - based on a list

1763. LARGE function - multiple source ranges

1764. LARGE function - based on a textstring

_____LARGE function - calculate an average based on the three largest numbers

_____How to extract the k-th largest number in a 3D range

_____AVERAGEIF function - larger than

_____How to extract the largest number ignoring error values

_____Hour value larger than 24

1765. Minutes value larger than 59

1766. Seconds value larger than 59

_____SUMIFS function greater than

1767. SUMPRODUCT if greater than 0 (zero)

_____How to extract the largest number from filtered data?

_____How to sum if a number is larger than a given condition

1768. How to sum values greater than smaller than?

1769. Partial match and return value with highest level

_____Find and return the highest number and corresponding date based on a condition

_____Dynamic counting per row sorted from large to small

_____Find the largest value in lookup_vector that is less than or equal to lookup_value

1770. MOD function won't work with really large numbers?

_____IF function - greater than

_____COUNTIF Function - Count cells larger/less than a criterion

1771. Find smallest and largest unique number

_____Create comment if cell value is larger than column

_____Get the smallest number larger than a given number and a condition

_____Get the smallest number larger than a given number and criteria

_____VLOOKUP and return multiple values - if larger than

1772. How to find the largest duplicate number

_____How to find the largest duplicate number - Excel 365

1773. How to find the largest unique number

_____How to find the largest unique number - Excel 365

_____Get the largest/smallest number

_____Get the column header name that contains the largest/smallest value

_____Get the cell address of the largest/smallest number

_____Create a link to the largest/smallest number

_____How to highlight the largest and smallest value

_____Find the smallest number in a list that is larger than a given number

1774. Find the smallest number that is larger than a given number - [Excel 2016]

1775. Find the smallest number that is larger than a given number - earlier Excel versions

1776. Find the largest number that is smaller than a given number - [Excel 2016]

1777. Find the largest number that is smaller than a given number - earlier Excel versions

1778. How to find the k-th smallest number that is larger than a given number?

1779. How to find the k-th largest number that is smaller than a given number?

Letter

1780. How to create a sequence of letters?

1781. Does the SORTBY function differentiate between upper and lower letters?

_____How to sort by the first letter/digit?

_____How to sort by the first letter - Example 2

1782. How can I sort letters and numbers?

_____Convert column number to column letter

_____How to convert a column number to a column letter?

_____How to convert a column letter to a column number?

_____Extract column letter - Excel 365

_____Change upper letter to lower letter for the position of a given character

1783. Change a given upper letter to a letter

_____Change all upper letters to lower letters for a given character

_____Convert every other letter to upper or lower case

1784. Substitute all letters with a given string

_____How to change lower letter to upper letter for the position of a given character

_____How to change lower letter to upper letter for a given character

_____How to change all lower letters to upper letters for a given character

_____Extract the last letter

1785. Convert letters to numbers

Lookup, find, identify

_____Partial match VLOOKUP - asterisk character (wildcard)

1786. How to use the XLOOKUP function

1787. XLOOKUP function - example

1788. How to perform a binary xlookup

1789. How to perform a wildcard xlookup

1790. How to find the smallest number excluding zeros

_____How to find blank cells

1791. How to use the FIND function

1792. FIND Function example

1793. FIND Function not working

1794. FIND function returns all positions of a given substring

1795. Find the element name based on an atomic number

1796. Find the optimal permutation - Excel Solver

_____Identify all characters in a cell value

_____Identify all characters in a cell value - Excel 365

1797. CELL function - How to find out which formatting a specific cell has

_____How to identify a new line character in an Excel formula

_____Column function and VLOOKUP

1798. Identify numbers stored as text

_____Identify digits in a string

1799. MID function with FIND function

1800. CHOOSE function with VLOOKUP

_____Find cells containing all conditions

_____Find cells containing all conditions (Excel 365)

_____Find cells containing at least one condition

_____Two-dimensional lookup using two tables

_____Find empty cells and sum cells above

_____Lookup based on a date range and a condition return multiple values

_____Lookup a date range and a condition - return multiple values

_____Lookup a date range and a condition - return multiple values - Excel 365

_____Find last value in a column

_____Find the last non-empty cell with short cut keys

_____Lookup and match last value – reverse lookup

_____Lookup and match the last value

_____Lookup and match last value - two conditions AND - logic

_____Find the last matching value - two conditions OR - logic

_____Find the last matching value based on a list of values

_____Find the last matching date based on a date range

_____Lookup week and match last value

_____Lookup month and match last value

_____Lookup year and match the last value

1801. Use VLOOKUP and return multiple values sorted from A to Z

1802. How to use the HLOOKUP function

1803. HLOOKUP function - Overview

1804. Video - HLOOKUP function

1805. Horizontal and vertical lookup

_____Horizontal and vertical lookup - INDEX + MATCH

1806. HLOOKUP - multiple tables

1807. How to use the VLOOKUP function

1808. VLOOKUP function formula

1809. VLOOKUP - approximate match

_____Merge two data sets using the VLOOKUP function

1810. VLOOKUP - how to use multiple tables

_____VLOOKUP - What if the lookup value is not in the leftmost column?

_____How to handle VLOOKUP errors

_____Using multiple criteria in VLOOKUP

1811. VLOOKUP function - Partial match using wildcards

1812. VLOOKUP function - Partial match - begins with

1813. VLOOKUP function - Partial match - ends with

1814. VLOOKUP function - Partial match - contains

1815. VLOOKUP function - Partial match - question mark

_____VLOOKUP function - tilde character escapes wildcard characters

1816. VLOOKUP - Duplicate repeated values

_____VLOOKUP and HLOOKUP together

1817. VLOOKUP - can't find a value that is there

_____VLOOKUP alternatives

1818. VLOOKUP just shows the formula

1819. VLOOKUP another sheet

1820. VLOOKUP keep formatting

1821. VLOOKUP backward - lookup from bottom to top

_____VLOOKUP on two columns

_____VLOOKUP between dates

_____VLOOKUP returns #N/A

_____VLOOKUP yes if true

1822. VLOOKUP part of text

_____VLOOKUP vs INDEX MATCH

_____VLOOKUP returns multiple columns

_____VLOOKUP zero if not found

1823. VLOOKUP sum

1824. VLOOKUP true false

1825. VLOOKUP unique

_____Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

_____How to perform two-way lookup in multiple tables - 2D

_____Reverse two-way lookups

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

1826. How to quickly find an Excel Table in a workbook

_____Find and return the highest number and corresponding date based on a condition

1827. How to identify array formulas?

1828. Find the time difference

1829. Find and replace strings in file names, folder name and subfolders

_____Find empty dates in a set of date ranges

_____Find empty dates in a set of date ranges - Excel 365

_____Find empty dates in a set of date ranges - earlier versions

_____Find most overlapped date range

1830. How to find divisors of a number without remainders?

1831. Find numbers closest to sum

_____Find numbers closest to sum - Excel 365

_____Find numbers in total with a condition

_____Find numbers in total with a condition - Excel 365

1832. Find cells containing formulas with literal (hardcoded) values

1833. How to use the LOOKUP function

1834. Be careful with the LOOKUP function

_____Find the largest value in lookup_vector that is less than or equal to lookup_value

1835. How to use multiple values in the LOOKUP function

_____How to make the LOOKUP function work with multiple worksheets

1836. Nested LOOKUP functions

1837. How to lookup multiple values simultaneously (array formula)

1838. How to VLOOKUP using the INDIRECT function?

1839. Find the most/least consecutive repeated value

1840. Lookup for a multi-level sequence

1841. Lookup for multiple multi-level sequences

1842. How to find two search values next to each other vertically?

1843. How to find all instances of two search values next to each other vertically?

1844. How to find a sequence with any value between?

1845. Find multiple sequences with any value between?

1846. A quicker A * pathfinding algorithm

1847. Finding the shortest path – A * pathfinding

_____How to join data sets using the VLOOKUP function

_____Lookup value based on two critera – second criteria is the adjacent value and its position in a given list

_____Find last matching value in an unsorted list

_____Lookup and return multiple sorted values based on corresponding values in another column

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel 365

_____Lookup and return multiple sorted values based on corresponding values in another column - previous Excel versions

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel Table

1848. Identify rows of overlapping records

_____Identify rows of overlapping records - Excel 365

1849. Identify rows of overlapping records - earlier versions

_____Wildcard lookups and include or exclude criteria

_____Wildcard lookups and include or exclude criteria - Excel 365

_____Wildcard lookups and include or exclude criteria - array formula

_____Wildcard lookups and include or exclude criteria - autofilter

_____Lookup with any number of criteria

_____Lookup with an unknown number of criteria [Array Formula]

_____Find earliest and latest overlapping dates in a set of date ranges based on a condition

_____How can I find all errors in a worksheet?

_____IFERROR function simplifies finding errors in formulas

_____Create a hyperlink linked to the result of a two-dimensional lookup

_____Find all sequences of consecutive dates

_____Find all sequences of consecutive dates - Excel 365

_____Find all sequences of consecutive dates - earlier Excel versions

_____COUNTIFS function - return an array identifying records based on multiple conditions

1850. Lookup_array in ascending order

1851. Lookup_array in any order

1852. Lookup_array in descending order

_____Can you replace the VLOOKUP function with the INDEX function?

_____Where do I use the INDEX - MATCH functions instead of VLOOKUP?

_____Lookup using multiple conditions

1853. Lookup multiple values in one cell

_____Lookup multiple values in one cell - Excel 365

_____VLOOKUP and return multiple values across columns

_____Find date range based on a date

_____Find smallest and largest unique number

_____How to use VLOOKUP/XLOOKUP with multiple conditions

_____VLOOKUP function with two conditions applied to two columns (AND logic)?

_____VLOOKUP function with two conditions applied to two columns (OR logic)?

_____VLOOKUP function with many conditions applied to one column (OR logic)?

1854. Can we use VLOOKUP with multiple lookup values?

_____VLOOKUP across multiple columns?

_____Can you concatenate VLOOKUP results?

_____How to use VLOOKUP with dates?

_____What if I don't have the lookup column in the left-most column?

_____VLOOKUP - Select column using a drop-down list

_____XLOOKUP - two conditions in two columns (AND logic)?

_____XLOOKUP - two conditions in two columns (OR logic)?

_____XLOOKUP - multiple conditions in one column (OR logic)?

1855. Can we use XLOOKUP with multiple lookup values?

_____XLOOKUP across multiple columns?

_____Can you concatenate XLOOKUP results?

_____How to use XLOOKUP with dates?

_____What if I don't have the lookup column in the left-most column?

_____Locate lookup values in an Excel table [HYPERLINK]

_____Highlight lookups in relational tables

1856. Lookups in relational tables

1857. Find numbers in close proximity to a given number

_____Lookup multiple values across columns and return a single value

_____Highlight lookup values

_____Find entry based on conditions

_____Two-way lookup in multiple cross reference tables simultaneously

_____Two-way lookup using multiple tables - Excel 365 LAMBDA function

_____VLOOKUP in a filtered Excel Table and return multiple values

_____Vlookup across multiple sheets

1858. Vlookup a cell range and return multiple values

1859. VLOOKUP – Return multiple unique distinct values

1860. VLOOKUP - Return multiple unique distinct values

_____VLOOKUP - Return multiple unique distinct values (Excel 365)

1861. Find lower prices

1862. Find higher prices

1863. Fuzzy lookups

_____Fuzzy lookups - Excel 365 recursive LAMBDA function

1864. Fuzzy VLOOKUP

_____Fuzzy VLOOKUP - Excel 365 LAMBDA function

1865. Fuzzy VLOOKUP - array formula

_____Lookup and return multiple values concatenated into one cell

_____Lookup and return multiple values concatenated into one cell [Excel 2019]

_____Lookup and return multiple dates concatenated into one cell [Array Formula]

_____Lookup within a date range and return multiple values concatenated into one cell [Array Formula]

1866. Return multiple matches with wildcard vlookup

_____Case sensitive lookup and return multiple values

1867. Vlookup with multiple matches returns a different value

_____Lookup with multiple matches returns different values - Excel 365

_____Find empty hours in a weekly schedule

_____Identify overlapping date ranges

_____Identify overlapping date ranges based on a condition

_____How to return a value if lookup value is in a range

_____If value in range then return value - LOOKUP function

_____If value in range then return value - VLOOKUP function

_____VLOOKUP/XLOOKUP of three columns to pull a single record

_____VLOOKUP of three columns to pull a single record

_____XLOOKUP of three columns to pull a single record

1868. Find positive and negative amounts that net to zero

1869. Identify numbers in sum using Excel solver

_____Vlookup with 2 or more lookup criteria and return multiple matches

_____Use VLOOKUP to search date in date ranges and return value on the same row

_____Find the most recent date that meets a particular condition

_____Lookup a value and find the most recent date

_____Lookup a value and find the most recent date (Pivot Table)

_____Lookup all values and find the most recent dates

_____Lookup and find the most recent date using multiple conditions

_____Lookup and find the most recent date on multiple sheets

_____Lookup and find the most recent date, return another value on the same row

_____Lookup min max values within a date range

_____Lookup two index columns

1870. 5 easy ways to VLOOKUP and return multiple values

1871. VLOOKUP - Return multiple values [vertically]

_____VLOOKUP and return multiple values - case sensitive

_____VLOOKUP and return multiple values - if not equal to

_____VLOOKUP and return multiple values - if smaller than

_____VLOOKUP and return multiple values - if larger than

_____VLOOKUP and return multiple values - if contains

_____VLOOKUP and return multiple values - if not contain

1872. VLOOKUP and return multiple values - that begins with

1873. VLOOKUP and return multiple values - that ends with

_____How to count VLOOKUP results

1874. VLOOKUP - Return multiple values [horizontally]

_____VLOOKUP - Extract multiple records based on a condition

_____Lookup and return multiple values [AutoFilter]

1875. Lookup and return multiple values [Excel Defined Table]

1876. Identify missing numbers in a range

_____Identify missing three character alpha code numbers

1877. Find min and max unique and duplicate numerical values

_____How to find the largest duplicate number

_____How to find the largest duplicate number - Excel 365

1878. How to find the smallest duplicate number

_____How to find the smallest duplicate number - Excel 365

_____How to find the largest unique number

_____How to find the largest unique number - Excel 365

1879. How to find the smallest unique number

_____How to find the smallest unique number - Excel 365

_____How to perform a two-dimensional lookup

_____Identify missing numbers in two columns based on a numerical range

_____Identify missing numbers in a column

_____Lookup the nearest date

1880. How to quickly find the maximum or minimum value [Formula]

_____How to find errors in a worksheet

_____How to identify two consecutive dates in a list

1881. Improve your VLOOKUP formula and return multiple values

1882. Find closest value

1883. Find the closest value

_____Find closest value - Excel 365

1884. Find closest values

_____Find closest values - Excel 365

1885. Find closest values and return adjacent values

_____Find closest value with a criterion

_____How to find errors in a worksheet

_____Find the most recent date in a list

_____Find the smallest number in a list that is larger than a given number

_____Find the smallest number that is larger than a given number - [Excel 2016]

_____Find the smallest number that is larger than a given number - earlier Excel versions

_____Find the largest number that is smaller than a given number - [Excel 2016]

_____Find the largest number that is smaller than a given number - earlier Excel versions

_____How to find the k-th smallest number that is larger than a given number?

_____How to find the k-th largest number that is smaller than a given number?

1886. Choose between two data sets to VLOOKUP

Match

1887. How to use the XMATCH function

1888. XMATCH Function Comments

_____Match a range value containing both text and numerical characters

_____AVERAGEIF function - match a specific number of characters

_____SMALL function - match records AND logic

1889. SMALL function - match records OR logic

1890. SMALL function - match multiple values OR logic

_____How to do a partial case sensitive match using two conditions in two columns

_____Match two columns and return another value on the same row

_____Match two columns and return another value on the same row (array formula)

_____Match two columns and return another value on the same row (regular formula)

_____Match two columns and return another value on the same row - case sensitive

_____Display matches if cell contains text from list (Excel 2019)

_____Display matches if cell contains text from list (Earlier Excel versions)

1891. How to use an asterisk to perform a wildcard match in the SUMIF function

_____Lookup and match last value – reverse lookup

_____Lookup and match the last value

_____Lookup and match last value - two conditions AND - logic

_____Find the last matching value - two conditions OR - logic

_____Find the last matching value based on a list of values

_____Find the last matching date based on a date range

_____Lookup week and match last value

_____Lookup month and match last value

_____Lookup year and match the last value

1892. Approximate match

_____Horizontal and vertical lookup - INDEX + MATCH

_____VLOOKUP - approximate match

_____Count matching strings using regular expressions

_____Match each substring to a table - Excel 365

_____Compare two lists and filter unique values where the sum in one column doesn’t match the other column

_____Find last matching value in an unsorted list

_____IF function - exact match case sensitive

1893. How to use the MATCH function

1894. How to use the MATCH function in an array formula

_____Match cell that ends with the condition

_____Match cell that begins with the condition

1895. Match cell that contains a given string

_____Match cell that begins with a specific string and ends with another string - any number of characters in between

_____Match cell that begins with string and ends with another string - a single character in between

_____How to do a case sensitive match

_____Where do I use the INDEX - MATCH functions instead of VLOOKUP?

_____Merge matching rows

_____Match if cell contains string [Array Formula]

_____Return multiple matches with wildcard vlookup

_____Vlookup with multiple matches returns a different value

_____Lookup with multiple matches returns different values - Excel 365

_____Match two criteria and return multiple records

_____Match two criteria and return multiple records [Array Formula]

_____Match two criteria and return multiple records [Excel 365]

_____Match two criteria and return multiple records [Excel defined Table]

_____If value in range then return value - INDEX + MATCH

_____Vlookup with 2 or more lookup criteria and return multiple matches

_____Formula for matching a date within a date range

_____Match a date when a date range is entered in a single cell

_____Match a date when a date range is entered in two cells sorted in ascending order

_____Match a date when a date range is entered in two cells with gaps not sorted

_____Match a date when date ranges sometimes overlap and return multiple results

_____Extract records where all criteria match if not empty

Max

1896. How to use the DMAX function

1897. How to use the MAX function

1898. MAX function not working

1899. Max function returns 0 (zero)

1900. Max function for text

_____MAX function ignore #N/A error

_____MAX function second highest

_____MAX function second-highest number no duplicates

_____MAX function second-highest number based on a condition

_____How to use the MAXIFS function

_____MAXIFS function example

_____MAXIFS function - criteria

_____MAXIFS function - smaller than

_____Can you use other functions in the MAXIFS function?

_____Can you perform calculations in the MAXIFS function?

1901. AGGREGATE function - MAX

1902. Change minimum and maximum value on the vertical axis

_____Lookup min max values within a date range

_____How to highlight MAX and MIN value based on month

_____Find min and max unique and duplicate numerical values

_____How to quickly find the maximum or minimum value [Formula]

Min

_____Calculate the complex determinant of a 2x2 matrix

1903. How to use the NOMINAL function

_____How to use the MINIFS function

_____MINIFS function example

_____MINIFS Function not working

_____MINIFS function multiple criteria ex 1

_____MINIFS function multiple criteria ex 2

_____MINIFS function greater than 0 (zero)

_____MINIFS function date

_____MINIFS function not blank

1904. How to use the MINA function

1905. How to use the MINVERSE function

1906. How to use the DMIN function

_____How to round a date to the nearest upcoming weekday?

1907. How to use the MINUTE function

_____Extract the minute from a time value

1908. AGGREGATE function - MIN

_____Minutes value larger than 59

1909. TIME function - how to add minutes

1910. How to use the MIN function

1911. MIN function example

_____MIN function ignore 0 (zero)

1912. MIN function returns 0 (zero)

1913. MIN function not working

_____MIN function ignore errors

_____MIN function ignore negative numbers

_____MIN function ignore text

_____MIN function ignore #NA error

_____Use price ranges to determine discount

_____Change minimum and maximum value on the vertical axis

1914. Bill reminder in excel

_____Lookup min max values within a date range

_____How to highlight MAX and MIN value based on month

_____Find min and max unique and duplicate numerical values

_____How to quickly find the maximum or minimum value [Formula]

Minute

_____How to use the MINUTE function

_____Extract the minute from a time value

_____Minutes value larger than 59

_____TIME function - how to add minutes

Month

_____How to get historical monthly stock prices

1915. How to create a sequence of months?

1916. How to sort by month?

_____Highlight a date occurring last month

_____Highlight a date occurring this month

_____Highlight a date occurring next month

_____Highlight a row if the date is in the last month

_____Highlight a row if the date is in this month

_____Highlight a row if the date is in the next month

_____How to calculate the number of months between dates

1917. Calculate the months saved by making extra payments?

1918. How to use the EOMONTH function

_____IFS function - convert month number to month name

_____Count weekdays in a month

1919. How to use the MONTH function

1920. MONTH Function not working

1921. MONTH Function example

_____MONTH function alternative

1922. MONTH function - return month name instead of a number

_____Filter dates based on month

_____How do I sum values between n-th weekday this month and n-th weekday next month?

_____How to average by month

1923. Sum by month and year

1924. Year and month

_____Year and month to date?

_____Add or subtract months and days

_____Date function add months

_____Last day of a given month

1925. Running totals on a monthly basis

1926. Display a running total when the month changes

_____Lookup month and match last value

1927. How to sum values by month?

1928. Building monthly sheets

1929. Create remaining months

_____Calendar – monthly view

_____Calendar, monthly view - Excel 365

_____Add event to the monthly calendar

1930. How to change the month

1931. Worksheet Month

1932. Create monthly time sheet using a Pivot Table

_____Create date ranges that stay within month

_____Monthly calendar template #2

_____Monthly calendar template

_____Count cells based on a condition and month

_____List all unique distinct rows in a given month

_____List all unique distinct rows in a given month and year

_____List all unique distinct rows in a given month and year (Excel 365)

_____List all rows in a given month and year

_____List all rows in a given month and year (Excel 365)

_____Highlight duplicates with same date, week or month

_____Filter duplicates within same date, week or month

_____Count unique distinct values within same week, month or year

_____Remove duplicates within same month or year

_____Extract unique distinct year and months from dates

_____Extract unique distinct year and months from dates - Excel 365

_____Extract sorted unique distinct years and months based on a list of dates - Excel 365

_____Extract unique distinct year and months from dates - older Excel versions

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Highlight odd/even months

_____Create a monthly date range

_____How to highlight MAX and MIN value based on month

_____Count unique distinct months

_____How to calculate a date based on specific weekday in a month

_____Calculate last date of a given month

Multiply, multiplication, product

_____Multiply complex number by i

1933. How to multiply numbers in an Excel formula

1934. How to multiply a number and cell value

1935. How to multiply cell values

1936. How to multiply multiple cell values

1937. How to multiply values using an Excel function

1938. How to multiply functions in an Excel formula

_____How to multiply boolean values - apply AND logic

_____How to calculate the product of a complex number and its complex conjugate

1939. How to use the DPRODUCT function

1940. How to use the PRODUCT function

1941. AGGREGATE function - PRODUCT

1942. SUMPRODUCT and nested IF functions

1943. SUMPRODUCT - nested IF functions

_____SUMPRODUCT - weighted average based on percentages

_____SUMPRODUCT - weighted average

_____SUMPRODUCT if not blank

_____SUMPRODUCT returns nothing (blank)

1944. SUMPRODUCT if not NA

_____SUMPRODUCT if not error

1945. SUMPRODUCT and IF function

1946. How to simplify IF functions in the SUMPRODUCT function

_____SUMPRODUCT if greater than 0 (zero)

_____SUMPRODUCT if between two dates

1947. SUMPRODUCT if cell contains text

1948. SUMPRODUCT if or

_____SUMPRODUCT – multiple criteria

_____SUMPRODUCT - based on a list of values

_____SUMPRODUCT - multiple conditions and a date range

_____SUMPRODUCT - multiple date ranges

1949. SUMPRODUCT - sum based on daily currency rates

_____Count not blank cells - SUMPRODUCT function

1950. Multiply numbers in each row by entire cell range

_____Multiply cells - recursive LAMBDA function

1951. How to use the SUMPRODUCT function

1952. Things to know about the SUMPRODUCT function

_____How to use the SUMPRODUCT function

1953. How to use a logical expression in the SUMPRODUCT function

_____How to use multiple conditions in the SUMPRODUCT function

1954. How to use OR logic in the SUMPRODUCT function

_____If value in range then return value - INDEX + SUMPRODUCT + ROW

Negative, minus, subtract

_____How to enter negative complex numbers in Excel

_____How to combine columns using negative values - Excel 365

1955. CHOOSEROWS Function example - negative values

1956. DROP Function example - negative values

1957. TAKE Function example - negative values

_____COUNT function - count negative numbers

1958. How to convert a negative number to positive numbers and vice versa?

1959. How to convert all numbers to negative numbers?

1960. Convert negative numbers to positive and calculate the sum

_____Convert negative numbers to positive and calculate the average

1961. Convert negative numbers to positive and calculate the median

_____MIN function ignore negative numbers

_____SMALL function - ignore negative numbers

_____Add or subtract months and days

_____Date function subtract days

1962. How to convert negative numbers to positive numbers?

1963. How to convert positive numbers to negative numbers?

1964. How to change positive numbers to negative numbers and vice versa?

1965. Format positive, negative and zero values differently

_____How to hide negative numbers

_____Random negative numbers with two decimals

_____Random negative numbers with three decimals

_____Is -1 (negative number) equal to TRUE in a logical expression?

_____Extract records containing negative numbers

_____Find positive and negative amounts that net to zero

New line

_____How to identify a new line character in an Excel formula

1966. How to create a new line in an Excel formula

1967. How to show a new line in a cell (wrap text)

Not equal

_____Filter values if not equal to

_____AVERAGEIF function - not equal to

_____Case sensitive condition not equal to

_____SUMIFS function not equal

1968. How to sum not equal to

_____IF function - does not equal

_____VLOOKUP and return multiple values - if not equal to

Or logic

_____Filter values based on a condition per column - OR logic

_____How to filter using OR logic between columns [Formula]

_____AVERAGE - AND OR logic

_____SMALL function - multiple conditions OR logic

_____SMALL function - match records OR logic

_____SMALL function - match multiple values OR logic

_____How to use OR logic in the SUMPRODUCT function

_____COUNTIFS function - OR logic

_____VLOOKUP function with two conditions applied to two columns (OR logic)?

_____VLOOKUP function with many conditions applied to one column (OR logic)?

_____XLOOKUP - two conditions in two columns (OR logic)?

_____XLOOKUP - multiple conditions in one column (OR logic)?

_____Search each column for a string each and return multiple records – OR logic

_____Highlight records – multiple criteria [OR logic]

Overlapping

1969. How to sum overlapping time

1970. Sum overlapping time

_____Sum overlapping time based on a date range

_____Sum overlapping time - Excel 365

_____Count overlapping days across multiple date ranges

_____Count overlapping days in multiple date ranges, part 2

_____Count the number of overlapping date ranges for each date

_____Count overlapping days in multiple date ranges

_____Count overlapping days for all date ranges

_____Count all overlapping days

_____Working with overlapping date ranges

_____Calculate the number of overlapping date ranges

_____Use a drop-down list to select a date range to see overlapping date ranges

1971. How to calculate overlapping time ranges

_____Calculate overlapping hours

_____Identify rows of overlapping records

_____Identify rows of overlapping records - Excel 365

_____Identify rows of overlapping records - earlier versions

_____Find earliest and latest overlapping dates in a set of date ranges based on a condition

_____Prevent overlapping date and time ranges using data validation

_____Filter overlapping date ranges

_____Filter overlapping date ranges - Excel 365

_____Highlight records based on overlapping date ranges and a condition

_____Extract dates from overlapping date ranges

_____Extract dates from overlapping date ranges - Excel 365

_____Highlight overlapping date ranges using conditional formatting

_____Identify overlapping date ranges

_____Identify overlapping date ranges based on a condition

Partial, wildcard, contain

_____Partial match VLOOKUP - asterisk character (wildcard)

_____How to create a string containing column and row delimiting characters

_____How to perform a wildcard xlookup

_____Filter values if contains

_____Filter values if not contain

_____Highlight cells containing string [Conditional formatting]

_____If cell contains any text

_____Count cells with text excluding cells containing a space character

_____Match a range value containing both text and numerical characters

_____Check if a cell contains nonprintable characters

_____Check if a cell range contains nonprintable characters

_____Highlight cells containing nonprintable characters

_____AVERAGEIFS function - wildcard characters

_____AVERAGEIFS Function - contains

_____How to use wildcard characters in the AVERAGEIF function

_____AVERAGEIF function - contains

1972. SUBSTITUTE function wildcard

_____SUMIFS Function example using partial match

_____Highlight cells containing errors

_____Count cells containing text from list

_____If cell contains multiple values

_____Find cells containing all conditions

_____Find cells containing all conditions (Excel 365)

_____Find cells containing at least one condition

_____How to average a column containing some text values

_____SUMPRODUCT if cell contains text

_____How to do a case sensitive partial match using INDEX and MATCH functions

_____How to do a partial case sensitive match using two conditions in two columns

_____Match two columns and return another value on the same row - partial match

_____How to count the number of cells containing numbers based on filtered data?

_____If cell contains text from list

_____Check if the cell contains any value in the list

_____Display matches if cell contains text from list (Excel 2019)

_____Display matches if cell contains text from list (Earlier Excel versions)

_____Check if cell contains value in the list and return the corresponding value

_____INDEX MATCH - partial text multiple conditions Excel 365

_____INDEX MATCH - partial match multiple columns

_____If cell contains text

_____If cell contains partial text

_____If cell contains partial text - hardcoded asterisks

_____If cell contains text then return value

_____If cell contains text then add text in another cell

_____If cell contains text then sum

_____If cell contains text add 1

1973. OR function contains text

_____How to select a cell containing a hyperlink?

_____How to use an asterisk to perform a wildcard match in the SUMIF function

_____VLOOKUP function - Partial match using wildcards

_____VLOOKUP function - Partial match - begins with

_____VLOOKUP function - Partial match - ends with

_____VLOOKUP function - Partial match - contains

_____VLOOKUP function - Partial match - question mark

_____VLOOKUP function - tilde character escapes wildcard characters

_____Partial match and return value with highest level

_____How to extract rows containing digits [Formula]

_____Filter rows containing at least one digit in any cell on the same row (Array formula)

_____Filter rows containing at least one digit in any cell on the same row (Excel 365 formula)

_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)

_____Drop-Down List containing values sorted from A to Z

_____Find cells containing formulas with literal (hardcoded) values

1974. Search for a sequence of cells based on wildcard search

_____How to calculate the first row number of two cells containing search values next to each other vertically?

1975. How to calculate row numbers of two cells containing search values next to each other vertically?

1976. Wildcard search for a sequence

1977. Wildcard search for multiple sequences

_____Merge data sets based on a partial match - wildcard character

_____Wildcard lookups and include or exclude criteria

_____Wildcard lookups and include or exclude criteria - Excel 365

_____Wildcard lookups and include or exclude criteria - array formula

_____Wildcard lookups and include or exclude criteria - autofilter

_____SEARCH function - wildcard characters

_____Cell range contains numbers, text, and blanks?

_____COUNTIFS function - Partial match using wildcard characters

_____IF function - How to check if a cell contains an error?

_____IF function - contains

_____IF function - contains any text

_____COUNTIF Function - Count cells containing a text string - partial match (wildcard)

_____COUNTIF Function - How to count cells containing x number of characters?

1978. Units contained in a range that overlap another range

_____How to do a partial match - wildcard character

_____Match cell that contains a given string

1979. Partial match and return multiple adjacent values

1980. Partial match and return multiple adjacent values corresponding to the number of matching values

_____Partial match and return multiple adjacent values

_____Partial match in multiple columns and return adjacent values

_____Highlight records containing text strings (AND Logic)

_____Filter words containing a given string in a cell range

_____Filter words containing a given string in a cell range - Excel 365 LAMBDA function

_____Match if cell contains string [Array Formula]

_____Return multiple matches with wildcard vlookup

_____Create dependent drop down lists containing unique distinct values in multiple rows

_____Create a drop down list containing alphabetically sorted values

_____Create dependent drop down lists containing unique distinct values

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

_____Extract records containing negative numbers

_____Extract unique distinct values if the value contains the given string

_____Extract unique distinct values if the value contains the given string - Excel 365

_____Extract unique distinct values if the value contains the given string - earlier Excel versions

_____Filter duplicate values in a range using “contain” condition

_____Extract unique distinct text values containing string in a range

_____Filter unique distinct values where adjacent cells contain search string

_____VLOOKUP and return multiple values - if contains

_____VLOOKUP and return multiple values - if not contain

1981. Search and display all cells that contain multiple search strings

_____Sum cells containing numbers and text based on a condition

_____Perform multiple partial matches and return records – AND logic

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using an Excel Table?

_____Partial match based on two conditions

_____Partial match with two conditions and return multiple results

_____Partial match with two conditions and return multiple search results

_____Partial match with two conditions and return multiple search results - Excel 365

_____Partial match for multiple strings – AND logic

_____Partial match for multiple strings - AND logic - returns the first match

_____Partial match for multiple strings - AND logic - returns all matches

_____Partial match for multiple strings - AND logic - returns all matches (Excel 365)

_____Partial match for multiple strings - AND logic - returns all corresponding values

_____Get the column header name that contains the largest/smallest value

_____Extract all rows that contain a value between this and that

Permut

1982. How to use the PERMUTATIONA function

1983. How to use the PERMUT function

1984. PERMUT function example

_____Create a list of permutations using an Excel formula

_____Find the optimal permutation - Excel Solver

_____List permutations with repetition and how many to choose from

_____List permutations with repetition and how many to choose from (Excel 365 formula)

_____List all permutations with a condition

1985. Permutations with and without repetition

1986. Permutations with repetition

1987. Constructing a permutations array with binary values

1988. Permutations without repetition

Random

_____EXPAND Function - values in random order

_____Extract values from given columns and return the list in random order - Excel 365

1989. CHOOSEROWS Function - values in random order

1990. DROP Function - values in random order

1991. TAKE Function - values in random order

1992. WRAPCOLS Function - values in random order

1993. WRAPROWS Function - values in random order

1994. TOROW Function - values in random order

_____How to create a list of unique distinct numbers sorted in random order

_____How to shuffle characters in a text string randomly

1995. How to create a random text string

1996. Sort in random order

_____Insert random characters

_____Insert random characters based on key

1997. How to generate random numbers and text

_____Random numbers with a decimal

_____Random negative numbers with two decimals

_____Random negative numbers with three decimals

1998. Random names

_____Random list

1999. Create random text strings

2000. Assign records unique random text strings

_____How to create random numbers, text strings, dates and time values

2001. Random numbers

2002. Random text strings

_____Random date values

2003. Random time values

_____Calculate running average of last 10 data with random blank cells

_____Sort a list in random order in excel

_____Create a random playlist

_____How to create a list of random unique numbers

Rearrange, distribute

_____Rearrange values to the left if the cell is empty as far as possible

_____Rearrange values to fill empty cells

_____Rearrange values in a cell range to a single column

2004. Rearrange cells in a cell range to vertically distributed values (Excel formula)

2005. Rearrange cells in a cell range to vertically distributed values (Excel 2019)

2006. Distribute values across numerical ranges

2007. Rearrange values using formulas

2008. Rearrange data

_____Rearrange data - Excel 365 LAMBDA function

2009. Search values distributed horizontally and return corresponding value

2010. Search values distributed horizontally and return the corresponding value

_____Filter values distributed horizontally - Excel 365

Record, row

2011. How to use the BYROW function

_____How to count the top 10 numbers in a cell range per row

_____How to count the bottom 10 numbers in a cell range per row

_____How to count the top 10 numbers in a cell range (column-wise) per row

_____Extract a unique distinct list across multiple columns and rows sorted based on frequency

2012. How to use the CHOOSEROWS function

2013. CHOOSEROWS Function example

2014. CHOOSEROWS Function example - array

2015. CHOOSEROWS Function example - split text to array

_____CHOOSEROWS Function example - negative values

_____CHOOSEROWS Function errors

_____CHOOSEROWS Function - values in random order

2016. CHOOSEROWS Function - multiple source ranges

_____Get every other row

_____DROP Function example - exclude columns and rows

_____TAKE Function example - return columns and rows

2017. How to use the WRAPROWS function

2018. WRAPROWS Function example

2019. WRAPROWS Function example - pad with

_____WRAPROWS Function alternative

_____WRAPROWS Function - values in random order

2020. WRAPROWS Function - multiple source ranges

2021. How to use the TOROW function

2022. TOROW Function example

_____TOROW Function example - by column

_____TOROW Function - blanks and errors

_____TOROW Function alternative

_____TOROW Function - values in random order

_____Extract unique distinct rows from multiple cell ranges

_____How to create a string containing column and row delimiting characters

_____How to calculate the relative position of column and row

_____Sort based on row count

2023. Unique distinct rows

_____Extract unique distinct rows

_____Extract unique distinct rows ignoring blank rows

_____Extract unique distinct rows sorted from A to Z ignoring blank rows

2024. Unique rows

_____Extract unique rows

_____Extract unique rows ignoring blank rows

_____Extract unique rows sorted from A to Z ignoring blank rows

_____How to copy every n-th row from a list

2025. Sum a given row using a formula

_____Highlight unique distinct records

_____Highlight a date occurring tomorrow

_____Highlight rows/records

_____Highlight a row if the date is yesterday

_____Highlight a row if the date is today

_____Highlight a row if the date is tomorrow

_____Highlight a row if the date is in the last 7 days

_____Highlight a row if the date is last week

_____Highlight a row if the date is in this week

_____Highlight a row if the date is in next week

_____Highlight a row if the date is in the last month

_____Highlight a row if the date is in this month

_____Highlight a row if the date is in the next month

2026. Sort rows based on the geometric mean

_____Extract unique distinct records from two data sets

2027. Sort rows by variance based on a sample of a population

2028. Sort rows by the variance of a population

_____Count rows with data

2029. Sort rows by standard deviation of a sample

2030. Sort rows based on the median values

2031. Returning values row by row

_____Count non-empty cells per row

_____Sort rows based on the number of non-empty cells

2032. How to use the ROWS function

2033. ROWS function example

_____Count rows in an array

_____Count rows based on a condition

_____Count rows in a string

_____Count rows in multiple cell ranges

_____Get the highest number within each row

_____Sort rows by their highest number within each row

_____Sort columns by their highest number within each row

_____Count numbers per row

2034. Sort rows based on numbers

_____Get value based on row and column number

_____Get value based on row and column number - ADDRESS function alternative

_____Get value based on a row and column number and a worksheet name

_____SMALL function - match records AND logic

_____SMALL function - match records OR logic

_____Match two columns and return another value on the same row

_____Match two columns and return another value on the same row (array formula)

_____Match two columns and return another value on the same row (regular formula)

_____Match two columns and return another value on the same row - case sensitive

_____Match two columns and return another value on the same row - partial match

_____Return the row number of the last value in a column

2035. How to sum a row?

2036. How to add a row

_____How to delete an Excel Table row

2037. Reference a value on the same row

_____How to extract rows containing digits [Formula]

_____Filter rows containing at least one digit in any cell on the same row (Array formula)

_____Filter rows containing at least one digit in any cell on the same row (Excel 365 formula)

_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)

_____TEXTJOIN function - how to add row delimiting characters

_____Count identical values if they are on the same row

_____Count identical values if they are on the same row (Array formula)

_____Count identical values if they are on the same row (Regular formula)

_____Count identical values on the same row comparing values in n columns

_____Multiply numbers in each row by entire cell range

_____What happens if you transpose a range with the same number of columns and rows?

2038. Sort based on frequency row-wise

_____Count value per row

_____Dynamic counting per row sorted from large to small

_____How to calculate the first row number of two cells containing search values next to each other vertically?

_____How to calculate row numbers of two cells containing search values next to each other vertically?

2039. How to calculate a formula every n-th row

_____Highlight every n-th row?

_____Identify rows of overlapping records

_____Identify rows of overlapping records - Excel 365

_____Identify rows of overlapping records - earlier versions

_____Macro deletes entire row if the formula returns blanks

_____Prevent duplicate records in a worksheet

_____Cell ranges with an equal number of rows and columns

_____Cell ranges with different number of rows and columns, ex 1

_____Cell ranges with different numbers of rows and columns, ex 2

2040. Calculate totals row-wise

_____SMALL and ROWS function combined?

_____Assign records unique random text strings

2041. How to use the ROW function

_____ROW function - duplicate columns

2042. Number rows in any cell range

2043. How to number rows

_____COUNTIFS function - Count duplicate records

_____COUNTIFS function - return an array identifying records based on multiple conditions

_____How to get a value in a given cell range based on a row number

_____How to return all values in a row or column in a given cell range with the INDEX function

_____Get a value in a given cell range based on a row and column number

_____How to return the entire row in a given cell range using the INDEX function

_____Group rows based on a condition

_____Unique distinct records sorted based on count or frequency

_____Unique distinct records sorted based on count - Excel 365

_____Unique distinct records sorted based on count - Pivot Table

_____Unique distinct records sorted based on count or frequency - earlier Excel versions

_____Count groups of repeated values per row

_____Dependent drop-down lists in multiple rows

_____Label groups of duplicate records

2044. Copy selected rows (checkboxes) (2/2)

_____Filter unique distinct records using criteria

_____Remove common records between two data sets

_____Remove common rows between two Excel defined tables

_____Remove common rows using an array formula between two data sets

_____Insert blank rows for missing values

_____Search each column for a string each and return multiple records – OR logic

_____Count unique distinct records (rows) in a Pivot Table

_____Count unique distinct records - Pivot Table

_____Count duplicate records - Pivot Table

_____Count unique distinct records with a date and column criteria

_____Filter unique distinct records with a condition

_____Filter unique distinct records case sensitive

_____Filter unique rows case sensitive - Excel 365 LAMBDA function

_____Count unique distinct rows case sensitive

_____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

_____Count unique distinct rows case sensitive

_____Filter records based on a date range and a text string

_____Highlight records containing text strings (AND Logic)

_____Highlight records [AND logic]

_____Highlight records – multiple criteria [OR logic]

_____Filter duplicate records

_____Merge matching rows

_____Concatenate cell values in a row into a single cell

_____Concatenate a multi-column and multi-row cell range

_____Count unique distinct records

_____Compare tables: Filter records occurring only in one table

_____Compare tables: Highlight records not in both tables

_____Compare two lists of data: Highlight common records

_____Filter shared records from two tables

_____Extract duplicate records

_____Highlight duplicate records

_____Highlight duplicate records - Excel 2007 and later versions

_____Highlight duplicate records - Excel 2003 and previous versions

_____Create dependent drop down lists containing unique distinct values in multiple rows

_____Sort rows based on frequency and criteria

_____Sort rows based on frequency and criteria - Excel 365

_____Sort rows based on frequency and criteria - earlier versions

_____Highlight records based on overlapping date ranges and a condition

_____Sort records based on two columns

_____List all unique distinct rows in a given month

_____List all unique distinct rows in a given month and year

_____List all unique distinct rows in a given month and year (Excel 365)

_____List all rows in a given month and year

_____List all rows in a given month and year (Excel 365)

_____Match two criteria and return multiple records

_____Match two criteria and return multiple records [Array Formula]

_____Match two criteria and return multiple records [Excel 365]

_____Match two criteria and return multiple records [Excel defined Table]

_____Extract records containing negative numbers

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a number sequence to count records by individual products and years

_____If value in range then return value - INDEX + SUMPRODUCT + ROW

_____VLOOKUP/XLOOKUP of three columns to pull a single record

_____VLOOKUP of three columns to pull a single record

_____XLOOKUP of three columns to pull a single record

_____FILTER records based on three conditions

_____Use VLOOKUP to search date in date ranges and return value on the same row

_____Lookup and find the most recent date, return another value on the same row

_____VLOOKUP - Extract multiple records based on a condition

_____Extract records where all criteria match if not empty

_____Extract all rows from a range that meet criteria in one column

_____Extract all rows from a range based on range criteria (Array formula)

_____Extract all rows from a range based on range criteria - Excel 365

_____Extract all rows from a range based on multiple conditions (Array formula)

_____Extract all rows from a range based on multiple conditions - Excel 365

_____Extract all rows from a range based on range critera [Excel defined Table]

_____Extract all rows from a range based on range critera [AutoFilter]

_____Perform multiple partial matches and return records – AND logic

2045. Search for a text string in a data set and return multiple records

2046. Search for a text string in a data set and return multiple records [Array formula]

_____Search for a text string in a data set and return multiple records [Excel 365]

2047. Search for a text string in a data set and return multiple records [Excel defined Table]

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using an Excel Table?

_____Highlight every other row

_____Extract all rows that contain a value between this and that

_____Extract records between two dates

_____Filter rows using array formulas based on a date range - Excel 365

_____Filter rows using array formulas based on a date range - earlier Excel versions

_____Filter rows using an Excel table based on a date range

_____Filter rows based on a date range - Autofilter

_____Extract unique distinct records based on a criterion

_____Filter unique distinct records

_____Filter unique distinct row records

_____Filter unique distinct row records but not blanks

_____Filter unique distinct row records that does not begin with *string*

_____Filter unique distinct row records that begins with *string*

_____Filter unique distinct records [Pivot table]

2048. ROW function and OFFSET function

Recursive

_____Multiply cells - recursive LAMBDA function

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Filter unique distinct rows case sensitive - Excel 365 recursive LAMBDA function

_____Fuzzy lookups - Excel 365 recursive LAMBDA function

Reference

2049. IMTAN function example 2 - cell reference

_____Can I use the FILTER function with an Excel Table and structured references?

_____How to count cells in a cell reference

_____Reference isn't valid error

_____Excel found a problem with one or more formula references

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

2050. How do structured references work?

2051. Reference an entire Excel Table

2052. Reference Excel Table data

_____Reference column headers

_____Reference a column

_____Reference a value on the same row

_____Extract cell references from a formula

2053. Absolute and relative cell references - regex

2054. Cell reference to a cell range - regex pattern

2055. Cell references to other worksheets - regex pattern

2056. Cell references to other workbooks - regex pattern

2057. How to use cell references in array formulas?

2058. How to adjust cell references in the array formula to your worksheet

2059. How to create a cell reference using the INDIRECT function?

2060. How to create a cell reference to a worksheet name using the INDIRECT function?

2061. How to hardcode a cell reference?

2062. Working with cell references

_____COUNTIF Function - Absolute and relative cell reference

_____How to build a dynamic cell reference using the INDEX function

_____Two-way lookup in multiple cross reference tables simultaneously

_____List all named ranges and their cell references

2063. How to use absolute and relative references

2064. Create a cell reference to a cell range

_____List all named ranges and their cell references

Relation, related

2065. ARRAYTOTEXT Function - compare related functions and techniques

2066. Comparing related functions

_____Merge two relational data sets

_____Highlight lookups in relational tables

2067. Working with three relational tables

_____Extract unique distinct values from a relational table

_____Lookups in relational tables

2068. Search for values in a related table

_____Search for values in a related table - Excel 365

2069. Sum values in a related table

_____Sum values in a related table - Excel 365

_____Search related table based on a date and date range

Reverse

2070. Flip/reverse a cell range both horizontally and vertically

_____How to perform a reverse search - starting with the last item

_____How to reverse a list using the SEQUENCE function?

_____MID function - reverse characters in value

_____Lookup and match last value – reverse lookup

2071. How to create a reverse running total?

_____Reverse two-way lookups

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

2072. Reverse horizontal axis

2073. Reverse text

_____Reverse a list ignoring blanks

_____Reverse a list ignoring blanks - Excel 365

_____Reverse a list ignoring blanks - manual steps

Right, left

_____EXPAND Function example - how to extend an array up and left

_____Rearrange values to the left if the cell is empty as far as possible

2074. Search right to left

2075. How to use the COS function with a right or right-angled triangle

2076. How to use the SIN function with a right or right-angled triangle

2077. SUBSTITUTE function from right

2078. LEFT function for numbers

2079. How to use the RIGHT function

2080. RIGHT function example

2081. RIGHT function not working

2082. How to use the LEFT function

2083. LEFT function Example

_____LEFT until character

_____LEFT function until space

_____LEFT function until second space

2084. LEFT until dash

2085. LEFT until number

_____LEFT function remove characters

_____LEFT function for numbers

2086. MID function from right

_____How to insert 0 (zeros) to the right of the decimal point

_____How to add 0 (zeros) to the right and left of the decimal point

_____VLOOKUP - What if the lookup value is not in the leftmost column?

2087. Alright, show me some useful array formulas?

_____What if I don't have the lookup column in the left-most column?

Running total

2088. Calculate running total interest paid

2089. Calculate running total principal paid

2090. How to create running totals

2091. Create a formula that returns running totals

_____Running totals with a condition

_____Running totals on a monthly basis

_____Display a running total when the month changes

2092. How to create a running total (SUM function)?

_____How to create a reverse running total?

_____Running totals based on criteria

_____Running totals based on criteria - formula

_____Running totals based on criteria - formula and Excel Table

_____Running totals based on criteria - Excel Table

Schedule

2093. Fixed payments calculator and amortization schedule

_____Get date ranges from a schedule

_____Get date ranges from a schedule - Excel 365

_____Get date ranges from a schedule - earlier Excel versions

2094. Shift Schedule

_____Schedule project dates based on a finish date

2095. Watch schedule that populates vacation time

2096. Free School Schedule Template

_____Extract dates from a cell block schedule

_____Setting up your work hours in a weekly schedule

_____Populate cells dynamically in a weekly schedule

_____Find empty hours in a weekly schedule

_____Schedule recurring expenses in a calendar in excel (Personal Finance)

_____Highlight specific time ranges in a weekly schedule

2097. Weekly schedule template

2098. Using Excel Solver to schedule employees

Second

_____How to calculate the second solution of the square root of a complex number?

2099. How to use the SECOND function

_____Seconds value larger than 59

2100. TIME function - how to add seconds

2101. Length of second longest consecutive sequence of a value?

2102. Value of the second longest consecutive sequence?

_____Lookup value based on two critera – second criteria is the adjacent value and its position in a given list

Sequence, consecutive

2103. How to use the SEQUENCE function

2104. SEQUENCE Function example

_____Why does the SEQUENCE function return a #SPILL! error?

_____The SEQUENCE function returns a #NAME! error?

_____How to create a dynamic calendar using the SEQUENCE function?

2105. How to create a repeating sequence?

2106. How to create repeated numbers in a sequence?

_____How to create blanks in a sequence of numbers?

2107. How to format numbers in sequence with leading zeros?

_____How to reverse a list using the SEQUENCE function?

_____How to create a sequence of dates based on a start date?

_____How to create a sequence of months?

2108. How to create a sequence of weeks?

2109. How to create a sequence of quarters?

_____How to create a sequence of letters?

2110. How to create a sequence of cells?

_____Is there an alternative to the SEQUENCE function?

2111. Create a horizontal sequence

2112. How to create a repeating sequence

_____Find the most/least consecutive repeated value

2113. Length of the shortest consecutive sequence of a value?

2114. Value of the shortest consecutive sequence?

_____Length of second longest consecutive sequence of a value?

_____Value of the second longest consecutive sequence?

_____Search for a sequence of cells based on wildcard search

_____Lookup for a multi-level sequence

_____Lookup for multiple multi-level sequences

_____Wildcard search for a sequence

_____Wildcard search for multiple sequences

2115. Search for a sequence of values

_____How to find a sequence with any value between?

_____Find multiple sequences with any value between?

_____Find all sequences of consecutive dates

_____Find all sequences of consecutive dates - Excel 365

_____List non consecutive dates - Excel 365

_____Find all sequences of consecutive dates - earlier Excel versions

_____List non consecutive dates - earlier Excel versions

_____Highlight consecutive dates using Conditional Formatting

_____List consecutive numbers

_____List non consecutive numbers

2116. Create number sequences (Autofill)

2117. Create a repeating number sequence

_____Create a number sequence and restart when a cell value equals a condition

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a number sequence to count dates based on year

_____Create a number sequence to count items

_____Create a number sequence to count prices within given amounts

_____Create a number sequence to count records by individual products and years

_____How to identify two consecutive dates in a list

_____Print consecutive page numbers across multiple worksheets

Shared, common, exist

_____Filter values that exists in all three columns

_____Remove common records between two data sets

_____Remove common rows between two Excel defined tables

_____Remove common rows using an array formula between two data sets

_____Compare two lists of data: Highlight common records

_____Filter shared records from two tables

_____Filter common values between two ranges

_____Filter common values between two nonadjacent cell ranges - Excel 365

_____Filter common values between two nonadjacent cell ranges - Excel 2019

_____Filter common values between two nonadjacent cell ranges

_____Filter common values from three separate columns

_____Compare two columns and highlight values in common

_____Count how many times a string exists in a cell range (case insensitive)

_____How to extract not shared values in two columns

_____Extract shared values between two columns

_____Extract shared values between two columns - Excel 365

_____Extract shared values between two columns (case sensitive)

_____Filter common values from three separate columns

_____What values are missing in List 1 that exists i List 2?

_____Extract values that exist only in one of the two columns

_____Extract values that exist only in one of the two columns - Excel 365

Small, smaller, less

_____How to sort from smallest to largest?

_____How to sort from largest to smallest?

_____Sum numbers based on items and return totals sorted from large to small

_____Filter values if smaller than

_____How to ignore error values using the SMALL function

_____How to find the smallest number excluding zeros

_____SWITCH Function - how to use logical operators like larger than and smaller than

2118. SMALL function with multiple cell ranges

_____MAXIFS function - smaller than

_____Column function and SMALL function

_____AVERAGEIF function - smaller than

_____SMALL function – INDEX MATCH

_____SMALL function - INDEX MATCH

_____SMALL function - INDEX MATCH (Excel 365)

_____How to ignore zeros using the SMALL function

_____SMALL function - ignore zeros (array formula)

_____SMALL function - ignore zeros (regular formula)

_____SMALL function - ignore zeros (Excel 365)

_____SMALL function - ignore negative numbers

_____SMALL function – multiple conditions

_____SMALL function - multiple conditions AND logic

_____SMALL function - multiple conditions OR logic

_____SMALL function - match records AND logic

_____SMALL function - match records OR logic

_____SMALL function - match multiple values OR logic

2119. SMALL function for text

_____SMALL function for text - Excel 365

_____SMALL function ignore duplicates

2120. SMALL function with duplicates (Excel 2016)

2121. SMALL function with duplicates (previous Excel versions)

_____SMALL function with duplicates (Excel 365)

_____SMALL function with duplicates based on a condition

_____How to extract the smallest number from filtered data?

_____How to sum if a number is smaller than a given condition

_____How to sum values greater than smaller than?

_____Dynamic counting per row sorted from large to small

_____Calculate total cost based on different rates per hour (smaller formula)

_____Find the largest value in lookup_vector that is less than or equal to lookup_value

2122. How to use the SMALL function

_____How to use SMALL function with criteria?

_____SMALL and ROWS function combined?

2123. SMALL function examples

_____IF function - smaller than

_____COUNTIF Function - Count cells larger/less than a criterion

_____Find smallest and largest unique number

_____Get the smallest number larger than a given number and a condition

_____Get the smallest number larger than a given number and criteria

_____VLOOKUP and return multiple values - if smaller than

_____How to find the smallest duplicate number

_____How to find the smallest duplicate number - Excel 365

_____How to find the smallest unique number

_____How to find the smallest unique number - Excel 365

_____Highlight smallest duplicate number

_____Highlight the smallest duplicate number

_____Get the largest/smallest number

_____Get the column header name that contains the largest/smallest value

_____Get the cell address of the largest/smallest number

_____Create a link to the largest/smallest number

_____How to highlight the largest and smallest value

_____Find the smallest number in a list that is larger than a given number

_____Find the smallest number that is larger than a given number - [Excel 2016]

_____Find the smallest number that is larger than a given number - earlier Excel versions

_____Find the largest number that is smaller than a given number - [Excel 2016]

_____Find the largest number that is smaller than a given number - earlier Excel versions

_____How to find the k-th smallest number that is larger than a given number?

_____How to find the k-th largest number that is smaller than a given number?

Solver

2124. Solve linear equations using Solver

_____Test combinations (Solver)

_____Find the optimal permutation - Excel Solver

_____Using Excel Solver to schedule employees

_____Identify numbers in sum using Excel solver

Sort, A to Z, z to a, ascending, descending

_____Extract a unique distinct list across multiple columns and rows sorted based on frequency

_____How to create a list of unique distinct numbers sorted in random order

_____Sort in random order

2125. How to use the SORTBY function

2126. SORTBY Function example

_____Why does the SORTBY function return a #SPILL! error?

_____The SORTBY function returns a #NAME! error?

_____Does the SORTBY function differentiate between upper and lower letters?

2127. How to sort from A to Z?

2128. How to sort from Z to A?

_____How to sort from smallest to largest?

_____How to sort from largest to smallest?

_____How to sort by multiple columns?

_____Sort by another column

_____How to sort by the first letter/digit?

_____How to sort by the first letter - Example 2

_____How to sort by the first digit - Example 3

2129. How to sort by absolute value?

_____How to sort by the last word in a cell?

_____How to sort by the first name?

_____How to sort by the last name?

_____How to sort by custom list?

_____How to sort by month?

2130. Sort by word length

_____Sort in random order

2131. Sort by week number

2132. Sort by quarter

_____Sort based on row count

2133. How to use the SORT function

2134. SORT Function example

_____Why does the SORT function return a #SPILL! error?

_____How to sort a multicolumn cell range

_____How can I sort letters and numbers?

_____Sort based on values in an adjacent column

_____Is the SORT function case sensitive?

2135. Can you sort data based on an Excel Table?

_____Sort by column (vertically)?

_____How to sort by column header?

_____Sum numbers based on items and return totals sorted from large to small

_____Sort based on item count

_____How to sort a multicolumn cell range

_____Filter values based on a condition sorted from A to Z

_____Extract unique distinct values sorted from A to Z

_____Extract unique distinct values sorted from A to Z ignoring blanks

_____Extract unique values sorted from A to Z

_____Extract unique values sorted from A to Z ignoring blanks

_____Extract unique distinct rows sorted from A to Z ignoring blank rows

_____Extract unique rows sorted from A to Z ignoring blank rows

_____Sort rows based on the geometric mean

_____Sort columns based on the geometric mean

_____Sort rows by variance based on a sample of a population

_____Sort rows by the variance of a population

_____Sort rows by standard deviation of a sample

_____Sort rows based on the median values

_____Sort columns based on the median values

_____Sort rows based on the number of non-empty cells

_____Sort columns based on the number of non-empty cells

_____Sort rows by their highest number within each row

_____Sort columns by their highest number within each row

_____Sort rows based on numbers

_____Sort columns based on numbers

_____Sort highlighted numbers

_____Extract a list of alphabetically sorted duplicates based on a condition

_____Extract a list of alphabetically sorted duplicates based on a condition - Excel 365

_____Unique distinct list sorted alphabetically based on a condition

_____Unique distinct list sorted alphabetically based on a condition - Earlier Excel versions

_____Unique distinct list sorted alphabetically based on a condition - Excel 365

_____Unique distinct list sorted alphabetically based on a range - Earlier Excel versions

_____Unique distinct list sorted alphabetically based on a range - Excel 365

_____Use VLOOKUP and return multiple values sorted from A to Z

_____Extract multiple values based on a search value sorted from A to Z

_____Extract multiple values based on a search value sorted from A to Z (Excel 365)

2136. How to sort an Excel Table

_____Sort values by corresponding text arranged in a column

2137. Sort items by adjacent number in every other value - Array formula

_____Sort items by adjacent number in every other value - Excel 365 formula

2138. Sort items by adjacent number in every other value horizontally

2139. Sort items by adjacent number in every other value

_____Sort items by adjacent number in every other value - Array formula

_____Sort items by adjacent number in every other value - Excel 365 formula

2140. Sort items by adjacent number in every other value vertically

_____Sort based on frequency row-wise

_____Dynamic counting per row sorted from large to small

_____Drop-Down List containing values sorted from A to Z

2141. Sort data

_____Sort and return unique distinct single digits from cell range

_____Find last matching value in an unsorted list

_____Sort by multiple columns

_____Sort by multiple columns using an Excel Table

_____Sort by multiple columns using the SORTBY function (Excel 365)

_____Sort by multiple columns using formula (Previous Excel versions)

_____Lookup and return multiple sorted values based on corresponding values in another column

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel 365

_____Lookup and return multiple sorted values based on corresponding values in another column - previous Excel versions

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel Table

_____Sort highlighted values

_____Lookup_array in ascending order

_____Lookup_array in descending order

2142. Sort data set using formula

_____Sort data set using Excel's "Sort & Filter"

_____Sort values in a cell based on a delimiting character

_____Sort values in a cell based on a delimiting character (Formula)

_____Sort values in a cell based on a delimiting character (Macro)

2143. Sort algorithm

_____Unique distinct records sorted based on count or frequency

_____Unique distinct records sorted based on count - Excel 365

_____Unique distinct records sorted based on count - Pivot Table

_____Unique distinct records sorted based on count or frequency - earlier Excel versions

_____Filter unique distinct values, sorted and blanks removed from a range

2144. How to sort a data set in a custom order

_____Compare two columns and return differences sorted from A to Z

_____Compare two columns and return differences sorted from A to Z - Excel 365

_____Create a drop down list containing alphabetically sorted values

_____Sort rows based on frequency and criteria

_____Sort rows based on frequency and criteria - Excel 365

_____Sort rows based on frequency and criteria - earlier versions

_____Sort a list in random order in excel

_____Sort records based on two columns

_____Extract a unique distinct list sorted from A to Z ignore blanks

_____Extract a unique distinct list sorted from A to Z and ignore blanks

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition

_____List unique distinct sorted values removing blanks based on a condition - Excel 365

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

2145. Sort numeric values based on proximity to a given number

_____Extract sorted unique distinct years and months based on a list of dates - Excel 365

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Sort two columns

_____Match a date when a date range is entered in two cells sorted in ascending order

_____Match a date when a date range is entered in two cells with gaps not sorted

_____Extract unique distinct values sorted based on sum of adjacent values

_____Extract unique distinct values sorted based on sum of adjacent values - Excel 365

_____Extract unique distinct values sorted based on sum of adjacent values - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

_____Filter unique values sorted from A to Z

2146. Sort text values by length

_____Create unique distinct list sorted based on text length

2147. Unique distinct values sorted based on frequency

_____Unique distinct values sorted based on frequency - Excel 365

_____Unique distinct list from a column sorted A to Z

_____Extract unique distinct values A to Z from a range and ignore blanks

_____Extract unique distinct values A to Z from a range and ignore blanks - Excel 365

_____Extract unique distinct values A to Z from a range and ignore blanks

2148. Sort a range based on value frequency

_____Filter duplicate values and sort by corresponding date

_____Filter unique values and sort based on adjacent date

2149. Sort a range from A to Z [Array formula]

_____Extract a unique distinct list sorted from A-Z from range

_____Extract a list of alphabetically sorted duplicates from a column

_____Sort text cells alphabetically from two columns

_____Sort text from two columns combined (array formula)

_____Sort dates within a date range

_____Populate drop down list with unique distinct values sorted from A to Z

2150. Sort values using array formula

_____Sort column based on frequency

_____Sort column based on the frequency

_____Sort column by frequency - Excel 365

_____Extract a unique distinct list sorted from A to Z

2151. Sort Conditional formatted cells at the top

2152. Sort unique values at the top

_____Sort a column alphabetically

_____Sort a column - Excel 365

_____Sort a column using array formula

_____Two columns sorting by the second column - Excel 365

_____Two columns sorting by the second column

2153. Sort alphanumeric values

Split

_____Workaround for the TEXTSPLIT function – LAMBDA function

_____Split characters horizontally to a cell each

_____CHOOSEROWS Function example - split text to array

2154. How to use the TEXTSPLIT function

2155. TEXTSPLIT Function example

_____TEXTSPLIT function - remove #N/A errors

2156. TEXTSPLIT function - pad each value with a given string

_____Split string using multiple delimiting characters

_____How to split date value

_____Split string and remove decimals

_____Split date from a date and time value

_____Split time from a date and time value

_____Split characters to a cell each horizontally counting backwards

_____MID function - split characters into an array

2157. Split search value using a delimiter and search for each substring

_____Split expenses calculator

_____How to split expenses evenly (Excel 365)

_____Prepare data for Pivot Table – How to split concatenated values?

_____Text to columns: Split words in a cell

_____Split words in a cell - blank as a delimiting character

_____Split words in a cell - any delimiting character(s)

_____Split words in a cell - Excel 365 formula

_____Split words in a cell - Excel 365 formula - any delimiting character(s)

2158. Split words in a cell - Rick Rothstein's formula

_____Split words in a cell - Rick Rothstein's formula - Any delimiting character(s)

_____Split words in a cell - FILTERXML function - any a delimiting character

_____Split words in a cell range into a cell each - Excel 365

_____Split values equally into groups

String

2159. How to decode URL-encoded strings

_____Extract values between two given delimiting strings

_____Extract values between two given strings in a cell range

_____TEXTSPLIT function - pad each value with a given string

_____Split string using multiple delimiting characters

_____How to create a string containing column and row delimiting characters

_____Extract string between two substrings

_____How to shuffle characters in a text string randomly

_____How to create a random text string

_____Highlight cells containing string [Conditional formatting]

_____FIND function returns all positions of a given substring

_____Split string and remove decimals

2160. CLEAN function - string

_____Count blanks in a text string

_____Count non-empty values in a string

_____Count columns in a string

_____Count rows in a string

_____LARGE function - based on a textstring

_____How to convert comma delimiting numbers to a string of characters

2161. How to convert string to ANSI numbers - CODE Function

_____Identify digits in a string

2162. Substitute multiple strings

_____Substitute all letters with a given string

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

_____Count matching strings using regular expressions

_____Split search value using a delimiter and search for each substring

_____Match each substring to a table - Excel 365

_____Find and replace strings in file names, folder name and subfolders

2163. Convert string to HEX

2164. Convert string to ASCII

2165. Convert string to Base64

2166. Decode a Base64 value to string - Excel formula

_____Create random text strings

_____Assign records unique random text strings

_____What happens if a text string is used in the logical expression?

_____COUNTIF Function - Count cells containing a text string - partial match (wildcard)

_____Match cell that contains a given string

_____Match cell that begins with a specific string and ends with another string - any number of characters in between

_____Match cell that begins with string and ends with another string - a single character in between

2167. Substitute multiple text strings

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Count specific multiple text strings in a given cell range

_____Count specific multiple text strings in a given cell range - case sensitive

_____Count specific multiple text strings in a given cell range - case insensitive

_____How to create random numbers, text strings, dates and time values

_____Random text strings

_____Search each column for a string each and return multiple records – OR logic

_____Filter records based on a date range and a text string

_____Highlight records containing text strings (AND Logic)

_____Filter words containing a given string in a cell range

_____Filter words containing a given string in a cell range - Excel 365 LAMBDA function

_____Match if cell contains string [Array Formula]

_____Searching for the first characters in a text string [Array Formula]

_____Filter unique strings from a cell range

_____Filter unique strings in a range - Excel 365

_____Extract unique distinct values if the value contains the given string

_____Extract unique distinct values if the value contains the given string - Excel 365

_____Extract unique distinct values if the value contains the given string - earlier Excel versions

_____Extract unique distinct text values containing string in a range

_____Filter duplicate values from a range that begins with string

_____Extract unique distinct values from cell range that begins with string

_____Filter unique distinct values where adjacent cells contain search string

_____Search and display all cells that contain multiple search strings

2168. Exact word in string

_____Count text string in a range (case sensitive)

_____Search for a text string in a data set and return multiple records

_____Search for a text string in a data set and return multiple records [Array formula]

_____Search for a text string in a data set and return multiple records [Excel 365]

_____Search for a text string in a data set and return multiple records [Excel defined Table]

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using an Excel Table?

_____Count a specific text string in a cell

_____Count text string in a range (case sensitive)

_____Partial match for multiple strings – AND logic

_____Partial match for multiple strings - AND logic - returns the first match

_____Partial match for multiple strings - AND logic - returns all matches

_____Partial match for multiple strings - AND logic - returns all matches (Excel 365)

_____Partial match for multiple strings - AND logic - returns all corresponding values

_____Count how many times a string exists in a cell range (case insensitive)

_____How to search for a string in a column

_____Filter unique distinct row records that does not begin with *string*

_____Filter unique distinct row records that begins with *string*

Substitute, replace

2169. How to use the REPLACE function

2170. REPLACE function example

2171. REPLACE function not working

2172. How to replace part of formula in all cells

2173. How to use the SUBSTITUTE function

2174. SUBSTITUTE function example

_____SUBSTITUTE function wildcard

2175. SUBSTITUTE function quotation mark

_____Substitute multiple strings

_____SUBSTITUTE function from right

_____Substitute all letters with a given string

2176. SUBSTITUTE function all numbers

2177. SUBSTITUTE function based on table

2178. How to substitute double quotes

_____Find and replace strings in file names, folder name and subfolders

_____Can you replace the VLOOKUP function with the INDEX function?

_____Substitute multiple text strings

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

Subtotal

2179. How to use the SUBTOTAL function

_____Does the SUBTOTAL function avoid double counting?

2180. How to include manually hidden values in the SUBTOTAL function?

_____How to exclude manually hidden values from the SUBTOTAL function?

2181. How to use the Subtotal tool

2182. Start the Subtotal tool

2183. Subtotals on multiple levels

_____Count cells based on conditionally formatted background color using Filter tool and SUBTOTAL function [Excel 365]

2184. SUBTOTAL and OFFSET functions

Sum, total

2185. How to use the IMSUM function

2186. IMSUM function example

_____How to calculate the sum of two complex numbers in rectangular form?

_____How to plot the sum of two complex numbers?

_____Sum numbers based on items and return totals sorted from large to small

2187. How to sum a cell range

2188. How to sum selected values

_____Sum a column using a formula

_____Sum a given column using a formula

_____Sum a given row using a formula

2189. Sum using an Excel defined Table

2190. Sum unique distinct numbers

_____Calculate running total interest paid

_____Calculate running total principal paid

2191. How to use the DSUM function

2192. How to use the SERIESSUM function

2193. How to use the SUMXMY2 function

2194. How to use the SUMX2PY2 function

2195. How to use the SUMX2MY2 function

2196. How to use the SUMSQ function

_____How to sum overlapping time

_____Sum overlapping time

_____Sum overlapping time based on a date range

_____Sum overlapping time - Excel 365

_____Count total characters in multiple cell ranges combined

2197. AGGREGATE function - SUM

_____Calculate a sum based on a case sensitive condition

_____Convert negative numbers to positive and calculate the sum

_____How do I sum values between n-th weekday this month and n-th weekday next month?

_____Sum by group

_____How to sum filtered data?

_____Sum numbers between two dates

_____Sum by month and year

2198. Sum by text

_____Sum by category

_____Sum by group

_____Sum by column value

2199. Sum by color

_____If cell contains text then sum

_____How to sum based on a condition

_____How to sum based on a condition in another column

_____How to sum if a number is smaller than a given condition

_____How to sum if a number is larger than a given condition

_____How to sum based on a date

_____How to sum if a date is later than a given condition

_____How to sum if a date is earlier than a given condition

_____How to sum numbers using a list of conditions

_____How to sum not equal to

_____How to create running totals

_____Create a formula that returns running totals

_____Running totals with a condition

_____Running totals on a monthly basis

_____Display a running total when the month changes

_____Find empty cells and sum cells above

2200. Add grand totals that only sums cells populated with formulas - Excel 2013

_____Add grand totals that only sums cells populated with formulas - Excel 365

2201. How to use the SUM function

_____How to add numbers in a column and return a total (SUM function)?

2202. How to add numbers in an array (SUM function)?

2203. How to sum specific cells?

2204. How to sum numbers from multiple cell ranges (SUM function)?

_____How to sum a column with text (SUM function)?

2205. How to sum boolean values?

_____How to create a running total (SUM function)?

_____How to sum numbers based on a condition/label/item/category?

_____SUM with multiple conditions

2206. How to sum only visible cells?

_____How to sum a filtered column?

_____How to sum the entire column?

_____How to sum a row?

2207. How to sum across worksheets?

2208. How to sum by color?

2209. How to sum absolute values?

2210. What is the shortcut key for the SUM function?

_____How to sum values greater than smaller than?

2211. How to sum values below/above 0 (zero)?

2212. How to limit SUM function?

_____How to sum a column and ignore errors?

_____How to sum values by date?

2213. How to sum values by week?

_____How to sum values by month?

2214. How to sum values by year?

_____How to sum values between two dates?

_____How to create a reverse running total?

_____VLOOKUP sum

_____How to insert a total to an Excel Table and sum using a condition

2215. How to show Excel Table totals

2216. Totals worksheet

_____Sum all digits in a number - (formula)

2217. Sum numerical ranges between two numbers

2218. How to manually sum ranges

2219. How to sum ranges in Excel

_____How to sum time across days with a start and end time each day

_____Calculate total cost based on different rates per hour

_____Calculate total cost based on different rates per hour (smaller formula)

_____Calculate total cost based on different rates per hour across days

_____Find numbers closest to sum

_____Find numbers closest to sum - Excel 365

_____Find numbers in total with a condition

_____Find numbers in total with a condition - Excel 365

2220. How to create an INDIRECT sum?

_____Compare two lists and filter unique values where the sum in one column doesn’t match the other column

_____Remove totals

_____Calculate totals row-wise

_____Calculate totals column-wise

_____How to calculate totals of stock transactions based on dates

_____Sum values in a related table

_____Sum values in a related table - Excel 365

_____Sum cells based on criteria

2221. Sum unique distinct invoices

_____Running totals based on criteria

_____Running totals based on criteria - formula

_____Running totals based on criteria - formula and Excel Table

_____Running totals based on criteria - Excel Table

_____Extract a unique distinct list and sum amounts based on a condition

_____Sum based on OR – AND logic

_____Identify numbers in sum using Excel solver

_____Sum values between two dates and based on a condition

_____Extract unique distinct values sorted based on sum of adjacent values

_____Extract unique distinct values sorted based on sum of adjacent values - Excel 365

_____Extract unique distinct values sorted based on sum of adjacent values - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

_____Sum cells containing numbers and text based on a condition

2222. Sum number based on corresponding unique value

2223. Sum unique numbers

_____Sum unique distinct numbers

_____Sum number based on corresponding unique value

2224. Sum cells with check boxes

2225. Sum only visible cells

Sumif

2226. How to use the SUMIF function

_____How to use an asterisk to perform a wildcard match in the SUMIF function

2227. How to use a question mark in the SUMIF function

2228. Add grand totals that only sums cells populated with formulas - SUMIF function

_____SUMIF across multiple sheets

_____SUMIF across multiple sheets - Excel 365 formula

Sumifs

_____How to use the SUMIFS function

_____SUMIFS function greater than

_____SUMIFS function not equal

_____SUMIFS function multiple criteria

_____SUMIFS function or

_____SUMIFS Function example using partial match

_____How to use logical operators in the SUMIFS function

Sumproduct

_____SUMPRODUCT and nested IF functions

_____SUMPRODUCT - nested IF functions

_____SUMPRODUCT - weighted average based on percentages

_____SUMPRODUCT - weighted average

_____SUMPRODUCT if not blank

_____SUMPRODUCT returns nothing (blank)

_____SUMPRODUCT if not NA

_____SUMPRODUCT if not error

_____SUMPRODUCT and IF function

_____How to simplify IF functions in the SUMPRODUCT function

_____SUMPRODUCT if greater than 0 (zero)

_____SUMPRODUCT if between two dates

_____SUMPRODUCT if cell contains text

_____SUMPRODUCT if or

_____SUMPRODUCT – multiple criteria

_____SUMPRODUCT - based on a list of values

_____SUMPRODUCT - multiple conditions and a date range

_____SUMPRODUCT - multiple date ranges

_____SUMPRODUCT - sum based on daily currency rates

_____Count not blank cells - SUMPRODUCT function

_____How to use the SUMPRODUCT function

_____Things to know about the SUMPRODUCT function

_____How to use the SUMPRODUCT function

_____How to use a logical expression in the SUMPRODUCT function

_____How to use multiple conditions in the SUMPRODUCT function

_____How to use OR logic in the SUMPRODUCT function

_____If value in range then return value - INDEX + SUMPRODUCT + ROW

Tab

2229. How to create a tab in an Excel formula

2230. Tabula recta

Table, excel table

_____Can you sort data based on an Excel Table?

_____Can I use the FILTER function with an Excel Table and structured references?

_____Sum using an Excel defined Table

2231. How to create a frequency table based on text values

2232. How to create a frequency table based on numerical values

_____Count columns in multiple Excel Tables

_____SUBSTITUTE function based on table

_____How to create a link to an Excel Table

_____Two-dimensional lookup using two tables

_____Filter duplicate values using criteria - Excel Table

_____HLOOKUP - multiple tables

_____VLOOKUP - how to use multiple tables

_____How can I use multiple tables to calculate a discount based on different price levels?

_____How to perform two-way lookup in multiple tables - 2D

_____Reverse two-way lookups in a cross reference table [Excel 2016]

_____Reverse two-way lookups in a cross reference table [All excel versions]

_____Reverse two-way lookup in a cross reference table

_____Match each substring to a table - Excel 365

2233. How to use Excel Tables

2234. How to create an Excel Table

2235. How to name an Excel Table

2236. How to manipulate Excel Table data

2237. How to edit an Excel Table value

_____How to delete an Excel Table value

_____How to delete an Excel Table row

_____How to delete an Excel Table column

_____How to delete an Excel Table and keep values

_____How to sort an Excel Table

_____How to filter an Excel Table

_____How to insert a total to an Excel Table and sum using a condition

_____Reference an entire Excel Table

_____Reference Excel Table data

2238. How to use a formula in an Excel Table

2239. How to change Excel Table formatting

_____How to show Excel Table totals

_____List all tables in a workbook - Named ranges

_____How to link a drop-down list to an Excel Table (Data validation)

_____Working with filtered Excel Tables

_____How to quickly find an Excel Table in a workbook

_____Filter rows containing at least one digit in any cell on the same row (Formula and an Excel Table)

_____How to apply Conditional Formatting to an Excel table

2240. Copy Excel Table and new formulas

2241. Insert an Excel defined table

_____Highlight unique values in a filtered Excel table

_____Merge tables based on a condition

2242. Create an Excel Table

_____Sort by multiple columns using an Excel Table

_____Lookup and return multiple sorted values based on corresponding values in another column - Excel Table

2243. Excel Table and slicers

_____Create an Excel Table

_____Highlight duplicates in a filtered Excel Table

2244. Populating the Excel table

2245. Create Excel Tables

_____Add a column to an Excel Table

2246. Why do I want to convert the data set to an Excel Table?

_____Locate lookup values in an Excel table [HYPERLINK]

_____Highlight lookups in relational tables

_____Working with three relational tables

_____Extract unique distinct values from a relational table

_____How to use an Excel Table name in Data Validation Lists and Conditional Formatting formulas

_____Lookups in relational tables

_____Search for values in a related table

_____Search for values in a related table - Excel 365

_____Sum values in a related table

_____Sum values in a related table - Excel 365

_____Search related table based on a date and date range

_____Use a calendar to filter an Excel defined Table

_____Populate drop down list with filtered Excel Table values

_____Count unique distinct values in a filtered Excel defined Table

_____Extract table headers based on a condition

_____Change PivotTable data source using a drop-down list

_____List unique distinct values in a filtered Excel defined Table - Excel 365

_____List unique distinct values in a filtered Excel defined Table - earlier Excel versions

_____Extract unique distinct values based on a filtered Excel defined Table

_____Two-way lookup in multiple cross reference tables simultaneously

_____Two-way lookup using multiple tables - Excel 365 LAMBDA function

_____VLOOKUP in a filtered Excel Table and return multiple values

_____Remove common rows between two Excel defined tables

_____Compare two tables using a condition

_____Running totals based on criteria - formula and Excel Table

_____Running totals based on criteria - Excel Table

_____How to filter an Excel Table

_____How to clear an Excel Table filter

_____Two index table

_____Compare tables: Filter records occurring only in one table

_____Compare tables: Highlight records not in both tables

_____Filter shared records from two tables

_____Match two criteria and return multiple records [Excel defined Table]

_____Lookup and return multiple values [Excel Defined Table]

_____Extract all rows from a range based on range critera [Excel defined Table]

_____Search for a text string in a data set and return multiple records [Excel defined Table]

2247. Convert dataset to an Excel defined Table

2248. Add formula to Excel defined Table

_____Filter Excel defined Table

_____How do I extract rows that contain a string in a data set or table?

_____How do I filter rows that contain a string using an Excel Table?

2249. Excel defined tables

_____Filter rows using an Excel table based on a date range

Team, tournament

2250. How to generate a round-robin tournament

2251. How to build a Team Generator – different number of people per team

2252. True round-robin tournament

_____Dynamic team generator

2253. Team Generator

Text

_____Workaround for the TEXTSPLIT function – LAMBDA function

2254. How to use the VALUETOTEXT function

2255. VALUETOTEXT function examples

2256. VALUETOTEXT function not working

2257. How to use the ARRAYTOTEXT function

2258. ARRAYTOTEXT function example - concise form

2259. ARRAYTOTEXT Function example - strict form

2260. ARRAYTOTEXT Function not working

_____ARRAYTOTEXT Function - compare related functions and techniques

_____CHOOSEROWS Function example - split text to array

_____How to use the TEXTSPLIT function

_____TEXTSPLIT Function example

_____TEXTSPLIT function - remove #N/A errors

_____TEXTSPLIT function - pad each value with a given string

2261. How to use the TEXTAFTER function

2262. TEXTAFTER Function example

_____TEXTAFTER Function - case sensitive example

_____TEXTAFTER Function alternative (all Excel versions)

_____TEXTAFTER Function alternative

_____TEXTAFTER Function alternative case sensitive

2263. How to use the TEXTBEFORE function

2264. TEXTBEFORE Function example

_____TEXTBEFORE Function - case sensitive example

_____TEXTBEFORE Function alternative (all Excel versions)

_____TEXTBEFORE Function alternative

_____TEXTBEFORE Function alternative case sensitive

_____How to shuffle characters in a text string randomly

_____How to create a random text string

_____Calculate the number of weeks and days between given dates - dynamic text values

_____Highlight text values

_____Extract the most frequent text value - MODE.SNGL function

_____How to create a frequency table based on text values

_____If cell contains any text

_____Count cells with text

_____Count cells with text excluding cells containing a space character

_____Count text values returned from an Excel function

_____Count text values excluding numbers stored as text

_____Convert a text date to an Excel date using a formula

_____Match a range value containing both text and numerical characters

_____Extract the most frequent text values

2265. How to use the FORMULATEXT function

2266. FORMULATEXT function example

2267. FORMULATEXT function not working

2268. How to use the ISNONTEXT function

2269. How to use the ISTEXT function

_____Count blanks in a text string

_____Max function for text

_____LARGE function - based on a textstring

_____How to show a new line in a cell (wrap text)

_____Identify numbers stored as text

_____Highlight numbers stored as text

2270. Example 1 - TEXT function

2271. Example 2 - TEXT function

2272. Excel 'text manipulation' functions

2273. Excel text functions

_____MIN function ignore text

_____Count cells containing text from list

_____SMALL function for text

_____SMALL function for text - Excel 365

_____How to average a column containing some text values

_____SUMPRODUCT if cell contains text

2274. Formula not working - Number stored as text

2275. Formula not working - formula cell formatted as text

_____If cell contains text from list

_____Display matches if cell contains text from list (Excel 2019)

_____Display matches if cell contains text from list (Earlier Excel versions)

_____INDEX MATCH - partial text multiple conditions Excel 365

_____Sum by text

_____If cell contains text

_____If cell contains partial text

_____If cell contains partial text - hardcoded asterisks

_____If cell contains text then return value

_____If cell contains text then add text in another cell

_____If cell contains text then sum

_____If cell contains text add 1

_____OR function contains text

2276. AND function with text

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

2277. Year as text

2278. How to use the TEXT function

2279. How to create your own custom formatting - TEXT function

2280. Formatting codes you can use in the TEXT function

_____How to use text in the TEXT function - @ at character

2281. Why isn't the TEXT function working?

2282. How to round numbers using the TEXT function

_____How to hide specific values - TEXT function

_____How to hide text values

_____How to sum a column with text (SUM function)?

_____VLOOKUP part of text

_____How to use the TEXTJOIN function

_____TEXTJOIN function - how to add row delimiting characters

_____Sort values by corresponding text arranged in a column

_____How to use the TEXTTOCOLUMNS method

_____Reverse text

2283. How to edit radio button text

_____How to generate random numbers and text

_____Create random text strings

_____Cell range contains numbers, text, and blanks?

_____Assign records unique random text strings

_____What happens if a text string is used in the logical expression?

_____IF function - How to check if a cell is a text value?

_____IF function - contains any text

_____COUNTIF Function - Count cells containing a text string - partial match (wildcard)

_____Substitute multiple text strings

_____Substitute multiple text strings - Excel 365 recursive LAMBDA function

_____Count specific multiple text strings in a given cell range

_____Count specific multiple text strings in a given cell range - case sensitive

_____Count specific multiple text strings in a given cell range - case insensitive

_____How to create random numbers, text strings, dates and time values

_____Random text strings

_____Filter records based on a date range and a text string

_____Text to columns: Split words in a cell

_____Highlight records containing text strings (AND Logic)

_____Searching for the first characters in a text string [Array Formula]

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition

_____Create a unique distinct sorted list containing both numbers and text removing blanks with a condition - Excel 365

2284. How to create a series of values based on text and numbers

_____Extract unique distinct text values containing string in a range

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - earlier Excel versions

_____Filtering unique distinct text values and sorting them based on the sum of adjacent values and criteria - Excel 365

_____Sort text values by length

_____Create unique distinct list sorted based on text length

_____Sum cells containing numbers and text based on a condition

_____Count text string in a range (case sensitive)

_____Search for a text string in a data set and return multiple records

_____Search for a text string in a data set and return multiple records [Array formula]

_____Search for a text string in a data set and return multiple records [Excel 365]

_____Search for a text string in a data set and return multiple records [Excel defined Table]

_____Count a specific text string in a cell

_____Count text string in a range (case sensitive)

_____Sort text cells alphabetically from two columns

_____Sort text from two columns combined (array formula)

_____Extract unique distinct values if adjacent cell is text

2285. How to rank text uniquely without duplicates

_____Rotate text to save space

2286. How to format numbers as text

Time

_____Count complete hours between two times

_____How to sum overlapping time

_____Sum overlapping time

_____Sum overlapping time based on a date range

_____Sum overlapping time - Excel 365

_____Verify your date and time settings

_____CONCAT function and date and time values

2287. How to use the TIMEVALUE function

_____How to round time to the nearest hour?

_____How to round time to the nearest quarter of an hour?

_____Split date from a date and time value

_____Split time from a date and time value

_____Extract the hour from a time value

_____Extract the minute from a time value

2288. How to use the TIME function

2289. What is time in Excel?

2290. TIME Function example

_____TIME function - how to add hours

_____TIME function - how to add minutes

_____TIME function - how to add seconds

_____Convert time to 24 hour clock

_____How to AVERAGE time

_____How to AVERAGE time hh mm ss

2291. Time formats

2292. Time sheet for work

2293. How I built this time tracker

2294. Calculate time between time zones

2295. How to calculate time zone differences

_____Find the time difference

_____How to sum time across days with a start and end time each day

_____How to calculate overlapping time ranges

2296. How many times is a value repeated?

2297. One time pad cipher

_____Prevent overlapping date and time ranges using data validation

_____Create monthly time sheet using a Pivot Table

_____How to create random numbers, text strings, dates and time values

_____Random time values

_____Watch schedule that populates vacation time

_____Count entries based on date and time

_____Highlight specific time ranges in a weekly schedule

_____Match a date when date ranges sometimes overlap and return multiple results

_____Count how many times a string exists in a cell range (case insensitive)

Unique

2298. How to use the UNIQUE function

2299. UNIQUE Function example

2300. Unique values

_____Extract unique values

_____Extract unique values sorted from A to Z

_____Extract unique values ignoring blanks

_____Extract unique values sorted from A to Z ignoring blanks

_____Unique rows

_____Extract unique rows

_____Extract unique rows ignoring blank rows

_____Extract unique rows sorted from A to Z ignoring blank rows

_____Unique columns

_____Highlight unique/duplicates [Conditional formatting]

_____Test if a data set has a unique mode or multiple modes?

_____How to extract a case sensitive unique list from a column

_____Extract a case sensitive unique list from a column

_____Extract a case sensitive unique list from a column - Excel 365

_____VLOOKUP unique

_____Rotating unique groups with no repeat

_____Compare two lists and filter unique values where the sum in one column doesn’t match the other column

_____Highlight unique values in a filtered Excel table

_____Assign records unique random text strings

_____Find smallest and largest unique number

_____Filter unique rows case sensitive - Excel 365 LAMBDA function

_____Filter unique strings from a cell range

_____Filter unique strings in a range - Excel 365

_____Filter unique values from a cell range

_____Filter unique values sorted from A to Z

_____Find min and max unique and duplicate numerical values

_____How to find the largest unique number

_____How to find the largest unique number - Excel 365

_____How to find the smallest unique number

_____How to find the smallest unique number - Excel 365

_____Filter unique values and sort based on adjacent date

_____How to create a list of random unique numbers

_____Sum number based on corresponding unique value

_____Count unique values (case sensitive)

_____How to rank uniquely based on a condition

_____How to rank text uniquely without duplicates

_____How to rank uniquely based on a condition

_____Sum unique numbers

_____Sum number based on corresponding unique value

_____Extract unique values from two columns

_____How to filter unique values from a list [Formula]

_____Highlight unique values [Conditional Formatting]

_____Sort unique values at the top

Vlookup

_____Partial match VLOOKUP - asterisk character (wildcard)

_____Column function and VLOOKUP

_____CHOOSE function with VLOOKUP

_____Use VLOOKUP and return multiple values sorted from A to Z

_____How to use the VLOOKUP function

_____VLOOKUP function formula

_____VLOOKUP - approximate match

_____Merge two data sets using the VLOOKUP function

_____VLOOKUP - how to use multiple tables

_____VLOOKUP - What if the lookup value is not in the leftmost column?

_____How to handle VLOOKUP errors

_____Using multiple criteria in VLOOKUP

_____VLOOKUP function - Partial match using wildcards

_____VLOOKUP function - Partial match - begins with

_____VLOOKUP function - Partial match - ends with

_____VLOOKUP function - Partial match - contains

_____VLOOKUP function - Partial match - question mark

_____VLOOKUP function - tilde character escapes wildcard characters

_____VLOOKUP - Duplicate repeated values

_____VLOOKUP and HLOOKUP together

_____VLOOKUP - can't find a value that is there

_____VLOOKUP alternatives

_____VLOOKUP just shows the formula

_____VLOOKUP another sheet

_____VLOOKUP keep formatting

_____VLOOKUP backward - lookup from bottom to top

_____VLOOKUP on two columns

_____VLOOKUP between dates

_____VLOOKUP returns #N/A

_____VLOOKUP yes if true

_____VLOOKUP part of text

_____VLOOKUP vs INDEX MATCH

_____VLOOKUP returns multiple columns

_____VLOOKUP zero if not found

_____VLOOKUP sum

_____VLOOKUP true false

_____VLOOKUP unique

_____Use VLOOKUP to calculate discounts, commissions, tariffs, charges, shipping costs, packaging expenses or bonuses

_____How to VLOOKUP using the INDIRECT function?

_____How to join data sets using the VLOOKUP function

_____Can you replace the VLOOKUP function with the INDEX function?

_____Where do I use the INDEX - MATCH functions instead of VLOOKUP?

_____VLOOKUP and return multiple values across columns

_____How to use VLOOKUP/XLOOKUP with multiple conditions

_____VLOOKUP function with two conditions applied to two columns (AND logic)?

_____VLOOKUP function with two conditions applied to two columns (OR logic)?

_____VLOOKUP function with many conditions applied to one column (OR logic)?

_____Can we use VLOOKUP with multiple lookup values?

_____VLOOKUP across multiple columns?

_____Can you concatenate VLOOKUP results?

_____How to use VLOOKUP with dates?

_____VLOOKUP - Select column using a drop-down list

_____VLOOKUP in a filtered Excel Table and return multiple values

_____Vlookup across multiple sheets

_____Vlookup a cell range and return multiple values

_____VLOOKUP – Return multiple unique distinct values

_____VLOOKUP - Return multiple unique distinct values

_____VLOOKUP - Return multiple unique distinct values (Excel 365)

_____Fuzzy VLOOKUP

_____Fuzzy VLOOKUP - Excel 365 LAMBDA function

_____Fuzzy VLOOKUP - array formula

_____Return multiple matches with wildcard vlookup

_____Vlookup with multiple matches returns a different value

_____If value in range then return value - VLOOKUP function

_____VLOOKUP/XLOOKUP of three columns to pull a single record

_____VLOOKUP of three columns to pull a single record

_____Vlookup with 2 or more lookup criteria and return multiple matches

_____Use VLOOKUP to search date in date ranges and return value on the same row

_____5 easy ways to VLOOKUP and return multiple values

_____VLOOKUP - Return multiple values [vertically]

_____VLOOKUP and return multiple values - case sensitive

_____VLOOKUP and return multiple values - if not equal to

_____VLOOKUP and return multiple values - if smaller than

_____VLOOKUP and return multiple values - if larger than

_____VLOOKUP and return multiple values - if contains

_____VLOOKUP and return multiple values - if not contain

_____VLOOKUP and return multiple values - that begins with

_____VLOOKUP and return multiple values - that ends with

_____How to count VLOOKUP results

_____VLOOKUP - Return multiple values [horizontally]

_____VLOOKUP - Extract multiple records based on a condition

_____Improve your VLOOKUP formula and return multiple values

_____Choose between two data sets to VLOOKUP

Week

_____How to get weekly historical stock prices

_____How to create a sequence of weeks?

_____Sort by week number

_____How to highlight dates based on day of week

_____How to highlight weekends [Conditional Formatting]

2301. How to use the WEEKNUM function

_____Highlight a date occurring last week

_____Highlight a date occurring this week

_____Highlight a date occurring next week

_____Highlight a row if the date is last week

_____Highlight a row if the date is in this week

_____Highlight a row if the date is in next week

_____Calculate the number of weeks between given dates

_____Calculate the number of weeks and days between given dates

_____Calculate the number of weeks and days between given dates - dynamic text values

_____How to round a date to the nearest given weekday?

_____How to round a date to the nearest upcoming weekday?

_____Create a list of weekdays only

_____Count weekdays in a month

_____Count specific WEEKDAYS between two dates

_____How to use the WEEKDAY function

_____WEEKDAY Function Video

_____WEEKDAY Function example

_____WEEKDAY Function not working

_____WEEKDAY function - show weekday name

_____WEEKDAYS between dates

_____How do I sum values between n-th weekday this month and n-th weekday next month?

2302. Year by week?

_____The year begins on what weekday?

_____Lookup week and match last value

_____How to sum values by week?

_____Highlight weekends

_____Calculate date given weekday and week number

_____Calculate date given weekday and week number (week starts on Sunday)

_____Calculate date given weekday and week number (week starts on Monday)

_____Count a specific weekday in a date range

_____Extract week ranges based on a given date range

_____Count weekday within date range except holidays

_____7 days (weekly) date ranges using a formula

_____Weekly appointment calendar

_____Setting up your work hours in a weekly schedule

_____Populate cells dynamically in a weekly schedule

_____Find empty hours in a weekly schedule

_____Highlight specific time ranges in a weekly schedule

_____Weekly schedule template

_____Highlight duplicates with same date, week or month

_____Filter duplicates within same date, week or month

_____Count unique distinct values within same week, month or year

_____How to calculate a date based on specific weekday in a month

Year

_____How to calculate the number of years between dates

2303. How to use the YEARFRAC function

_____Sum by month and year

2304. How to use the YEAR function

2305. YEAR function example

_____Calculate year from date?

_____How to extract the year from a text string

_____Extract year when the date is located at the end of the text string

_____Extract year when the date is located somewhere in the middle of the text string

_____Extract year when the date is located at the beginning of the text string

2306. YEAR function not working?

_____YEAR function returns #NAME! error

_____YEAR function returns #VALUE! error

_____YEAR function returns #NUM! error

_____How to calculate years between dates?

_____How to convert year to a date?

_____Year and month

2307. Year and quarter

_____Year as text

_____Year and month to date?

_____Year by week?

_____The year begins on what weekday?

_____Lookup year and match the last value

_____How to sum values by year?

_____Heat map yearly calendar

_____Highlight events in a yearly calendar

_____List all unique distinct rows in a given month and year

_____List all unique distinct rows in a given month and year (Excel 365)

_____List all rows in a given month and year

_____List all rows in a given month and year (Excel 365)

_____Count unique distinct values within same week, month or year

_____Remove duplicates within same month or year

_____Extract unique distinct year and months from dates

_____Extract unique distinct year and months from dates - Excel 365

_____Extract sorted unique distinct years and months based on a list of dates - Excel 365

_____Extract unique distinct year and months from dates - older Excel versions

_____Create a number sequence to count records by year and month (sorted list)

_____Create a number sequence to count records by year and month (unsorted list)

_____Create a number sequence to count dates based on year

_____Create a number sequence to count records by individual products and years

-

One Response to “How to create a stock chart”

Excel udf: Import historical stock prices from yahoo says:

August 6, 2017 at 9:56 am

[…] Learn how to create a stock chart in excel […]

How to comment

How to add a formula to your comment
<code>Insert your formula here.</code>

Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >

How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]

How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.

Contact Oscar

You can contact me through this contact form