Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Formula to calculate duration difference between two dates ? 2
- Xani
September 21, 2017 at 1:52 PM
- Xani
September 21, 2017 at 3:01 PM
-
- Replies
- 2
- Views
- 864
2
-
-
-
-
Combine several cells into one 1
- Nat_Pan
September 21, 2017 at 8:40 AM
- Nat_Pan
September 21, 2017 at 9:03 PM
-
- Replies
- 1
- Views
- 380
1
-
-
-
-
Users able to select only today's date which then remains a static value 2
- tac_79
September 20, 2017 at 2:52 AM
- tac_79
September 20, 2017 at 4:19 AM
-
- Replies
- 2
- Views
- 582
2
-
-
-
-
SUMIFS and " > " 3
- CoachK
September 15, 2017 at 6:18 PM
- CoachK
September 20, 2017 at 4:28 PM
-
- Replies
- 3
- Views
- 670
3
-
-
-
-
Vlookup using wildcard for fetching the data 3
- hdevadiga
September 15, 2017 at 6:32 AM
- hdevadiga
September 20, 2017 at 2:06 PM
-
- Replies
- 3
- Views
- 1.2k
3
-
-
-
-
Create Table from multiple criteria using VLOOKUP, MATCH and INDEX 1
- Mnet
September 15, 2017 at 2:21 AM
- Mnet
September 15, 2017 at 3:39 AM
-
- Replies
- 1
- Views
- 569
1
-
-
-
-
How to Use a Cell Value as the Column Index in a VLOOKUP Formula? 3
- OldFella
September 12, 2017 at 8:44 AM
- OldFella
September 12, 2017 at 12:24 PM
-
- Replies
- 3
- Views
- 834
3
-
-
-
-
IFERROR, ROUND and SUM together 2
- DezB
September 11, 2017 at 11:49 AM
- DezB
September 11, 2017 at 12:52 PM
-
- Replies
- 2
- Views
- 6.9k
2
-
-
-
-
Concatenate in 4 digit 1
- zoullat
September 9, 2017 at 5:22 PM
- zoullat
September 9, 2017 at 9:33 PM
-
- Replies
- 1
- Views
- 545
1
-
-
-
-
Auto fill unknown values from available data: day, month and year. 5
- Quintus
September 8, 2017 at 6:21 PM
- Quintus
September 13, 2017 at 3:35 PM
-
- Replies
- 5
- Views
- 867
5
-
-
-
-
Conditional Formatting: Trouble adding a col qualifier value into an existing formula 13
- wittonline
September 7, 2017 at 7:46 PM
- wittonline
September 12, 2017 at 1:18 PM
-
- Replies
- 13
- Views
- 1.9k
13
-
-
-
-
Extracting Variable Dates with the same ID Number (but variable inputs) 6
- jwatson34
September 7, 2017 at 4:40 PM
- jwatson34
September 8, 2017 at 12:14 AM
-
- Replies
- 6
- Views
- 652
6
-
-
-
-
Extracting specific data from export file 1
- shani75
September 7, 2017 at 3:26 PM
- shani75
September 13, 2017 at 2:47 AM
-
- Replies
- 1
- Views
- 693
1
-
-
-
-
Calculation in blank space for dynamic range 1
- mylai
September 7, 2017 at 3:36 AM
- mylai
September 7, 2017 at 3:43 AM
-
- Replies
- 1
- Views
- 491
1
-
-
-
-
How to count number of unique combinations inside a table of data? 2
- bensmith5678
September 5, 2017 at 3:18 PM
- bensmith5678
September 19, 2017 at 12:09 AM
-
- Replies
- 2
- Views
- 908
2
-
-
-
-
Copy data from selected blocks of cells dependent of the month in a cell 12
- DezB
September 5, 2017 at 11:29 AM
- DezB
November 6, 2017 at 3:25 PM
-
- Replies
- 12
- Views
- 1.5k
12
-
-
-
-
Converting US to UK dates 1
- MysticGenius
September 4, 2017 at 7:03 AM
- MysticGenius
September 4, 2017 at 7:12 AM
-
- Replies
- 1
- Views
- 577
1
-
-
-
-
Count up number of times a name appears against position and Skill 6
- DezB
September 1, 2017 at 1:37 PM
- DezB
September 1, 2017 at 2:54 PM
-
- Replies
- 6
- Views
- 872
6
-
-
-
-
Th formula will not print like it use too 3
- dinoo
August 28, 2017 at 4:41 AM
- dinoo
August 29, 2017 at 4:05 AM
-
- Replies
- 3
- Views
- 721
3
-
-
-
-
Excel Solver: trying to construct a table for staffs allocation 2
- Keatnuxsuo
August 27, 2017 at 1:40 AM
- Keatnuxsuo
August 27, 2017 at 7:19 AM
-
- Replies
- 2
- Views
- 457
2
-