Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Looking Up Closest Match Between Two Columns and Within That Row 1
- abba92
October 12, 2016 at 1:47 PM
- abba92
October 17, 2016 at 7:47 PM
-
- Replies
- 1
- Views
- 682
1
-
-
-
-
Lookup Multiple Criteria in a Table and Return Header 1
- abba92
October 12, 2016 at 1:39 PM
- abba92
October 12, 2016 at 1:46 PM
-
- Replies
- 1
- Views
- 862
1
-
-
-
-
IF forumla to check if a value falls between two numbers 1
- GG88
October 7, 2016 at 5:04 PM
- GG88
October 7, 2016 at 6:27 PM
-
- Replies
- 1
- Views
- 1.7k
1
-
-
-
-
displaying values from a number of worksheets 2
- alibaba
October 5, 2016 at 9:05 AM
- alibaba
October 6, 2016 at 4:40 AM
-
- Replies
- 2
- Views
- 943
2
-
-
-
-
FORECAST, in single cell, from 4 sheets? 10
- B.W.B.
September 29, 2016 at 3:27 PM
- B.W.B.
October 9, 2016 at 4:43 PM
-
- Replies
- 10
- Views
- 2.2k
10
-
-
-
-
Displaying value according to selected data 1
- alibaba
September 29, 2016 at 8:26 AM
- alibaba
September 29, 2016 at 9:48 AM
-
- Replies
- 1
- Views
- 643
1
-
-
-
-
Lookup Values in any column 8
- excelnotit
September 28, 2016 at 4:11 AM
- excelnotit
November 5, 2016 at 5:22 PM
-
- Replies
- 8
- Views
- 2k
8
-
-
-
-
Date string conversion 6
- waldis
September 25, 2016 at 12:30 AM
- waldis
September 25, 2016 at 5:38 AM
-
- Replies
- 6
- Views
- 1.2k
6
-
-
-
-
Help Needed with If Statement, 5
- Frederus
September 23, 2016 at 10:11 AM
- Frederus
September 23, 2016 at 12:27 PM
-
- Replies
- 5
- Views
- 1.2k
5
-
-
-
-
pick items from a list and total them 2
- rnomis
September 20, 2016 at 12:20 PM
- rnomis
September 20, 2016 at 1:48 PM
-
- Replies
- 2
- Views
- 765
2
-
-
-
-
Nested array formula for a SUMPRODUCT operation 3
- Zapillo
September 18, 2016 at 12:31 AM
- Zapillo
September 20, 2016 at 1:04 PM
-
- Replies
- 3
- Views
- 1.1k
3
-
-
-
-
Position code to be extract based on multiple criteria 3
- ajaypal.sp
September 17, 2016 at 8:58 PM
- ajaypal.sp
September 18, 2016 at 7:37 AM
-
- Replies
- 3
- Views
- 1.1k
3
-
-
-
-
Multiple Functions for One Cell? 1
- 5percenter
September 15, 2016 at 10:27 PM
- 5percenter
September 16, 2016 at 5:27 AM
-
- Replies
- 1
- Views
- 702
1
-
-
-
-
find row number of all cells that contain substring 2
- flashkid10
September 15, 2016 at 5:43 PM
- flashkid10
September 15, 2016 at 11:24 PM
-
- Replies
- 2
- Views
- 863
2
-
-
-
-
Return the last number in a range that is not in a coloured cell 3
- vanhunk
September 15, 2016 at 10:00 AM
- vanhunk
September 28, 2016 at 2:05 PM
-
- Replies
- 3
- Views
- 985
3
-
-
-
-
Sumif with Offset 2
- jvalente
September 14, 2016 at 2:09 AM
- jvalente
September 14, 2016 at 10:45 PM
-
- Replies
- 2
- Views
- 2.4k
2
-
-
-
-
MATCHing a date within a range of dates 3
- Andante
September 12, 2016 at 1:55 AM
- Andante
September 13, 2016 at 7:17 PM
-
- Replies
- 3
- Views
- 890
3
-
-
-
-
Counting Unique Rows (FREQUENCY) 6
- AFord66
September 9, 2016 at 9:05 PM
- AFord66
September 13, 2016 at 4:46 AM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
Pulling list from 3 source lists 1
- dech
September 9, 2016 at 3:17 PM
- dech
September 9, 2016 at 4:19 PM
-
- Replies
- 1
- Views
- 563
1
-
-
-
-
Find Max number value from text-number cell? 20
- B.W.B.
September 8, 2016 at 1:50 PM
- B.W.B.
September 26, 2016 at 8:39 PM
-
- Replies
- 20
- Views
- 4.5k
20
-