Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
V and H Lookups On Dynamic Data 8
- abba92
July 28, 2017 at 6:54 PM
- abba92
November 26, 2017 at 2:55 PM
-
- Replies
- 8
- Views
- 1.3k
8
-
-
-
-
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
-
-
-
-
sum cells only if adjacent cell has value 1
- Fleur
July 27, 2017 at 1:18 PM
- Fleur
August 13, 2017 at 9:05 AM
-
- Replies
- 1
- Views
- 539
1
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
Excel - Sumifs/data collection date range query 4
- DaveSharpe79
July 25, 2017 at 4:16 PM
- DaveSharpe79
August 20, 2017 at 2:54 PM
-
- Replies
- 4
- Views
- 847
4
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
Edit formula if match return value, if does not match return blank instead of false 3
- score
July 21, 2017 at 1:23 PM
- score
July 21, 2017 at 2:36 PM
-
- Replies
- 3
- Views
- 713
3
-
-
-
-
Lookup rows and return STDEV.S of cells matching criteria in column headings 2
- RHUL
July 19, 2017 at 8:18 PM
- RHUL
July 20, 2017 at 1:36 PM
-
- Replies
- 2
- Views
- 588
2
-
-
-
-
Need help making a list in excel 1
- rm67177n
July 19, 2017 at 8:13 PM
- rm67177n
July 20, 2017 at 3:16 AM
-
- Replies
- 1
- Views
- 531
1
-