Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
V and H Lookups On Dynamic Data 8
- abba92
July 28, 2017 at 6:54 PM
- abba92
November 26, 2017 at 2:55 PM
-
- Replies
- 8
- Views
- 1.3k
8
-
-
-
-
Using wildcard in conditional formula not working 3
- Billyrj
September 20, 2020 at 4:10 AM
- Billyrj
September 20, 2020 at 1:08 PM
-
- Replies
- 3
- Views
- 1k
3
-
-
-
-
Using TODAY function in a VLOOKUP formula 3
- Shezmo1
September 18, 2019 at 3:39 PM
- Shezmo1
September 19, 2019 at 10:51 AM
-
- Replies
- 3
- Views
- 581
3
-
-
-
-
Using sumproduct to sum values associated with years 8
- riskier4ra
December 30, 2017 at 10:21 PM
- riskier4ra
January 2, 2018 at 10:43 AM
-
- Replies
- 8
- Views
- 1.7k
8
-
-
-
-
Using sumif on different columns without getting a double/triple sum up 3
- thenoobishamateur
July 30, 2020 at 12:58 PM
- thenoobishamateur
July 31, 2020 at 8:01 AM
-
- Replies
- 3
- Views
- 899
3
-
-
-
-
Using SUBTOTAL formula within an IF formula 2
- davec0864
June 8, 2022 at 5:36 PM
- davec0864
June 13, 2022 at 2:44 PM
-
- Replies
- 2
- Views
- 1.5k
2
-
-
-
-
Using of VLOOKUP and ISNUMBER 8
- onexc
June 24, 2017 at 11:14 PM
- onexc
June 25, 2017 at 10:34 PM
-
- Replies
- 8
- Views
- 12k
8
-
-
-
-
using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2
- alz1
September 24, 2020 at 12:17 AM
- alz1
September 24, 2020 at 1:10 PM
-
- Replies
- 2
- Views
- 546
2
-
-
-
-
Using INDIRECT in the Formula That Defines a Graph's Data Range 10
- OldFella
June 20, 2017 at 1:38 PM
- OldFella
June 20, 2017 at 4:11 PM
-
- Replies
- 10
- Views
- 7.9k
10
-
-
-
-
Using index and match in the right way 2
- MihaiBanciu
May 22, 2019 at 8:15 PM
- MihaiBanciu
May 25, 2019 at 12:09 PM
-
- Replies
- 2
- Views
- 565
2
-
-
-
-
Using IF, AND, OR 3
- npecson@schosp
March 20, 2016 at 5:21 PM
- npecson@schosp
March 22, 2016 at 3:16 PM
-
- Replies
- 3
- Views
- 1.5k
3
-
-
-
-
Using dropdowns to copy cells from one worksheet to corresponding cells of another worksheet and add new rows if needed. 4
- CNeedsHelp
March 3, 2021 at 11:45 PM
- CNeedsHelp
March 13, 2021 at 7:43 AM
-
- Replies
- 4
- Views
- 1k
4
-
-
-
-
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
-
-
-
-
Using Cell Content As Input to a Structured Reference 2
- thefatstig
August 20, 2019 at 2:06 PM
- thefatstig
August 21, 2019 at 8:41 AM
-
- Replies
- 2
- Views
- 537
2
-
-
-
-
Using Address() in a logical test 3
- OceanRoaming
March 31, 2020 at 8:59 PM
- OceanRoaming
April 2, 2020 at 12:05 AM
-
- Replies
- 3
- Views
- 1.2k
3
-
-
-
-
Using a value from a cell inside a formula 8
- yogeshtalks
June 24, 2016 at 11:12 AM
- yogeshtalks
June 27, 2016 at 12:42 PM
-
- Replies
- 8
- Views
- 2.4k
8
-
-
-
-
using a formula to find number of days prior to a lost time occuring 8
- Ryan017
November 9, 2017 at 7:35 PM
- Ryan017
November 10, 2017 at 6:37 PM
-
- Replies
- 8
- Views
- 925
8
-
-
-
-
using 2 multi conditional if then statements based on value of another cell 11
- trader1588
December 11, 2016 at 4:03 PM
- trader1588
December 12, 2016 at 1:13 PM
-
- Replies
- 11
- Views
- 1.8k
11
-
-
-
-
Users able to select only today's date which then remains a static value 2
- tac_79
September 20, 2017 at 2:52 AM
- tac_79
September 20, 2017 at 4:19 AM
-
- Replies
- 2
- Views
- 587
2
-