Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
- Excel match record from different position of row
- phooirv
February 13, 2019 at 5:53 AM
- phooirv
February 13, 2019 at 5:53 AM
-
- Replies
- 0
- Views
- 177
-
-
-
-
'tricking' excel to recognise a table header outside of the table 6
- paulbiddis
February 9, 2021 at 1:39 PM
- paulbiddis
February 10, 2021 at 9:38 AM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
"tilde" in vlookup formula 13
- Anri
March 22, 2017 at 5:42 AM
- Anri
March 22, 2017 at 2:04 PM
-
- Replies
- 13
- Views
- 4k
13
-
-
-
-
[Solved] Check Number for Assigning Time Excel 2007 4
- Bikke
June 2, 2023 at 9:06 PM
- Bikke
June 3, 2023 at 12:10 AM
-
- Replies
- 4
- Views
- 339
4
-
-
-
-
[Solved] Find a number in another Tab, Excel 2007 4
- Bikke
November 4, 2023 at 1:54 AM
- Bikke
November 4, 2023 at 7:55 PM
-
- Replies
- 4
- Views
- 406
4
-
-
-
-
[SOLVED] Help with Excel 2007 formula - Divide SUM of Cells 2
- N7AS
June 10, 2019 at 4:13 AM
- N7AS
June 10, 2019 at 6:02 PM
-
- Replies
- 2
- Views
- 571
2
-
-
-
-
[Solved] Merge data from three cells into one date cell, Excel 2007 4
- Bikke
October 15, 2023 at 10:16 PM
- Bikke
October 17, 2023 at 7:56 AM
-
- Replies
- 4
- Views
- 347
4
-
-
-
-
[Solved]Assign values to cells in a column reading a row designated by the dynamic offset held in another cell, in Excel avoiding VBA 3
- Checkovsky
December 11, 2023 at 8:59 AM
- Checkovsky
December 11, 2023 at 9:21 PM
-
- Replies
- 3
- Views
- 246
3
-
-
-
-
# of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s 19
- AcctgController
April 13, 2019 at 8:40 PM
- AcctgController
April 18, 2019 at 10:13 AM
-
- Replies
- 19
- Views
- 2.1k
19
-
-
-
-
=@SumByColor 1
- njcsba58
January 2, 2024 at 4:10 PM
- njcsba58
January 2, 2024 at 6:29 PM
-
- Replies
- 1
- Views
- 208
1
-
-
-
-
2 groups conditional formating 4
- kennethbrandon
May 15, 2017 at 1:55 PM
- kennethbrandon
May 16, 2017 at 2:11 PM
-
- Replies
- 4
- Views
- 1.1k
4
-
-
-
-
3 Random Values from a list skipping blanks 2
- wrigst
May 1, 2020 at 5:42 PM
- wrigst
May 22, 2020 at 2:33 PM
-
- Replies
- 2
- Views
- 2.1k
2
-
-
-
-
A math calc from different sources with neat blank cells
- legin52
June 27, 2018 at 1:17 PM
- legin52
June 27, 2018 at 1:17 PM
-
- Replies
- 0
- Views
- 275
-
-
-
-
A quicker way than INDEX to count unique values in a list 3
- tac_79
July 3, 2017 at 7:45 AM
- tac_79
July 3, 2017 at 8:39 AM
-
- Replies
- 3
- Views
- 800
3
-
-
-
-
Accrual formula 9
- KEW115
March 15, 2022 at 5:38 PM
- KEW115
March 18, 2022 at 4:23 PM
-
- Replies
- 9
- Views
- 681
9
-
-
-
-
Adapting a linear annual calendar from data used to generate monthly annual calendars 3
- Trev81
February 28, 2018 at 8:37 PM
- Trev81
March 5, 2018 at 11:59 PM
-
- Replies
- 3
- Views
- 1.4k
3
-
-
-
-
Add 1 to cell when another cell equals $200 increments 2
- TheTallOne
February 8, 2019 at 6:29 PM
- TheTallOne
February 9, 2019 at 3:28 PM
-
- Replies
- 2
- Views
- 570
2
-
-
-
-
Add a calculated field to a pivot table 1
- cobber1418
August 31, 2020 at 10:22 PM
- cobber1418
August 31, 2020 at 11:59 PM
-
- Replies
- 1
- Views
- 578
1
-
-
-
-
Add a trend arrow to dashboard 1
- shanethompson
January 31, 2017 at 8:50 AM
- shanethompson
February 6, 2017 at 3:05 AM
-
- Replies
- 1
- Views
- 1.7k
1
-
-
-
-
Add an additional IF statement with a qualifying column value to existing formulas 3
- wittonline
October 12, 2017 at 2:44 AM
- wittonline
October 12, 2017 at 5:56 PM
-
- Replies
- 3
- Views
- 751
3
-