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
- 189
1
-
-
-
-
Count Based On Specific Criteria and Reset If Blank Encountered 5
- Artemis2018
-
- Replies
- 5
- Views
- 369
5
-
-
-
-
Calculate final sales price for a desired profit 4
- onexc
-
- Replies
- 4
- Views
- 554
4
-
-
-
-
Dynamic linking with multiple spreadsheets
- stilton
-
- Replies
- 0
- Views
- 135
-
-
-
-
VLookup to closed workbook 7
- alring
-
- Replies
- 7
- Views
- 300
7
-
-
-
-
Named ranges do not move when rows are added 6
- littlepete
-
- Replies
- 6
- Views
- 330
6
-
-
-
-
Can you use IF, COUNTIF & OR Together
- BlakeReuben
-
- Replies
- 0
- Views
- 181
-
-
-
-
cutting words with Len and Left and vlookup 4
- kooala
-
- Replies
- 4
- Views
- 297
4
-
-
-
-
Nesting formulas 1
- kooala
-
- Replies
- 1
- Views
- 217
1
-
-
-
-
Vlookup based on Range Name 9
- mitank
-
- Replies
- 9
- Views
- 353
9
-
-
-
-
function to find out format 3
- zohar
-
- Replies
- 3
- Views
- 285
3
-
-
-
-
Searchable Dropdown List is working as a normal dropdown list in protected worksheet 8
- MudasGrid
-
- Replies
- 8
- Views
- 2k
8
-
-
-
-
Sumifs For Resource Allocation - Resource Criteria is Seperated with ";" 5
- joePAIN
-
- Replies
- 5
- Views
- 596
5
-
-
-
-
Highlight lowest value if unique 6
- hamptongolfer11
-
- Replies
- 6
- Views
- 504
6
-
-
-
-
Formula for Conditional Formatting Based on the cell to the left
- JJeffery99
-
- Replies
- 0
- Views
- 219
-
-
-
-
Offset Cell("address") 2
- ShoYnn
-
- Replies
- 2
- Views
- 277
2
-
-
-
-
Auto Summing a Column with the hash key from Data in Rows 2
- ad91
-
- Replies
- 2
- Views
- 174
2
-
-
-
-
Conditional Formatting 1
- laraus2022
-
- Replies
- 1
- Views
- 556
1
-
-
-
-
Max value lookup 2
- Raha
-
- Replies
- 2
- Views
- 183
2
-