Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Data validation change cell colour based on dates in a range work sheet included 17
- james40
April 23, 2018 at 11:45 AM
- james40
April 26, 2018 at 3:47 PM
-
- Replies
- 17
- Views
- 1.6k
17
-
-
-
-
Data Validation and Formula in the same cell 8
- jpetraityte
May 16, 2020 at 6:57 PM
- jpetraityte
June 7, 2020 at 2:28 PM
-
- Replies
- 8
- Views
- 2.5k
8
-
-
-
-
Data Validation 5
- ExcelNumpty
February 16, 2018 at 12:46 PM
- ExcelNumpty
February 16, 2018 at 4:30 PM
-
- Replies
- 5
- Views
- 744
5
-
-
-
-
Data sheet formula 2
- rachelwahid
March 25, 2018 at 12:35 PM
- rachelwahid
March 25, 2018 at 1:51 PM
-
- Replies
- 2
- Views
- 363
2
-
-
-
-
Data Query based on the drop down selection based on the dependent/independent drop down validation list 7
- kumarma
February 18, 2020 at 5:46 AM
- kumarma
March 30, 2020 at 8:46 AM
-
- Replies
- 7
- Views
- 1.8k
7
-
-
-
-
Data on main page 2
- Veeru106
August 29, 2018 at 6:54 AM
- Veeru106
August 29, 2018 at 11:24 AM
-
- Replies
- 2
- Views
- 641
2
-
-
-
-
Data lookup formula 1
- sv29
April 27, 2018 at 1:28 AM
- sv29
April 27, 2018 at 3:04 AM
-
- Replies
- 1
- Views
- 401
1
-
-
-
-
data array with date range and return text value in result 4
- jigarecity
January 27, 2021 at 1:33 PM
- jigarecity
January 28, 2021 at 9:21 AM
-
- Replies
- 4
- Views
- 646
4
-
-
-
-
Dashboard formula 13
- peter renton
February 21, 2018 at 11:09 AM
- peter renton
February 26, 2018 at 12:58 PM
-
- Replies
- 13
- Views
- 1.7k
13
-
-
-
-
cutting words with Len and Left and vlookup 4
- kooala
January 14, 2022 at 3:50 AM
- kooala
January 14, 2022 at 6:56 PM
-
- Replies
- 4
- Views
- 594
4
-
-
-
-
Custom Week Number - Last Saturday in December is Week 1 23
- m4Owen
November 27, 2019 at 2:12 PM
- m4Owen
February 23, 2020 at 7:32 AM
-
- Replies
- 23
- Views
- 6.3k
23
-
-
-
-
Custom searchable drop down list..... 8
- nmkhan3010
March 13, 2020 at 11:59 AM
- nmkhan3010
March 17, 2020 at 11:51 PM
-
- Replies
- 8
- Views
- 3.3k
8
-
-
-
-
Custom Number Format issue 7
- KSKwin
April 30, 2023 at 3:42 AM
- KSKwin
May 5, 2023 at 10:43 AM
-
- Replies
- 7
- Views
- 520
7
-
-
-
-
Cross reference with 2 Variables 1
- JDmacromanZ
January 6, 2017 at 12:25 AM
- JDmacromanZ
January 7, 2017 at 4:17 PM
-
- Replies
- 1
- Views
- 586
1
-
-
-
-
Creation of a "dynamic" formula 3
- GradB
September 15, 2023 at 2:38 AM
- GradB
September 15, 2023 at 11:03 AM
-
- Replies
- 3
- Views
- 278
3
-
-
-
-
Creating dynamic sheet reference while retaining "cell progression", for lack of the correct term ;-) 5
- DerNuB
February 24, 2021 at 5:13 AM
- DerNuB
February 24, 2021 at 6:32 AM
-
- Replies
- 5
- Views
- 639
5
-
-
-
-
Creating customer frequency report 6
- JamJ
August 15, 2022 at 10:44 AM
- JamJ
August 17, 2022 at 8:57 AM
-
- Replies
- 6
- Views
- 537
6
-
-
-
-
Creating a form to edit data in a pre existing table 4
- HAGG
April 23, 2020 at 2:21 PM
- HAGG
April 23, 2020 at 5:58 PM
-
- Replies
- 4
- Views
- 663
4
-
-
-
-
Create unique list without blank values 3
- Kineve
January 21, 2019 at 1:52 PM
- Kineve
January 28, 2019 at 3:24 PM
-
- Replies
- 3
- Views
- 493
3
-
-
-
-
Create Table from multiple criteria using VLOOKUP, MATCH and INDEX 1
- Mnet
September 15, 2017 at 2:21 AM
- Mnet
September 15, 2017 at 3:39 AM
-
- Replies
- 1
- Views
- 570
1
-