Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
How to show if two labors having conflict dates of leave?
- Xani
May 28, 2019 at 6:12 AM
- Xani
May 28, 2019 at 6:12 AM
-
- Replies
- 0
- Views
- 179
-
-
-
-
Check if two columns match or not 5
- Xani
September 19, 2018 at 11:28 AM
- Xani
September 20, 2018 at 7:05 AM
-
- Replies
- 5
- Views
- 814
5
-
-
-
-
How to remove unwanted test from string ? 1
- Xani
July 23, 2018 at 11:20 AM
- Xani
July 23, 2018 at 12:15 PM
-
- Replies
- 1
- Views
- 448
1
-
-
-
-
Formula giving wrong total duration between two dates 2
- Xani
June 30, 2018 at 10:05 AM
- Xani
July 1, 2018 at 5:50 AM
-
- Replies
- 2
- Views
- 902
2
-
-
-
-
Formula to calculate duration difference between two dates ? 2
- Xani
September 21, 2017 at 1:52 PM
- Xani
September 21, 2017 at 3:01 PM
-
- Replies
- 2
- Views
- 864
2
-
-
-
-
Return Total value from one sheet to another sheet depend on criteria ? 17
- Xani
August 24, 2017 at 3:57 PM
- Xani
August 29, 2017 at 4:39 PM
-
- Replies
- 17
- Views
- 2.2k
17
-
-
-
-
Need to calculate status of each owner? 16
- Xani
August 19, 2017 at 6:35 AM
- Xani
August 21, 2017 at 10:03 AM
-
- Replies
- 16
- Views
- 2.4k
16
-
-
-
-
Date conflict between two persons ? 1
- Xani
August 7, 2017 at 7:04 PM
- Xani
August 7, 2017 at 8:29 PM
-
- Replies
- 1
- Views
- 655
1
-
-
-
-
Calculate time if greater than specific time in excel? 16
- Xani
July 26, 2017 at 10:30 AM
- Xani
July 27, 2017 at 8:40 AM
-
- Replies
- 16
- Views
- 2.5k
16
-
-
-
-
Copy rows of data to another worksheet if a condition is met in one of the cells 1
- Wynnum
June 3, 2017 at 3:51 PM
- Wynnum
June 6, 2017 at 5:06 PM
-
- Replies
- 1
- Views
- 727
1
-
-
-
-
3 Random Values from a list skipping blanks 2
- wrigst
May 1, 2020 at 5:42 PM
- wrigst
May 22, 2020 at 2:33 PM
-
- Replies
- 2
- Views
- 2.1k
2
-
-
-
-
Vlookup using tabs with specific cell reference 2
- wosborne
May 9, 2016 at 11:57 AM
- wosborne
May 10, 2016 at 3:29 PM
-
- Replies
- 2
- Views
- 1.1k
2
-
-
-
-
formula to remove all characters after a dash in a text string from the right 3
- world33
April 20, 2017 at 9:33 AM
- world33
April 20, 2017 at 11:44 AM
-
- Replies
- 3
- Views
- 1.2k
3
-
-
-
-
Copy row of data if column 1 is a certain number 1
- woodstock1984
March 27, 2017 at 4:03 PM
- woodstock1984
March 27, 2017 at 4:47 PM
-
- Replies
- 1
- Views
- 586
1
-
-
-
-
Show a particular letter/value if a specific cell is included with one of the lists 2
- woodstock1984
March 27, 2017 at 11:48 AM
- woodstock1984
March 27, 2017 at 3:21 PM
-
- Replies
- 2
- Views
- 501
2
-
-
-
-
Excel function to exclude a list dates/columns 5
- wonka1234
April 12, 2018 at 4:23 PM
- wonka1234
April 24, 2018 at 2:45 PM
-
- Replies
- 5
- Views
- 1.1k
5
-
-
-
-
COUNTIFS or SUMPRODUCT? Match criteria if other criteria is met. 3
- Wobzy
March 26, 2017 at 3:58 AM
- Wobzy
March 26, 2017 at 8:47 AM
-
- Replies
- 3
- Views
- 750
3
-
-
-
-
Complex INDEX and SMALL or MATCH based on muliple criteria 4
- wizcreations
March 29, 2018 at 9:57 PM
- wizcreations
June 13, 2018 at 5:54 AM
-
- Replies
- 4
- Views
- 677
4
-
-
-
-
Trouble w VLOOKUP (later in formula) displaying "0"s or #VALUE! 11
- wittonline
December 20, 2017 at 9:38 AM
- wittonline
December 28, 2017 at 10:37 PM
-
- Replies
- 11
- Views
- 1.9k
11
-
-
-
-
Add an additional IF statement with a qualifying column value to existing formulas 3
- wittonline
October 12, 2017 at 2:44 AM
- wittonline
October 12, 2017 at 5:56 PM
-
- Replies
- 3
- Views
- 751
3
-