Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
vlookup cell values only if date on adjacent column less than requested. INDEX/MATCH? 9
- Elusive
May 18, 2016 at 12:58 PM
- Elusive
May 19, 2016 at 3:05 PM
-
- Replies
- 9
- Views
- 2.4k
9
-
-
-
-
Formula to update a cell date systematically 2
- RNF
May 19, 2016 at 3:32 AM
- RNF
May 19, 2016 at 6:35 AM
-
- Replies
- 2
- Views
- 942
2
-
-
-
-
Merge / Combine cell range into single cell with line break 2
- Elusive
May 19, 2016 at 7:48 AM
- Elusive
June 6, 2016 at 11:11 AM
-
- Replies
- 2
- Views
- 1.6k
2
-
-
-
-
Calculate average for specified numbers from a column 4
- Mike91
May 19, 2016 at 8:02 AM
- Mike91
May 31, 2016 at 5:19 AM
-
- Replies
- 4
- Views
- 1.5k
4
-
-
-
-
Time Sheet Formula 5
- scarlett_b
May 19, 2016 at 5:10 PM
- scarlett_b
May 23, 2016 at 10:54 PM
-
- Replies
- 5
- Views
- 1.4k
5
-
-
-
-
Adding a range of cells based on addressing from a match 1
- oddcarout
May 19, 2016 at 5:55 PM
- oddcarout
May 19, 2016 at 8:25 PM
-
- Replies
- 1
- Views
- 707
1
-
-
-
-
merge cell invoice no auto increment frormulla is not working 1
- suresh45
May 21, 2016 at 1:57 PM
- suresh45
May 21, 2016 at 2:16 PM
-
- Replies
- 1
- Views
- 791
1
-
-
-
-
Count only first occurrence of criteria 3
- Gaius
May 22, 2016 at 2:48 PM
- Gaius
May 22, 2016 at 4:48 PM
-
- Replies
- 3
- Views
- 1.2k
3
-
-
-
-
Employee Breakdown By Half Hour On Rotating 6 Week Schedule (Includes Training Day) 1
- AFerg85
May 22, 2016 at 8:07 PM
- AFerg85
May 23, 2016 at 5:55 AM
-
- Replies
- 1
- Views
- 817
1
-
-
-
-
Incrementing multiple values in a cell 3
- Facter
May 24, 2016 at 4:55 AM
- Facter
May 25, 2016 at 3:35 PM
-
- Replies
- 3
- Views
- 1.1k
3
-
-
-
-
Combining <= and >= in same formula for time calculation 1
- AussieNat
May 26, 2016 at 2:26 AM
- AussieNat
May 26, 2016 at 1:22 PM
-
- Replies
- 1
- Views
- 823
1
-
-
-
-
Executing a formula based on an IF statement 1
- corcelle
May 26, 2016 at 2:24 PM
- corcelle
May 26, 2016 at 3:47 PM
-
- Replies
- 1
- Views
- 820
1
-
-
-
-
Align several columns into 1 columns 3
- Kel13
May 26, 2016 at 3:06 PM
- Kel13
June 1, 2016 at 3:14 AM
-
- Replies
- 3
- Views
- 1.3k
3
-
-
-
-
Join Excel tables 3
- Kel13
May 26, 2016 at 3:09 PM
- Kel13
June 1, 2016 at 4:14 PM
-
- Replies
- 3
- Views
- 1.2k
3
-
-
-
-
Count the values by ignoring cells which contain NA 2
- ravs_1006
May 26, 2016 at 5:59 PM
- ravs_1006
June 1, 2016 at 1:28 PM
-
- Replies
- 2
- Views
- 1.2k
2
-
-
-
-
add another IF to an IF, AND, OR statement 1
- rnomis
May 26, 2016 at 6:20 PM
- rnomis
May 26, 2016 at 10:29 PM
-
- Replies
- 1
- Views
- 918
1
-
-
-
-
compile error expected variable or procedure not module 2
- abdiwahab
May 27, 2016 at 6:18 AM
- abdiwahab
May 27, 2016 at 6:55 AM
-
- Replies
- 2
- Views
- 3.5k
2
-
-
-
-
Combine if statement with 3 different return 6
- JianHan
May 28, 2016 at 4:14 PM
- JianHan
June 1, 2016 at 1:34 AM
-
- Replies
- 6
- Views
- 1.6k
6
-
-
-
-
Counting numbers that appear in succession over different columns 2
- MrCantaloupe
May 31, 2016 at 7:29 PM
- MrCantaloupe
June 1, 2016 at 1:19 AM
-
- Replies
- 2
- Views
- 1.2k
2
-
-
-
-
Sheet reference based on another cell's value 2
- Infomage
June 2, 2016 at 9:56 AM
- Infomage
June 2, 2016 at 12:48 PM
-
- Replies
- 2
- Views
- 1.1k
2
-