Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
AND statement using multiple VLOOKUP criteria 3
- stilton
July 13, 2022 at 5:21 AM
- stilton
July 14, 2022 at 7:32 AM
-
- Replies
- 3
- Views
- 560
3
-
-
-
-
Formula to calculate COGS value using different prices based on qty available in different locations 1
- jpetraityte
July 18, 2022 at 2:35 PM
- jpetraityte
July 19, 2022 at 1:30 PM
-
- Replies
- 1
- Views
- 1.1k
1
-
-
-
-
Gathering name of products which have a same discount percentage 10
- Q2Be
July 26, 2022 at 7:08 PM
- Q2Be
August 16, 2022 at 11:29 PM
-
- Replies
- 10
- Views
- 1.3k
10
-
-
-
-
Color code bar chart data bars based on a y- axis criteria dynamically 1
- CapG
July 29, 2022 at 4:48 PM
- CapG
August 1, 2022 at 3:24 PM
-
- Replies
- 1
- Views
- 841
1
-
-
-
-
Format a cell based on information in another worksheet
- DSessions
July 29, 2022 at 9:44 PM
- DSessions
July 29, 2022 at 9:44 PM
-
- Replies
- 0
- Views
- 340
-
-
-
-
color rows with almost same amount which appear more than twice with CF 6
- RAJESH SHAH
August 4, 2022 at 5:16 AM
- RAJESH SHAH
August 10, 2022 at 7:40 PM
-
- Replies
- 6
- Views
- 1.3k
6
-
-
-
-
Collate data from last x days based on todays date 7
- DezB
August 4, 2022 at 1:55 PM
- DezB
August 8, 2022 at 1:18 PM
-
- Replies
- 7
- Views
- 714
7
-
-
-
-
IF Functions and tolerances. 3
- Shezmo1
August 6, 2022 at 11:05 AM
- Shezmo1
August 9, 2022 at 11:57 PM
-
- Replies
- 3
- Views
- 723
3
-
-
-
-
starting a formula from the next cell on from the previous formula 1
- DezB
August 10, 2022 at 11:56 AM
- DezB
October 12, 2022 at 5:31 PM
-
- Replies
- 1
- Views
- 479
1
-
-
-
-
Check Row for data in column and return value and heading for each column containing a value 2
- Excel Noob
August 11, 2022 at 3:06 PM
- Excel Noob
August 23, 2022 at 3:04 AM
-
- Replies
- 2
- Views
- 706
2
-
-
-
-
Creating customer frequency report 6
- JamJ
August 15, 2022 at 10:44 AM
- JamJ
August 17, 2022 at 8:57 AM
-
- Replies
- 6
- Views
- 525
6
-
-
-
-
Subtraction With Catagories 1
- jgaffney86
August 18, 2022 at 6:57 PM
- jgaffney86
August 21, 2022 at 4:25 AM
-
- Replies
- 1
- Views
- 396
1
-
-
-
-
Adding contents of cells based on month and location 9
- DezB
August 22, 2022 at 2:46 PM
- DezB
August 26, 2022 at 7:41 PM
-
- Replies
- 9
- Views
- 713
9
-
-
-
-
Needing help with formula to auto move text from one cell to another 2
- Jingles3X
August 30, 2022 at 6:38 PM
- Jingles3X
September 6, 2022 at 6:46 AM
-
- Replies
- 2
- Views
- 463
2
-
-
-
-
Excel Formula Help 3
- tdm99
September 8, 2022 at 4:16 AM
- tdm99
September 28, 2022 at 9:54 PM
-
- Replies
- 3
- Views
- 349
3
-
-
-
-
SUM with OFFSET | Fix #REF if Starting Date isn't 1st of Month 4
- ruppk825
September 9, 2022 at 11:38 PM
- ruppk825
September 10, 2022 at 10:13 AM
-
- Replies
- 4
- Views
- 397
4
-
-
-
-
Is it possible to copy multiple but separate formulae worksheet lines at the same time, between different worksheets? 6
- NormanW
September 13, 2022 at 3:24 PM
- NormanW
September 16, 2022 at 2:58 PM
-
- Replies
- 6
- Views
- 1.2k
6
-
-
-
-
Retrieving Table Header for a Value 1
- KnowNoVba
September 16, 2022 at 6:55 PM
- KnowNoVba
September 17, 2022 at 7:37 AM
-
- Replies
- 1
- Views
- 293
1
-
-
-
-
Conditional Weighted Averages using SUMPROD and IF Statements? 3
- ruppk825
September 22, 2022 at 7:36 PM
- ruppk825
September 29, 2022 at 7:39 AM
-
- Replies
- 3
- Views
- 576
3
-
-
-
-
Conditional formatting/coloring depending on values of 2 different cells 2
- BlueOcean2023
October 15, 2022 at 2:18 AM
- BlueOcean2023
October 15, 2022 at 8:20 AM
-
- Replies
- 2
- Views
- 571
2
-