Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Dynamically create range 3 years from TODAY for formula 9
- mljohn
August 7, 2017 at 4:24 PM
- mljohn
August 9, 2017 at 1:10 AM
-
- Replies
- 9
- Views
- 1.5k
9
-
-
-
-
Date conflict between two persons ? 1
- Xani
August 7, 2017 at 7:04 PM
- Xani
August 7, 2017 at 8:29 PM
-
- Replies
- 1
- Views
- 655
1
-
-
-
-
Sum a value if its Date is within 90 days of each Month shown in second table 6
- burdenpi
August 7, 2017 at 4:10 AM
- burdenpi
August 7, 2017 at 8:05 PM
-
- Replies
- 6
- Views
- 859
6
-
-
-
-
Dynamic VLOOKUP to return variable number of columns 3
- deutz
August 7, 2017 at 4:36 AM
- deutz
August 7, 2017 at 8:38 AM
-
- Replies
- 3
- Views
- 852
3
-
-
-
-
Need help with Vlookup not working 4
- vba_monkey
August 3, 2017 at 2:00 PM
- vba_monkey
August 3, 2017 at 2:15 PM
-
- Replies
- 4
- Views
- 1.3k
4
-
-
-
-
Totals changing despite sumif 3
- thefosh1984
August 2, 2017 at 2:14 PM
- thefosh1984
August 2, 2017 at 2:40 PM
-
- Replies
- 3
- Views
- 660
3
-
-
-
-
If,and statement to retrieve cells values containing text and numeric 7
- score
August 1, 2017 at 6:56 AM
- score
August 2, 2017 at 12:52 PM
-
- Replies
- 7
- Views
- 1.2k
7
-
-
-
-
i want a formula to look for the latest quantity remaining for shoes 2
- timzy
August 2, 2017 at 9:16 AM
- timzy
August 2, 2017 at 11:38 AM
-
- Replies
- 2
- Views
- 566
2
-
-
-
-
How to count December month in between two date. 3
- mamun.ges
August 1, 2017 at 2:40 AM
- mamun.ges
August 1, 2017 at 11:05 AM
-
- Replies
- 3
- Views
- 755
3
-
-
-
-
Dynamic Named Ranges - working on rows rather than columns 3
- samtp
July 27, 2017 at 10:10 AM
- samtp
July 27, 2017 at 8:33 PM
-
- Replies
- 3
- Views
- 569
3
-
-
-
-
Dragging formulas and skipping cells 3
- SSR1
July 27, 2017 at 4:32 PM
- SSR1
July 27, 2017 at 5:15 PM
-
- Replies
- 3
- Views
- 1k
3
-
-
-
-
Calculate time if greater than specific time in excel? 16
- Xani
July 26, 2017 at 10:30 AM
- Xani
July 27, 2017 at 8:40 AM
-
- Replies
- 16
- Views
- 2.5k
16
-
-
-
-
last 5 records 5
- avb85
July 26, 2017 at 3:08 AM
- avb85
July 27, 2017 at 1:57 AM
-
- Replies
- 5
- Views
- 1k
5
-
-
-
-
Comparing to files want to find and identify exceptions 7
- Jon_P
July 25, 2017 at 3:55 PM
- Jon_P
July 26, 2017 at 4:47 PM
-
- Replies
- 7
- Views
- 957
7
-
-
-
-
Auto populating drop down lists/cells based on conditions 24
- Boycie92
July 25, 2017 at 12:47 PM
- Boycie92
July 26, 2017 at 2:16 PM
-
- Replies
- 24
- Views
- 3.1k
24
-
-
-
-
COUNTIFS with dynamic named ranges 14
- Baber62
July 12, 2017 at 2:42 PM
- Baber62
July 26, 2017 at 8:46 AM
-
- Replies
- 14
- Views
- 3.4k
14
-
-
-
-
Is it possible to have cells turn yellow when being used after 6pm? 6
- TheRedBeard86
July 21, 2017 at 8:24 PM
- TheRedBeard86
July 25, 2017 at 10:18 PM
-
- Replies
- 6
- Views
- 865
6
-
-
-
-
identify exceptions when comparing two files 1
- Jon_P
July 25, 2017 at 4:47 PM
- Jon_P
July 25, 2017 at 5:05 PM
-
- Replies
- 1
- Views
- 473
1
-
-
-
-
Dynamic Range - List Ignoring BLANKS in Formulas 2
- patrick.oneal
July 24, 2017 at 10:15 AM
- patrick.oneal
July 24, 2017 at 10:56 AM
-
- Replies
- 2
- Views
- 527
2
-
-
-
-
concatenateif formula not working ? 5
- jacjas
July 21, 2017 at 3:34 PM
- jacjas
July 24, 2017 at 9:18 AM
-
- Replies
- 5
- Views
- 3.8k
5
-