Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Using Countif to calculate totals from another excel tab 1
- Xani
-
- Replies
- 1
- Views
- 192
1
-
-
-
-
Count Based On Specific Criteria and Reset If Blank Encountered 5
- Artemis2018
-
- Replies
- 5
- Views
- 378
5
-
-
-
-
Calculate final sales price for a desired profit 4
- onexc
-
- Replies
- 4
- Views
- 563
4
-
-
-
-
Dynamic linking with multiple spreadsheets
- stilton
-
- Replies
- 0
- Views
- 138
-
-
-
-
VLookup to closed workbook 7
- alring
-
- Replies
- 7
- Views
- 312
7
-
-
-
-
Named ranges do not move when rows are added 6
- littlepete
-
- Replies
- 6
- Views
- 342
6
-
-
-
-
Can you use IF, COUNTIF & OR Together
- BlakeReuben
-
- Replies
- 0
- Views
- 184
-
-
-
-
cutting words with Len and Left and vlookup 4
- kooala
-
- Replies
- 4
- Views
- 306
4
-
-
-
-
Nesting formulas 1
- kooala
-
- Replies
- 1
- Views
- 219
1
-
-
-
-
Vlookup based on Range Name 9
- mitank
-
- Replies
- 9
- Views
- 359
9
-
-
-
-
function to find out format 3
- zohar
-
- Replies
- 3
- Views
- 291
3
-
-
-
-
Searchable Dropdown List is working as a normal dropdown list in protected worksheet 8
- MudasGrid
-
- Replies
- 8
- Views
- 2.1k
8
-
-
-
-
Sumifs For Resource Allocation - Resource Criteria is Seperated with ";" 5
- joePAIN
-
- Replies
- 5
- Views
- 617
5
-
-
-
-
Highlight lowest value if unique 6
- hamptongolfer11
-
- Replies
- 6
- Views
- 514
6
-
-
-
-
Formula for Conditional Formatting Based on the cell to the left
- JJeffery99
-
- Replies
- 0
- Views
- 226
-
-
-
-
Offset Cell("address") 2
- ShoYnn
-
- Replies
- 2
- Views
- 311
2
-
-
-
-
Auto Summing a Column with the hash key from Data in Rows 2
- ad91
-
- Replies
- 2
- Views
- 185
2
-
-
-
-
Conditional Formatting 1
- laraus2022
-
- Replies
- 1
- Views
- 559
1
-
-
-
-
Max value lookup 2
- Raha
-
- Replies
- 2
- Views
- 186
2
-