Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
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
- 876
6
-
-
-
-
Count actual word in cell 14
- jotoya
August 8, 2017 at 10:40 PM
- jotoya
August 29, 2017 at 7:35 PM
-
- Replies
- 14
- Views
- 2.1k
14
-
-
-
-
Return Total value from one sheet to another sheet depend on criteria ? 17
- Xani
August 24, 2017 at 3:57 PM
- Xani
August 29, 2017 at 4:39 PM
-
- Replies
- 17
- Views
- 2.2k
17
-
-
-
-
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
- 722
3
-
-
-
-
Chart Using Dynamic Named Range Not Displaying As I Want It 2
- OldFella
August 25, 2017 at 12:55 PM
- OldFella
August 27, 2017 at 12:39 PM
-
- Replies
- 2
- Views
- 731
2
-
-
-
-
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
- 463
2
-
-
-
-
Adding time to create cell with 2 hyphenated times in it 6
- legin52
August 26, 2017 at 8:55 PM
- legin52
August 27, 2017 at 3:52 AM
-
- Replies
- 6
- Views
- 1k
6
-
-
-
-
Sending Reminder of due date to Outlook calender via Excel 1
- HowardC
August 23, 2017 at 3:24 AM
- HowardC
August 23, 2017 at 5:14 PM
-
- Replies
- 1
- Views
- 916
1
-
-
-
-
Dependant Dropdown Validartion List 3
- mar050703
August 23, 2017 at 12:56 PM
- mar050703
August 23, 2017 at 1:57 PM
-
- Replies
- 3
- Views
- 601
3
-
-
-
-
Create formula that uses ISERROR to compare against multiple columns 4
- mithril28
August 16, 2017 at 5:08 PM
- mithril28
August 21, 2017 at 5:08 PM
-
- Replies
- 4
- Views
- 712
4
-
-
-
-
Need to calculate status of each owner? 16
- Xani
August 19, 2017 at 6:35 AM
- Xani
August 21, 2017 at 10:03 AM
-
- Replies
- 16
- Views
- 2.4k
16
-
-
-
-
Excel - Sumifs/data collection date range query 4
- DaveSharpe79
July 25, 2017 at 4:16 PM
- DaveSharpe79
August 20, 2017 at 2:54 PM
-
- Replies
- 4
- Views
- 853
4
-
-
-
-
Format Cell Color if Adjacent cell is blank 4
- scubastu01
August 17, 2017 at 6:11 PM
- scubastu01
August 17, 2017 at 7:18 PM
-
- Replies
- 4
- Views
- 5.1k
4
-
-
-
-
Conditional Formatting Based of Minimum Value 3
- Erehwon1
August 16, 2017 at 11:15 PM
- Erehwon1
August 17, 2017 at 4:58 PM
-
- Replies
- 3
- Views
- 605
3
-
-
-
-
Formula to extract data based on Month & Year 6
- HowardC
August 16, 2017 at 6:10 PM
- HowardC
August 17, 2017 at 2:30 PM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
Return value greater than from multiple rows 11
- score
August 16, 2017 at 3:43 AM
- score
August 16, 2017 at 2:44 PM
-
- Replies
- 11
- Views
- 1.5k
11
-
-
-
-
Sum of items based on multiple dynamic criteria 3
- rsumner
May 8, 2017 at 2:23 PM
- rsumner
August 15, 2017 at 10:14 AM
-
- Replies
- 3
- Views
- 739
3
-
-
-
-
sum cells only if adjacent cell has value 1
- Fleur
July 27, 2017 at 1:18 PM
- Fleur
August 13, 2017 at 9:05 AM
-
- Replies
- 1
- Views
- 539
1
-
-
-
-
DIV/0 Error when dividing 0.00%'s 13
- DezB
August 11, 2017 at 8:44 AM
- DezB
August 11, 2017 at 9:28 AM
-
- Replies
- 13
- Views
- 1.7k
13
-