Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
CountIFS in same row problem 2
- jbanks
February 9, 2021 at 8:17 PM
- jbanks
February 10, 2021 at 9:13 AM
-
- Replies
- 2
- Views
- 749
2
-
-
-
-
'tricking' excel to recognise a table header outside of the table 6
- paulbiddis
February 9, 2021 at 1:39 PM
- paulbiddis
February 10, 2021 at 9:38 AM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
Cell Value Fill Based on Color 11
- dan_jordan84
February 10, 2021 at 2:00 PM
- dan_jordan84
February 10, 2021 at 5:19 PM
-
- Replies
- 11
- Views
- 1.6k
11
-
-
-
-
Extract text from a string of text based on the range defined 13
- brijeshkeni
February 12, 2021 at 6:43 AM
- brijeshkeni
February 12, 2021 at 7:17 PM
-
- Replies
- 13
- Views
- 1.4k
13
-
-
-
-
Match one cell value with another then extract row data 3
- Smudge.Smith
February 15, 2021 at 5:00 PM
- Smudge.Smith
February 15, 2021 at 7:06 PM
-
- Replies
- 3
- Views
- 604
3
-
-
-
-
Modifying a formula 2
- ajrilo1
February 16, 2021 at 4:22 PM
- ajrilo1
February 17, 2021 at 4:00 PM
-
- Replies
- 2
- Views
- 527
2
-
-
-
-
Array Formula Value Error 7
- Excel Noob
February 16, 2021 at 7:36 PM
- Excel Noob
February 17, 2021 at 5:49 PM
-
- Replies
- 7
- Views
- 1.5k
7
-
-
-
-
Multiple sets of data in single cell 5
- ajrilo1
February 17, 2021 at 2:22 PM
- ajrilo1
February 18, 2021 at 7:36 AM
-
- Replies
- 5
- Views
- 794
5
-
-
-
-
Calculate ONLY if before the 10th day of month 7
- Mirinjawbro
February 17, 2021 at 6:27 PM
- Mirinjawbro
February 18, 2021 at 8:03 AM
-
- Replies
- 7
- Views
- 919
7
-
-
-
-
Drop down boxes and Pivot Tables 1
- kramer100
February 18, 2021 at 9:38 PM
- kramer100
February 19, 2021 at 7:55 AM
-
- Replies
- 1
- Views
- 423
1
-
-
-
-
Match and extract values on different columns 3
- glenhmalefe2ds
February 21, 2021 at 10:51 AM
- glenhmalefe2ds
February 21, 2021 at 1:29 PM
-
- Replies
- 3
- Views
- 1.1k
3
-
-
-
-
Display data from one tab as merged cells on another tab of workbook 12
- ajrilo1
February 19, 2021 at 2:25 PM
- ajrilo1
February 23, 2021 at 2:59 PM
-
- Replies
- 12
- Views
- 2.1k
12
-
-
-
-
Creating dynamic sheet reference while retaining "cell progression", for lack of the correct term ;-) 5
- DerNuB
February 24, 2021 at 5:13 AM
- DerNuB
February 24, 2021 at 6:32 AM
-
- Replies
- 5
- Views
- 639
5
-
-
-
-
Formula not working when Worksheet is Protected 2
- mrbuttons
March 1, 2021 at 8:42 AM
- mrbuttons
March 1, 2021 at 9:22 AM
-
- Replies
- 2
- Views
- 1.1k
2
-
-
-
-
Conditional Format Exact Match 3
- Sper434
February 28, 2021 at 11:42 PM
- Sper434
March 2, 2021 at 2:06 PM
-
- Replies
- 3
- Views
- 563
3
-
-
-
-
write formula in work sheet 7
- supriyamk
March 2, 2021 at 3:48 AM
- supriyamk
March 3, 2021 at 10:45 AM
-
- Replies
- 7
- Views
- 1k
7
-
-
-
-
excel formula to lookup year and sum 3
- dkool
March 4, 2021 at 5:01 PM
- dkool
March 4, 2021 at 6:47 PM
-
- Replies
- 3
- Views
- 676
3
-
-
-
-
Returning the last row of text in a cell, minus the first few words 4
- chad71
March 5, 2021 at 2:51 AM
- chad71
March 5, 2021 at 3:05 PM
-
- Replies
- 4
- Views
- 729
4
-
-
-
-
Clear cell range without using VBA/Macro 4
- kmsafstrom
March 5, 2021 at 4:31 AM
- kmsafstrom
March 9, 2021 at 2:22 PM
-
- Replies
- 4
- Views
- 2.7k
4
-
-
-
-
Drop Down List based on last used row 3
- busybee_1_in
March 9, 2021 at 11:24 PM
- busybee_1_in
March 10, 2021 at 2:42 PM
-
- Replies
- 3
- Views
- 682
3
-