Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Locate any consecutive cells in a row (where employee worked)
- jumper5two
-
- Replies
- 0
- Views
- 381
-
-
-
-
Excel: I want a list of dates to populate if the word fail is entered 4
- jdwart
-
- Replies
- 4
- Views
- 757
4
-
-
-
-
Using wildcard in conditional formula not working 3
- Billyrj
-
- Replies
- 3
- Views
- 916
3
-
-
-
-
Search bar using FILTER formula 1
- chester1993
-
- Replies
- 1
- Views
- 498
1
-
-
-
-
Top 10 from list 5
- jbanks
-
- Replies
- 5
- Views
- 962
5
-
-
-
-
using INDIRECT to set structured table reference in formula and return COUNTIF result based on another column value 2
- alz1
-
- Replies
- 2
- Views
- 431
2
-
-
-
-
Formula for finding Retirement Age 3
- marudhak
-
- Replies
- 3
- Views
- 746
3
-
-
-
-
Formula for Conditional Formatting in Tables 1
- Crazy Brit
-
- Replies
- 1
- Views
- 769
1
-
-
-
-
WEEKNUM system 1 and 2 2
- arabella
-
- Replies
- 2
- Views
- 1.3k
2
-
-
-
-
Round Time up 3
- onexc
-
- Replies
- 3
- Views
- 695
3
-
-
-
-
Orders created in rolling 7 days period 9
- cire_d
-
- Replies
- 9
- Views
- 1.1k
9
-
-
-
-
Sort and filter 3 columns 3
- Sheepkin_Coat
-
- Replies
- 3
- Views
- 687
3
-
-
-
-
Calculated Values on a Filtered Table 3
- mrbuttons
-
- Replies
- 3
- Views
- 803
3
-
-
-
-
Separating cell info counting in a pivot table 4
- Smudge.Smith
-
- Replies
- 4
- Views
- 658
4
-
-
-
-
Providing Notification of When a Task is Due Based on Dates 1
- VWRSue
-
- Replies
- 1
- Views
- 666
1
-
-
-
-
Finding y-axis value
- husnafezaahmad
-
- Replies
- 0
- Views
- 246
-
-
-
-
Grouping Time into specific Criteria/Group 3
- mrbuttons
-
- Replies
- 3
- Views
- 793
3
-
-
-
-
Blank cells replace zeros 30
- CJamesUK
-
- Replies
- 30
- Views
- 3k
30
-
-
-
-
Vlook up 5
- jpetraityte
-
- Replies
- 5
- Views
- 910
5
-