Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
New Column that removes blanks of previous column (FORMULA ONLY) 1
- barrylaurel
June 28, 2017 at 6:43 AM
- barrylaurel
June 28, 2017 at 8:53 AM
-
- Replies
- 1
- Views
- 393
1
-
-
-
-
Obtaining average scores and counting responses of filtered data 8
- barbaar
October 17, 2018 at 3:04 PM
- barbaar
October 24, 2018 at 11:16 AM
-
- Replies
- 8
- Views
- 913
8
-
-
-
-
Dates & Delay Highlighting
- Baig1984
December 13, 2017 at 8:02 PM
- Baig1984
December 13, 2017 at 8:02 PM
-
- Replies
- 0
- Views
- 191
-
-
-
-
Add leading 0 only after letters 3
- backgroundbook
February 18, 2020 at 3:27 PM
- backgroundbook
March 4, 2020 at 5:22 PM
-
- Replies
- 3
- Views
- 1k
3
-
-
-
-
Use of OFFSET function to define X-Axis 3
- babr1477
February 9, 2019 at 10:44 PM
- babr1477
February 11, 2019 at 11:24 AM
-
- Replies
- 3
- Views
- 456
3
-
-
-
-
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
-
-
-
-
Need to find the right certificate to print? 2
- B.W.B.
January 27, 2018 at 8:45 AM
- B.W.B.
January 30, 2018 at 8:42 AM
-
- Replies
- 2
- Views
- 629
2
-
-
-
-
Single Search formula for two or more conditions? 12
- B.W.B.
October 14, 2017 at 12:55 PM
- B.W.B.
October 16, 2017 at 7:01 AM
-
- Replies
- 12
- Views
- 1.7k
12
-
-
-
-
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
-
-
-
-
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
-
-
-
-
INDEX MATCH with multiple lookup_arrays/references 12
- B.W.B.
June 17, 2016 at 3:26 PM
- B.W.B.
September 3, 2016 at 8:30 AM
-
- Replies
- 12
- Views
- 2.8k
12
-
-
-
-
Need To Alignment to The Right 1
- azumi
January 10, 2017 at 9:24 PM
- azumi
January 11, 2017 at 6:07 AM
-
- Replies
- 1
- Views
- 651
1
-
-
-
-
SUMIF with dates 2
- aysam
June 10, 2017 at 12:56 PM
- aysam
June 10, 2017 at 3:19 PM
-
- Replies
- 2
- Views
- 706
2
-
-
-
-
Vlookup function copying from different workbook and different sheet names.
- Awesomun
February 27, 2018 at 1:41 PM
- Awesomun
February 27, 2018 at 1:41 PM
-
- Replies
- 0
- Views
- 210
-
-
-
-
Advanced lookup : Multiple criteria when looking up values in a table 2
- awaqar
August 8, 2018 at 7:09 PM
- awaqar
August 9, 2018 at 2:48 PM
-
- Replies
- 2
- Views
- 480
2
-
-
-
-
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
-
-
-
-
Find a sum based on a date range and an aditional value 3
- avb85
March 25, 2017 at 7:41 PM
- avb85
March 26, 2017 at 8:39 AM
-
- Replies
- 3
- Views
- 726
3
-
-
-
-
Nested IF Statement Alternative 8
- aussiformula
April 24, 2016 at 3:36 AM
- aussiformula
May 1, 2016 at 10:11 AM
-
- Replies
- 8
- Views
- 2.1k
8
-
-
-
-
Countif or Array Formula 3
- aussiformula
April 20, 2016 at 11:18 PM
- aussiformula
April 22, 2016 at 5:36 PM
-
- Replies
- 3
- Views
- 1.6k
3
-
-
-
-
If statement 2
- aussiformula
April 16, 2016 at 8:39 AM
- aussiformula
April 17, 2016 at 3:03 AM
-
- Replies
- 2
- Views
- 1.1k
2
-