Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Calculate Holidays with Networkdays 1
- Wasiq
January 10, 2017 at 7:07 AM
- Wasiq
January 11, 2017 at 7:54 AM
-
- Replies
- 1
- Views
- 973
1
-
-
-
-
Need To Alignment to The Right 1
- azumi
January 10, 2017 at 9:24 PM
- azumi
January 11, 2017 at 6:07 AM
-
- Replies
- 1
- Views
- 654
1
-
-
-
-
Finding specific columns and counting in them 2
- andrej
January 10, 2017 at 2:49 PM
- andrej
January 10, 2017 at 11:45 PM
-
- Replies
- 2
- Views
- 946
2
-
-
-
-
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
- 774
3
-
-
-
-
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
-
-
-
-
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
-
-
-
-
vLookup not working. 2
- Clayhead22
January 4, 2017 at 9:21 AM
- Clayhead22
January 6, 2017 at 12:10 AM
-
- Replies
- 2
- Views
- 638
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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
- 6k
10
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
Sum two columns with changing ranges 4
- juanluisl
November 28, 2016 at 3:27 PM
- juanluisl
December 12, 2016 at 11:37 PM
-
- Replies
- 4
- Views
- 1.7k
4
-
-
-
-
Excel says: You've entered too many arguments for this function: 4
- Trish123
November 23, 2016 at 3:15 PM
- Trish123
December 12, 2016 at 7:02 PM
-
- Replies
- 4
- Views
- 5.5k
4
-
-
-
-
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
-
-
-
-
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
-
-
-
-
Divide a number by a different percentage depending on value 4
- Gemma86
November 1, 2016 at 9:52 AM
- Gemma86
December 11, 2016 at 5:40 PM
-
- Replies
- 4
- Views
- 1.8k
4
-
-
-
-
Display selection based on a value in another cell 5
- xcel4me
December 2, 2016 at 12:33 PM
- xcel4me
December 11, 2016 at 5:14 PM
-
- Replies
- 5
- Views
- 1.8k
5
-