Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Trying to extract data meeting 3 conditions 8
- Amitouj
May 14, 2017 at 2:17 AM
- Amitouj
May 15, 2017 at 12:39 AM
-
- Replies
- 8
- Views
- 1.2k
8
-
-
-
-
Hide duplicate running total values. 11
- Skylane60
May 12, 2017 at 11:16 PM
- Skylane60
May 13, 2017 at 10:00 PM
-
- Replies
- 11
- Views
- 3.5k
11
-
-
-
-
VLOOKUP LEFT from LEN COUNT IN SEPARATE TABLE LIST 1
- taylorpa5
May 12, 2017 at 6:12 PM
- taylorpa5
May 13, 2017 at 12:10 AM
-
- Replies
- 1
- Views
- 711
1
-
-
-
-
nested if statements #N/A 2
- irenesboy
May 11, 2017 at 4:16 PM
- irenesboy
May 11, 2017 at 5:17 PM
-
- Replies
- 2
- Views
- 604
2
-
-
-
-
Pulling date from different sheet and seeing if it equals or falls between est. dates 3
- LJones79
May 10, 2017 at 3:09 PM
- LJones79
May 10, 2017 at 4:50 PM
-
- Replies
- 3
- Views
- 745
3
-
-
-
-
Exact same formula different results. 28
- her.rockstar
May 9, 2017 at 7:31 PM
- her.rockstar
June 15, 2017 at 1:02 PM
-
- Replies
- 28
- Views
- 4.4k
28
-
-
-
-
MODE MATCH Formula (for most common occurance) not considering entire range 13
- wittonline
May 9, 2017 at 12:14 PM
- wittonline
May 26, 2017 at 8:20 PM
-
- Replies
- 13
- Views
- 2k
13
-
-
-
-
Nested AND and OR statements with different THEN outputs 1
- Mayh3m
May 8, 2017 at 7:34 PM
- Mayh3m
May 10, 2017 at 2:24 PM
-
- Replies
- 1
- Views
- 575
1
-
-
-
-
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
-
-
-
-
IF and VLOOKUP formulas together 2
- hems1011
May 8, 2017 at 8:15 AM
- hems1011
May 8, 2017 at 10:49 AM
-
- Replies
- 2
- Views
- 791
2
-
-
-
-
ISNA In VLOOKUP 1
- Prestige
May 5, 2017 at 4:10 PM
- Prestige
May 5, 2017 at 4:25 PM
-
- Replies
- 1
- Views
- 582
1
-
-
-
-
Convert time to a usable format in a formula 15
- jl2509
May 3, 2017 at 7:23 PM
- jl2509
May 5, 2017 at 4:22 PM
-
- Replies
- 15
- Views
- 2.3k
15
-
-
-
-
Finding certain data to evaluate 1
- sandramac
May 1, 2017 at 10:56 PM
- sandramac
May 2, 2017 at 12:40 PM
-
- Replies
- 1
- Views
- 523
1
-
-
-
-
Index/Countif based on multiple factors including range 2
- her.rockstar
May 1, 2017 at 1:04 PM
- her.rockstar
May 1, 2017 at 2:02 PM
-
- Replies
- 2
- Views
- 734
2
-
-
-
-
Extract chronological data 8
- ansridhar
April 29, 2017 at 12:54 PM
- ansridhar
May 2, 2017 at 6:20 AM
-
- Replies
- 8
- Views
- 1.7k
8
-
-
-
-
Lists box 1
- kennethbrandon
April 28, 2017 at 1:36 PM
- kennethbrandon
April 28, 2017 at 3:18 PM
-
- Replies
- 1
- Views
- 564
1
-
-
-
-
Concatenate range of column values in a row 4
- bob22
April 27, 2017 at 6:02 PM
- bob22
April 28, 2017 at 3:30 PM
-
- Replies
- 4
- Views
- 1.5k
4
-
-
-
-
Need formula for complex lookup 7
- jadahlke
April 26, 2017 at 9:34 PM
- jadahlke
April 28, 2017 at 8:42 PM
-
- Replies
- 7
- Views
- 1.5k
7
-
-
-
-
Trying to get AVE &SUM, considering code in the calcs; not dependent on specific cols 1
- wittonline
April 24, 2017 at 5:46 PM
- wittonline
April 25, 2017 at 2:08 AM
-
- Replies
- 1
- Views
- 656
1
-
-
-
-
Change values to the right of a decimal point 9
- jl2509
April 24, 2017 at 11:16 AM
- jl2509
April 28, 2017 at 11:08 AM
-
- Replies
- 9
- Views
- 1.5k
9
-