Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Sla Hours Between Two Dates
- tr1face
October 15, 2021 at 6:48 PM
- tr1face
October 15, 2021 at 6:48 PM
-
- Replies
- 0
- Views
- 540
-
-
-
-
Sum specific rows in certain column of table 6
- EnginerdUNH
October 15, 2021 at 5:08 PM
- EnginerdUNH
October 18, 2021 at 6:35 AM
-
- Replies
- 6
- Views
- 1.3k
6
-
-
-
-
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
- 462
1
-
-
-
-
Referencing other worksheet’s data using a helper cell 5
- EnginerdUNH
October 21, 2021 at 3:25 PM
- EnginerdUNH
October 24, 2021 at 8:07 AM
-
- Replies
- 5
- Views
- 750
5
-
-
-
-
Data validation to enforce number format entry 2
- Caro5228
October 26, 2021 at 12:39 PM
- Caro5228
October 26, 2021 at 2:56 PM
-
- Replies
- 2
- Views
- 615
2
-
-
-
-
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
-
-
-
-
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
-
-
-
-
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
-
-
-
-
Reverse engineer output of SUMPRODUCT equation
- hyperdreamz
November 7, 2021 at 7:26 PM
- hyperdreamz
November 7, 2021 at 7:26 PM
-
- Replies
- 0
- Views
- 319
-
-
-
-
Excel inventory tracking and fair allocation
- adylim
November 7, 2021 at 10:20 PM
- adylim
November 7, 2021 at 10:20 PM
-
- Replies
- 0
- Views
- 290
-
-
-
-
syntax of excel formula withindirect 4
- arlener
November 8, 2021 at 11:05 PM
- arlener
November 9, 2021 at 4:51 PM
-
- Replies
- 4
- Views
- 572
4
-
-
-
-
Excell calculations 3
- JulianR
November 4, 2021 at 4:33 PM
- JulianR
November 10, 2021 at 6:54 AM
-
- Replies
- 3
- Views
- 827
3
-
-
-
-
Match date in cell to the same date in a range and return value from cell below 2
- DezB
November 10, 2021 at 4:22 PM
- DezB
November 11, 2021 at 8:14 AM
-
- Replies
- 2
- Views
- 473
2
-
-
-
-
sum the time value of match data 2
- mamun.ges
November 13, 2021 at 7:48 AM
- mamun.ges
November 13, 2021 at 10:14 AM
-
- Replies
- 2
- Views
- 750
2
-
-
-
-
Average working days based on 2 criteria 9
- Djack92
November 23, 2021 at 10:34 AM
- Djack92
November 24, 2021 at 8:50 AM
-
- Replies
- 9
- Views
- 1.3k
9
-
-
-
-
Conditional Formatting 3
- mitank
December 3, 2021 at 7:58 AM
- mitank
December 15, 2021 at 8:30 PM
-
- Replies
- 3
- Views
- 568
3
-
-
-
-
Calculate Total Times Ticket Open 4
- Xani
December 17, 2021 at 3:54 AM
- Xani
December 19, 2021 at 4:45 PM
-
- Replies
- 4
- Views
- 805
4
-
-
-
-
Offset incremental row increase away from anchor row 2
- dsohng
December 12, 2021 at 2:44 AM
- dsohng
December 21, 2021 at 5:32 PM
-
- Replies
- 2
- Views
- 554
2
-
-
-
-
Using COUNTIFS to try to count records between two dates 5
- cthompson73
December 21, 2021 at 5:41 PM
- cthompson73
December 22, 2021 at 4:09 PM
-
- Replies
- 5
- Views
- 618
5
-
-
-
-
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
-