Excel Formulas
Questions related specifically to the use of Excel formulas.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.
-
-
-
- Excel match record from different position of row
- phooirv
-
- Replies
- 0
- Views
- 167
-
-
-
-
'tricking' excel to recognise a table header outside of the table 6
- paulbiddis
-
- Replies
- 6
- Views
- 1.3k
6
-
-
-
-
"tilde" in vlookup formula 13
- Anri
-
- Replies
- 13
- Views
- 3.9k
13
-
-
-
-
[Solved] Check Number for Assigning Time Excel 2007 4
- Bikke
-
- Replies
- 4
- Views
- 253
4
-
-
-
-
[Solved] Find a number in another Tab, Excel 2007 4
- Bikke
-
- Replies
- 4
- Views
- 231
4
-
-
-
-
[SOLVED] Help with Excel 2007 formula - Divide SUM of Cells 2
- N7AS
-
- Replies
- 2
- Views
- 548
2
-
-
-
-
[Solved] Merge data from three cells into one date cell, Excel 2007 4
- Bikke
-
- Replies
- 4
- Views
- 224
4
-
-
-
-
# of Orders that Shipped Out After the Order Date Excluding Duplicate Order #s 19
- AcctgController
-
- Replies
- 19
- Views
- 2k
19
-
-
-
-
2 groups conditional formating 4
- kennethbrandon
-
- Replies
- 4
- Views
- 1.1k
4
-
-
-
-
3 Random Values from a list skipping blanks 2
- wrigst
-
- Replies
- 2
- Views
- 2.1k
2
-
-
-
-
A math calc from different sources with neat blank cells
- legin52
-
- Replies
- 0
- Views
- 264
-
-
-
-
A quicker way than INDEX to count unique values in a list 3
- tac_79
-
- Replies
- 3
- Views
- 775
3
-
-
-
-
Accrual formula 9
- KEW115
-
- Replies
- 9
- Views
- 629
9
-
-
-
-
Adapting a linear annual calendar from data used to generate monthly annual calendars 3
- Trev81
-
- Replies
- 3
- Views
- 1.4k
3
-
-
-
-
Add 1 to cell when another cell equals $200 increments 2
- TheTallOne
-
- Replies
- 2
- Views
- 549
2
-
-
-
-
Add a calculated field to a pivot table 1
- cobber1418
-
- Replies
- 1
- Views
- 550
1
-
-
-
-
Add a trend arrow to dashboard 1
- shanethompson
-
- Replies
- 1
- Views
- 1.7k
1
-
-
-
-
Add an additional IF statement with a qualifying column value to existing formulas 3
- wittonline
-
- Replies
- 3
- Views
- 713
3
-
-
-
-
add another IF to an IF, AND, OR statement 1
- rnomis
-
- Replies
- 1
- Views
- 882
1
-
-
-
-
Add Customize Spacing in a cell text value 1
- luzmen
-
- Replies
- 1
- Views
- 464
1
-