Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
extract data to another sheet with multiple conditions? 7
- Zak2021
June 7, 2019 at 6:48 PM
- Zak2021
June 11, 2019 at 1:46 PM
-
- Replies
- 7
- Views
- 1.1k
7
-
-
-
-
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
-
-
-
-
How do I average multiple columns (ignoring zeros and blank cells)? 1
- yeto
February 1, 2020 at 3:49 PM
- yeto
February 1, 2020 at 4:23 PM
-
- Replies
- 1
- Views
- 969
1
-
-
-
-
Search Cell for Specific Characters 3
- Yeppy12
March 13, 2017 at 6:17 PM
- Yeppy12
March 13, 2017 at 6:57 PM
-
- Replies
- 3
- Views
- 795
3
-
-
-
-
Unique (text) value for Randbetween 4
- XXX7
September 22, 2019 at 9:47 AM
- XXX7
September 23, 2019 at 12:18 AM
-
- Replies
- 4
- Views
- 857
4
-
-
-
-
Multiple returns with 2 criteria from another workbook 29
- xsmurf
March 19, 2022 at 1:22 PM
- xsmurf
May 23, 2023 at 4:02 PM
-
- Replies
- 29
- Views
- 2.4k
29
-
-
-
-
Variable Cell Reference based on Path 9
- xlbrian
April 3, 2019 at 3:25 PM
- xlbrian
April 4, 2019 at 5:49 PM
-
- Replies
- 9
- Views
- 1.6k
9
-
-
-
-
Find adj. cells with specific text strings. Return a text string based on findings. 1
- XJmikeT
April 29, 2019 at 7:21 PM
- XJmikeT
May 4, 2019 at 3:40 PM
-
- Replies
- 1
- Views
- 571
1
-
-
-
-
Display selection based on a value in another cell 5
- xcel4me
December 2, 2016 at 12:33 PM
- xcel4me
December 11, 2016 at 5:14 PM
-
- Replies
- 5
- Views
- 1.8k
5
-
-
-
-
Splitting long text 2
- Xcasual
May 23, 2023 at 6:56 PM
- Xcasual
May 26, 2023 at 2:30 AM
-
- Replies
- 2
- Views
- 278
2
-
-
-
-
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
-
-
-
-
Calculate Total Times Ticket Open 4
- Xani
December 17, 2021 at 3:54 AM
- Xani
December 19, 2021 at 4:45 PM
-
- Replies
- 4
- Views
- 805
4
-
-
-
-
How to make drop down menu by showing staff name and staff id ? 3
- Xani
June 25, 2021 at 8:00 AM
- Xani
June 26, 2021 at 7:13 AM
-
- Replies
- 3
- Views
- 661
3
-
-
-
-
Calculate Duration between two dates 2
- Xani
June 5, 2021 at 7:10 PM
- Xani
June 9, 2021 at 2:29 PM
-
- Replies
- 2
- Views
- 569
2
-
-
-
-
Dropdown Menu & VLookup formula not working 9
- Xani
April 13, 2021 at 3:11 PM
- Xani
April 16, 2021 at 12:39 AM
-
- Replies
- 9
- Views
- 1.7k
9
-
-
-
-
How to calculate variance and ratio total open and closed tickets? 1
- Xani
March 20, 2021 at 8:25 AM
- Xani
March 20, 2021 at 9:20 AM
-
- Replies
- 1
- Views
- 554
1
-
-
-
-
How to get total days which it is Reported Date - Actual Finish? 2
- Xani
June 23, 2020 at 6:45 PM
- Xani
June 24, 2020 at 5:17 PM
-
- Replies
- 2
- Views
- 733
2
-
-
-
-
How to return total queued amount to specific owner name field ? 4
- Xani
August 28, 2019 at 3:50 PM
- Xani
August 29, 2019 at 10:50 AM
-
- Replies
- 4
- Views
- 818
4
-
-
-
-
How to show if two labors having conflict dates of leave?
- Xani
May 28, 2019 at 6:21 AM
- Xani
May 28, 2019 at 6:21 AM
-
- Replies
- 0
- Views
- 200
-
-
-
-
How to show if two labors having conflict dates of leave? 1
- Xani
May 28, 2019 at 6:14 AM
- Xani
May 28, 2019 at 6:34 AM
-
- Replies
- 1
- Views
- 259
1
-