Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Balance carried forward 2
- Aussiebuilder
April 23, 2017 at 1:18 AM
- Aussiebuilder
April 23, 2017 at 8:06 AM
-
- Replies
- 2
- Views
- 1.9k
2
-
-
-
-
Index & match 2
- Aussiebuilder
April 23, 2017 at 1:11 AM
- Aussiebuilder
April 23, 2017 at 2:02 AM
-
- Replies
- 2
- Views
- 874
2
-
-
-
-
If & carried forward balances 1
- Aussiebuilder
April 21, 2017 at 4:48 PM
- Aussiebuilder
April 21, 2017 at 5:09 PM
-
- Replies
- 1
- Views
- 592
1
-
-
-
-
formula to remove all characters after a dash in a text string from the right 3
- world33
April 20, 2017 at 9:33 AM
- world33
April 20, 2017 at 11:44 AM
-
- Replies
- 3
- Views
- 1.2k
3
-
-
-
-
Populating multiple cells with drop down 1
- brando6003
April 19, 2017 at 9:12 PM
- brando6003
April 19, 2017 at 9:30 PM
-
- Replies
- 1
- Views
- 583
1
-
-
-
-
Parse cell for 1 of 3 values, return corresponding string value 5
- Dougmeister
April 19, 2017 at 2:33 PM
- Dougmeister
April 19, 2017 at 4:49 PM
-
- Replies
- 5
- Views
- 849
5
-
-
-
-
When G matches B, count the number of values in C (that do not match H) 5
- BJL
April 18, 2017 at 7:02 PM
- BJL
April 18, 2017 at 9:17 PM
-
- Replies
- 5
- Views
- 1.2k
5
-
-
-
-
Linking entered dates to column location 1
- JamesK1993
April 18, 2017 at 10:50 AM
- JamesK1993
April 18, 2017 at 10:52 AM
-
- Replies
- 1
- Views
- 548
1
-
-
-
-
Coveryting VB Macro form to Google sheet 1
- umakanth79in
April 18, 2017 at 6:45 AM
- umakanth79in
April 18, 2017 at 5:07 PM
-
- Replies
- 1
- Views
- 603
1
-
-
-
-
Trying to understand cell formulas when extra characters used, learn to SUM and AVE 9
- wittonline
April 17, 2017 at 3:17 AM
- wittonline
April 21, 2017 at 7:10 PM
-
- Replies
- 9
- Views
- 1.5k
9
-
-
-
-
Countif & min 7
- Aussiebuilder
April 16, 2017 at 2:50 AM
- Aussiebuilder
April 18, 2017 at 9:13 PM
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
Extract Records From Different Ranges and Filter Results 3
- scratchmaster
April 15, 2017 at 4:34 PM
- scratchmaster
April 24, 2017 at 7:39 AM
-
- Replies
- 3
- Views
- 1.1k
3
-
-
-
-
Preserving formula reference to pivot table 5
- Melody00
April 15, 2017 at 1:37 AM
- Melody00
April 18, 2017 at 9:06 AM
-
- Replies
- 5
- Views
- 1.1k
5
-
-
-
-
Match relevant data again 12
- bob22
April 14, 2017 at 11:21 AM
- bob22
April 14, 2017 at 6:05 PM
-
- Replies
- 12
- Views
- 1.9k
12
-
-
-
-
match relevant data fields to one id 7
- bob22
April 13, 2017 at 1:52 PM
- bob22
April 13, 2017 at 6:10 PM
-
- Replies
- 7
- Views
- 1.1k
7
-
-
-
-
copy 1 cell or another if blank 2
- DJ EXCEL
April 13, 2017 at 1:03 PM
- DJ EXCEL
April 13, 2017 at 1:15 PM
-
- Replies
- 2
- Views
- 685
2
-
-
-
-
Reduce list of dates by selecting earliest and latest date 3
- Exelbeginner
April 12, 2017 at 9:21 PM
- Exelbeginner
April 12, 2017 at 9:42 PM
-
- Replies
- 3
- Views
- 651
3
-
-
-
-
formula to compare a complete row to find "yes" "no" or blank 9
- 57Frog
April 12, 2017 at 3:21 PM
- 57Frog
April 12, 2017 at 5:53 PM
-
- Replies
- 9
- Views
- 1.5k
9
-
-
-
-
From four billing rates (depending on two separate types of inputs), formula to pick1 1
- behemoth87
April 12, 2017 at 12:29 PM
- behemoth87
April 12, 2017 at 12:33 PM
-
- Replies
- 1
- Views
- 397
1
-
-
-
-
Identify highest score category within group 3
- bunty_1244
April 11, 2017 at 6:56 PM
- bunty_1244
April 11, 2017 at 11:06 PM
-
- Replies
- 3
- Views
- 670
3
-