Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Count Based On Specific Criteria and Reset If Blank Encountered 5
- Artemis2018
December 29, 2021 at 12:40 AM
- Artemis2018
December 31, 2021 at 2:37 AM
-
- Replies
- 5
- Views
- 924
5
-
-
-
-
VLookup to closed workbook 7
- alring
January 6, 2022 at 7:30 AM
- alring
January 7, 2022 at 11:38 AM
-
- Replies
- 7
- Views
- 726
7
-
-
-
-
Dynamic linking with multiple spreadsheets
- stilton
January 6, 2022 at 2:20 PM
- stilton
January 6, 2022 at 2:20 PM
-
- Replies
- 0
- Views
- 260
-
-
-
-
Named ranges do not move when rows are added 6
- littlepete
January 7, 2022 at 8:00 PM
- littlepete
January 8, 2022 at 3:58 PM
-
- Replies
- 6
- Views
- 716
6
-
-
-
-
Can you use IF, COUNTIF & OR Together
- BlakeReuben
January 11, 2022 at 12:29 PM
- BlakeReuben
January 11, 2022 at 12:29 PM
-
- Replies
- 0
- Views
- 268
-
-
-
-
function to find out format 3
- zohar
January 13, 2022 at 2:48 AM
- zohar
January 20, 2022 at 3:24 AM
-
- Replies
- 3
- Views
- 597
3
-
-
-
-
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
-
-
-
-
Vlookup based on Range Name 9
- mitank
January 14, 2022 at 8:05 AM
- mitank
January 17, 2022 at 5:12 AM
-
- Replies
- 9
- Views
- 826
9
-
-
-
-
Nesting formulas 1
- kooala
January 14, 2022 at 12:51 PM
- kooala
January 15, 2022 at 7:14 AM
-
- Replies
- 1
- Views
- 368
1
-
-
-
-
Index help needed 2
- tr1face
January 25, 2022 at 4:54 PM
- tr1face
March 4, 2022 at 2:00 PM
-
- Replies
- 2
- Views
- 652
2
-
-
-
-
Sumifs For Resource Allocation - Resource Criteria is Seperated with ";" 5
- joePAIN
January 28, 2022 at 12:56 PM
- joePAIN
January 31, 2022 at 11:22 AM
-
- Replies
- 5
- Views
- 1.2k
5
-
-
-
-
Highlight lowest value if unique 6
- hamptongolfer11
February 5, 2022 at 1:28 PM
- hamptongolfer11
February 5, 2022 at 4:45 PM
-
- Replies
- 6
- Views
- 948
6
-
-
-
-
Formula for Conditional Formatting Based on the cell to the left 1
- JJeffery99
February 15, 2022 at 3:16 PM
- JJeffery99
September 7, 2022 at 5:09 AM
-
- Replies
- 1
- Views
- 572
1
-
-
-
-
Offset Cell("address") 2
- ShoYnn
February 15, 2022 at 9:14 PM
- ShoYnn
February 16, 2022 at 1:12 PM
-
- Replies
- 2
- Views
- 1.3k
2
-
-
-
-
My Formula is giving me a remainder when there shouldn't be one...How do I fix? 4
- Jeffrey Smith
February 16, 2022 at 2:48 PM
- Jeffrey Smith
March 17, 2022 at 6:05 PM
-
- Replies
- 4
- Views
- 641
4
-
-
-
-
Auto Summing a Column with the hash key from Data in Rows 2
- ad91
February 17, 2022 at 5:10 AM
- ad91
February 17, 2022 at 7:52 AM
-
- Replies
- 2
- Views
- 557
2
-
-
-
-
Conditional Formatting 1
- laraus2022
February 21, 2022 at 10:57 PM
- laraus2022
February 22, 2022 at 6:53 AM
-
- Replies
- 1
- Views
- 687
1
-
-
-
-
Max value lookup 3
- Raha
February 24, 2022 at 1:02 PM
- Raha
July 11, 2022 at 1:59 AM
-
- Replies
- 3
- Views
- 668
3
-
-
-
-
Match tabname and vlookup 5
- pjums
February 28, 2022 at 1:40 PM
- pjums
March 1, 2022 at 3:22 PM
-
- Replies
- 5
- Views
- 558
5
-