Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
vlookup to count based on criteria? 6
- Gemma86
February 16, 2017 at 10:44 PM
- Gemma86
April 12, 2017 at 12:55 PM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
AverageIf #DIV/0! error 10
- Murph0625
February 16, 2017 at 8:43 PM
- Murph0625
February 17, 2017 at 6:21 PM
-
- Replies
- 10
- Views
- 4k
10
-
-
-
-
Minimum Date if cell contains part of another cell value 10
- dRaz
February 16, 2017 at 2:29 PM
- dRaz
February 16, 2017 at 3:54 PM
-
- Replies
- 10
- Views
- 2k
10
-
-
-
-
Removing Characters out of a long string of characters via formula 5
- DaveSharpe79
February 15, 2017 at 9:00 AM
- DaveSharpe79
February 16, 2017 at 8:07 AM
-
- Replies
- 5
- Views
- 914
5
-
-
-
-
Copy formula from Row above if Cell Value changes. 5
- JohnDrew
February 14, 2017 at 10:59 PM
- JohnDrew
February 16, 2017 at 11:23 PM
-
- Replies
- 5
- Views
- 1.2k
5
-
-
-
-
Convert Time into Hours in Excel 1
- DaveSharpe79
February 14, 2017 at 6:16 PM
- DaveSharpe79
February 15, 2017 at 6:33 PM
-
- Replies
- 1
- Views
- 551
1
-
-
-
-
Return "YES" if cell H2 >12 and cell P2=Open - If no match return "NO" 5
- MantaLady
February 14, 2017 at 3:29 PM
- MantaLady
February 14, 2017 at 4:37 PM
-
- Replies
- 5
- Views
- 872
5
-
-
-
-
Formula that that leaves cell blank if 2 cells meet logical parameters 3
- skeeeter
February 12, 2017 at 8:02 AM
- skeeeter
February 12, 2017 at 10:04 AM
-
- Replies
- 3
- Views
- 708
3
-
-
-
-
Allocate a value over multiple years based on a specified date range 1
- jask
February 11, 2017 at 12:47 AM
- jask
February 11, 2017 at 1:09 AM
-
- Replies
- 1
- Views
- 845
1
-
-
-
-
Formula to count times a specific number will divide into another + rounding rules 1
- j6bennett1
February 10, 2017 at 8:29 PM
- j6bennett1
February 11, 2017 at 2:02 AM
-
- Replies
- 1
- Views
- 545
1
-
-
-
-
Formula to return which quartile a given number falls in 3
- CCA BSM
February 6, 2017 at 4:54 PM
- CCA BSM
February 6, 2017 at 11:10 PM
-
- Replies
- 3
- Views
- 8k
3
-
-
-
-
Map text to numeric rankings 2
- clariinc
February 6, 2017 at 4:13 PM
- clariinc
February 6, 2017 at 10:45 PM
-
- Replies
- 2
- Views
- 871
2
-
-
-
-
select by data validation list to highlight the cells 15
- sathishsusa
February 3, 2017 at 7:23 PM
- sathishsusa
February 8, 2017 at 12:21 PM
-
- Replies
- 15
- Views
- 2.5k
15
-
-
-
-
Time calculation inconsistent 1
- Gyster
February 3, 2017 at 2:49 PM
- Gyster
February 3, 2017 at 5:40 PM
-
- Replies
- 1
- Views
- 607
1
-
-
-
-
Power Forecast Formula Errors Out on Legitimate Value 3
- JamesRyann
February 3, 2017 at 12:02 AM
- JamesRyann
February 3, 2017 at 2:19 PM
-
- Replies
- 3
- Views
- 962
3
-
-
-
-
Find solution to #VALUE! error message in SUMPRODUCT 4
- bellevue
February 2, 2017 at 1:12 PM
- bellevue
February 2, 2017 at 1:58 PM
-
- Replies
- 4
- Views
- 909
4
-
-
-
-
Average & standard deviation of hh:mm:ss 1
- R. Saran
February 2, 2017 at 10:54 AM
- R. Saran
February 2, 2017 at 11:02 AM
-
- Replies
- 1
- Views
- 805
1
-
-
-
-
SUMIF using Variable Columns 4
- sajo
February 2, 2017 at 1:50 AM
- sajo
February 3, 2017 at 8:15 PM
-
- Replies
- 4
- Views
- 1.4k
4
-
-
-
-
Formula to look at dates and bring back value 1
- excellquestion
February 1, 2017 at 10:15 PM
- excellquestion
February 2, 2017 at 1:08 PM
-
- Replies
- 1
- Views
- 543
1
-
-
-
-
Return text from colomn if meets criteria in another colomn 1
- SBRIGHT
February 1, 2017 at 10:30 AM
- SBRIGHT
February 1, 2017 at 3:08 PM
-
- Replies
- 1
- Views
- 571
1
-