Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Nesting formulas 1
- kooala
January 14, 2022 at 12:51 PM
- kooala
January 15, 2022 at 7:14 AM
-
- Replies
- 1
- Views
- 368
1
-
-
-
-
Using Countif to calculate totals from another excel tab 1
- Xani
December 24, 2021 at 6:09 PM
- Xani
December 25, 2021 at 5:36 AM
-
- Replies
- 1
- Views
- 395
1
-
-
-
-
Conditional fomatting rule to only apply if two conditions are met. 1
- Shezmo1
October 27, 2021 at 6:03 PM
- Shezmo1
October 28, 2021 at 6:24 AM
-
- Replies
- 1
- Views
- 512
1
-
-
-
-
use xlookup function to retrieve value within another xlookup function 1
- paulbiddis
October 17, 2021 at 4:41 PM
- paulbiddis
October 18, 2021 at 6:36 AM
-
- Replies
- 1
- Views
- 463
1
-
-
-
-
MAX date with conditions 1
- ppcash
October 17, 2021 at 11:52 AM
- ppcash
November 4, 2021 at 1:47 PM
-
- Replies
- 1
- Views
- 603
1
-
-
-
-
Decimal in manual calculator but no decimal in Excel 1
- newgirl
October 12, 2021 at 6:26 AM
- newgirl
October 12, 2021 at 8:11 AM
-
- Replies
- 1
- Views
- 453
1
-
-
-
-
Vlook up an amount for an item and deduct it from that row - issue is that items repeat multiple times - need to take into account the amount already deducted from the same item in the above rows 1
- jpetraityte
October 7, 2021 at 11:49 PM
- jpetraityte
November 4, 2021 at 2:43 PM
-
- Replies
- 1
- Views
- 522
1
-
-
-
-
Excel formula or VBA code for extracting external file links 1
- dkool
October 6, 2021 at 5:35 AM
- dkool
October 6, 2021 at 6:08 AM
-
- Replies
- 1
- Views
- 380
1
-
-
-
-
Dynamic Formula To Lookup Most Recent Data On Or Before Given Data Based On Multiple Criteria 1
- EnginerdUNH
September 25, 2021 at 5:55 PM
- EnginerdUNH
September 25, 2021 at 7:16 PM
-
- Replies
- 1
- Views
- 563
1
-
-
-
-
Extract Year part from Date and convert to text 1
- tomchy
September 3, 2021 at 6:59 PM
- tomchy
September 3, 2021 at 11:28 PM
-
- Replies
- 1
- Views
- 440
1
-
-
-
-
Rank Issue using value from Pivot Table 1
- Box Jockey
August 20, 2021 at 9:27 PM
- Box Jockey
August 21, 2021 at 7:00 AM
-
- Replies
- 1
- Views
- 386
1
-
-
-
-
Form in Excel 1
- Ankit4680
August 15, 2021 at 9:53 AM
- Ankit4680
August 15, 2021 at 1:27 PM
-
- Replies
- 1
- Views
- 370
1
-
-
-
-
Returning Data if Two matches are made 1
- chelly
July 28, 2021 at 5:14 PM
- chelly
August 23, 2021 at 3:06 PM
-
- Replies
- 1
- Views
- 557
1
-
-
-
-
Mapping vintages to sales and different rates 1
- kooala
July 23, 2021 at 5:38 PM
- kooala
July 23, 2021 at 9:56 PM
-
- Replies
- 1
- Views
- 442
1
-
-
-
-
Populate cells with data related to a specific cell 1
- frank@njbs
July 14, 2021 at 2:00 PM
- frank@njbs
July 15, 2021 at 5:48 AM
-
- Replies
- 1
- Views
- 380
1
-
-
-
-
Formula to pull data with multiple horizontal and vertical criteria 1
- virginia989
July 9, 2021 at 10:58 PM
- virginia989
July 10, 2021 at 7:39 AM
-
- Replies
- 1
- Views
- 779
1
-
-
-
-
Rotating Schedule 1
- EXCELn00b18
July 7, 2021 at 3:36 PM
- EXCELn00b18
July 8, 2021 at 8:46 AM
-
- Replies
- 1
- Views
- 518
1
-
-
-
-
Pivot table - Shows 'Count of' instead of desired 'Sum of' 1
- dejayajay
July 6, 2021 at 2:04 AM
- dejayajay
July 6, 2021 at 8:06 AM
-
- Replies
- 1
- Views
- 1.1k
1
-
-
-
-
Overtime Claim Form 1
- kennethbrandon
July 3, 2021 at 9:39 AM
- kennethbrandon
July 3, 2021 at 3:24 PM
-
- Replies
- 1
- Views
- 377
1
-
-
-
-
Possible to reference cells in array formulas 1
- Archinon123
July 1, 2021 at 12:57 PM
- Archinon123
July 1, 2021 at 4:55 PM
-
- Replies
- 1
- Views
- 430
1
-