Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Using a value from a cell inside a formula 8
- yogeshtalks
-
- Replies
- 8
- Views
- 2k
8
-
-
-
-
How do I average multiple columns (ignoring zeros and blank cells)? 1
- yeto
-
- Replies
- 1
- Views
- 741
1
-
-
-
-
Search Cell for Specific Characters 3
- Yeppy12
-
- Replies
- 3
- Views
- 663
3
-
-
-
-
Unique (text) value for Randbetween 4
- XXX7
-
- Replies
- 4
- Views
- 729
4
-
-
-
-
Multiple returns with 2 criteria from another workbook 1
- xsmurf
-
- Replies
- 1
- Views
- 250
1
-
-
-
-
Variable Cell Reference based on Path 9
- xlbrian
-
- Replies
- 9
- Views
- 1.3k
9
-
-
-
-
Find adj. cells with specific text strings. Return a text string based on findings. 1
- XJmikeT
-
- Replies
- 1
- Views
- 478
1
-
-
-
-
Display selection based on a value in another cell 5
- xcel4me
-
- Replies
- 5
- Views
- 1.6k
5
-
-
-
-
Using Countif to calculate totals from another excel tab 1
- Xani
-
- Replies
- 1
- Views
- 189
1
-
-
-
-
Calculate Total Times Ticket Open 4
- Xani
-
- Replies
- 4
- Views
- 478
4
-
-
-
-
How to make drop down menu by showing staff name and staff id ? 3
- Xani
-
- Replies
- 3
- Views
- 409
3
-
-
-
-
Calculate Duration between two dates 2
- Xani
-
- Replies
- 2
- Views
- 396
2
-
-
-
-
Dropdown Menu & VLookup formula not working 9
- Xani
-
- Replies
- 9
- Views
- 1.1k
9
-
-
-
-
How to calculate variance and ratio total open and closed tickets? 1
- Xani
-
- Replies
- 1
- Views
- 424
1
-
-
-
-
How to get total days which it is Reported Date - Actual Finish? 2
- Xani
-
- Replies
- 2
- Views
- 625
2
-
-
-
-
How to return total queued amount to specific owner name field ? 4
- Xani
-
- Replies
- 4
- Views
- 632
4
-
-
-
-
How to show if two labors having conflict dates of leave?
- Xani
-
- Replies
- 0
- Views
- 140
-
-
-
-
How to show if two labors having conflict dates of leave? 1
- Xani
-
- Replies
- 1
- Views
- 167
1
-
-
-
-
How to show if two labors having conflict dates of leave?
- Xani
-
- Replies
- 0
- Views
- 114
-
-
-
-
Check if two columns match or not 5
- Xani
-
- Replies
- 5
- Views
- 645
5
-