Excel Formulas

Questions related specifically to the use of Excel formulas.

• ajrilo1
2. Replies
12
Views
650
12
1. Drop down boxes and Pivot Tables1

• kramer100
2. Replies
1
Views
147
1
1. Calculate ONLY if before the 10th day of month7

• Mirinjawbro
2. Replies
7
Views
294
7

• ajrilo1
2. Replies
5
Views
263
5
1. Array Formula Value Error7

• Excel Noob
2. Replies
7
Views
342
7

• ajrilo1
2. Replies
2
Views
199
2
1. Match one cell value with another then extract row data3

• Smudge.Smith
2. Replies
3
Views
180
3
1. Extract text from a string of text based on the range defined13

• brijeshkeni
2. Replies
13
Views
436
13
1. Cell Value Fill Based on Color11

• dan_jordan84
2. Replies
11
Views
625
11

• jbanks
2. Replies
2
Views
395
2
1. 'tricking' excel to recognise a table header outside of the table6

• paulbiddis
2. Replies
6
Views
528
6
1. FILTER and UNIQUE - dependent dropdown lists...19

• paulbiddis
2. Replies
19
Views
718
19
1. Formula for calculating totals for different months in a list as a percentage?7

• Smudge.Smith
2. Replies
7
Views
264
7

• beealf
2. Replies
9
Views
580
9

• Sper434
2. Replies
5
Views
251
5
1. INDIRECT function does not work when referencing to a dynamic list10

• paulbiddis
2. Replies
10
Views
442
10
1. Combining Monthly Fee Totals by month, year, and location with Annual Fee Increases14

• Retailmessiah
2. Replies
14
Views
760
14

• jbanks
2. Replies
4
Views
266
4
1. data array with date range and return text value in result4

• jigarecity
2. Replies
4
Views
213
4

• jbanks
2. Replies
2
Views
172
2