Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Addition based on the column heading 3
- Snjpverma
January 7, 2017 at 9:25 AM
- Snjpverma
January 8, 2017 at 9:33 PM
-
- Replies
- 3
- Views
- 772
3
-
-
-
-
Delete Entry with 0 and entry beside it 5
- JDmacromanZ
January 6, 2017 at 9:36 PM
- JDmacromanZ
January 13, 2017 at 1:48 AM
-
- Replies
- 5
- Views
- 1.5k
5
-
-
-
-
Stop Vlookup returning 0 2
- Winwhite
January 6, 2017 at 2:59 PM
- Winwhite
January 6, 2017 at 5:03 PM
-
- Replies
- 2
- Views
- 1.3k
2
-
-
-
-
Cross reference with 2 Variables 1
- JDmacromanZ
January 6, 2017 at 12:25 AM
- JDmacromanZ
January 7, 2017 at 4:17 PM
-
- Replies
- 1
- Views
- 586
1
-
-
-
-
vLookup not working. 2
- Clayhead22
January 4, 2017 at 9:21 AM
- Clayhead22
January 6, 2017 at 12:10 AM
-
- Replies
- 2
- Views
- 632
2
-
-
-
-
Drag Down Formula, but only change worksheet number 1
- sarasalinas2011
December 30, 2016 at 9:21 PM
- sarasalinas2011
December 31, 2016 at 12:04 AM
-
- Replies
- 1
- Views
- 774
1
-
-
-
-
decimal value derived through formula acting as text, how to make it as value 5
- analystbank
December 21, 2016 at 8:59 AM
- analystbank
December 24, 2016 at 2:27 PM
-
- Replies
- 5
- Views
- 1.9k
5
-
-
-
-
Sum columns based on mutiple criteria 1
- shani75
December 20, 2016 at 1:19 PM
- shani75
December 20, 2016 at 1:22 PM
-
- Replies
- 1
- Views
- 727
1
-
-
-
-
Summing up until matching target figure 9
- nairrb
December 19, 2016 at 12:40 PM
- nairrb
December 26, 2016 at 8:19 AM
-
- Replies
- 9
- Views
- 1.8k
9
-
-
-
-
Unique rank with multiple criteria 1
- hydebedi
December 18, 2016 at 1:52 PM
- hydebedi
December 20, 2016 at 1:28 PM
-
- Replies
- 1
- Views
- 1.4k
1
-
-
-
-
Calculate overtime based on 8 hour day / 44 hour week 10
- Excel Noob
December 15, 2016 at 10:02 PM
- Excel Noob
December 22, 2016 at 1:50 PM
-
- Replies
- 10
- Views
- 5.9k
10
-
-
-
-
vlookup #n/a error when values exist 5
- ANku86
December 13, 2016 at 7:10 PM
- ANku86
December 13, 2016 at 10:12 PM
-
- Replies
- 5
- Views
- 9.4k
5
-
-
-
-
using 2 multi conditional if then statements based on value of another cell 11
- trader1588
December 11, 2016 at 4:03 PM
- trader1588
December 12, 2016 at 1:13 PM
-
- Replies
- 11
- Views
- 1.8k
11
-
-
-
-
Count - Attendance Formula 5
- ryaneschroeder
December 11, 2016 at 3:57 AM
- ryaneschroeder
December 11, 2016 at 3:05 PM
-
- Replies
- 5
- Views
- 1.9k
5
-
-
-
-
Sum non-consecutive/contiguous cells by Month and Year 5
- tac_79
December 8, 2016 at 11:18 PM
- tac_79
December 12, 2016 at 1:20 AM
-
- Replies
- 5
- Views
- 2.4k
5
-
-
-
-
Listing Unique Names 2
- cvgtang
December 8, 2016 at 4:12 PM
- cvgtang
December 11, 2016 at 3:31 PM
-
- Replies
- 2
- Views
- 1.3k
2
-
-
-
-
YTD Figures 3
- mar050703
December 6, 2016 at 6:43 AM
- mar050703
December 11, 2016 at 4:09 PM
-
- Replies
- 3
- Views
- 1.6k
3
-
-
-
-
Count Unique values with multiple criteria 4
- mdnuts
December 5, 2016 at 7:29 PM
- mdnuts
December 8, 2016 at 8:09 PM
-
- Replies
- 4
- Views
- 1.8k
4
-
-
-
-
Find product price from appropriate vendor from all vendors 2
- mljohn
December 2, 2016 at 5:32 PM
- mljohn
December 3, 2016 at 12:10 AM
-
- Replies
- 2
- Views
- 717
2
-
-
-
-
Feed dynamic optionbutton selection to specific cell 1
- Learner123
December 2, 2016 at 3:18 PM
- Learner123
December 2, 2016 at 9:16 PM
-
- Replies
- 1
- Views
- 749
1
-