Excel Formulas
Questions related specifically to the use of Excel formulas.
-
-
-
Find a value in a row and column, return intersecting cell value 6
- t33p33
August 16, 2016 at 10:59 PM
- t33p33
August 18, 2016 at 8:29 AM
-
- Replies
- 6
- Views
- 1.9k
6
-
-
-
-
concatenate text and numbers 6
- lolstre.loster
August 24, 2016 at 11:59 AM
- lolstre.loster
August 25, 2016 at 7:01 AM
-
- Replies
- 6
- Views
- 1.7k
6
-
-
-
-
Searching the Substring with the Largest side value 6
- flashkid10
September 3, 2016 at 2:01 AM
- flashkid10
September 14, 2016 at 4:18 PM
-
- Replies
- 6
- Views
- 1.3k
6
-
-
-
-
Counting Unique Rows (FREQUENCY) 6
- AFord66
September 9, 2016 at 9:05 PM
- AFord66
September 13, 2016 at 4:46 AM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
Date string conversion 6
- waldis
September 25, 2016 at 12:30 AM
- waldis
September 25, 2016 at 5:38 AM
-
- Replies
- 6
- Views
- 1.2k
6
-
-
-
-
Formula to show which Staff have had no sick leave for previous 3 months 6
- skeeeter
January 21, 2017 at 9:28 PM
- skeeeter
January 22, 2017 at 6:13 PM
-
- Replies
- 6
- Views
- 1.1k
6
-
-
-
-
vlookup to count based on criteria? 6
- Gemma86
February 16, 2017 at 10:44 PM
- Gemma86
April 12, 2017 at 12:55 PM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
Count criteria in one cell 6
- IvCin
July 2, 2017 at 4:53 PM
- IvCin
July 3, 2017 at 3:00 PM
-
- Replies
- 6
- Views
- 1k
6
-
-
-
-
OFFSET formula to ignore cell with a blank formula 6
- Nagin
July 19, 2017 at 10:05 AM
- Nagin
July 19, 2017 at 7:09 PM
-
- Replies
- 6
- Views
- 13k
6
-
-
-
-
Is it possible to have cells turn yellow when being used after 6pm? 6
- TheRedBeard86
July 21, 2017 at 8:24 PM
- TheRedBeard86
July 25, 2017 at 10:18 PM
-
- Replies
- 6
- Views
- 865
6
-
-
-
-
Sum a value if its Date is within 90 days of each Month shown in second table 6
- burdenpi
August 7, 2017 at 4:10 AM
- burdenpi
August 7, 2017 at 8:05 PM
-
- Replies
- 6
- Views
- 859
6
-
-
-
-
Formula to extract data based on Month & Year 6
- HowardC
August 16, 2017 at 6:10 PM
- HowardC
August 17, 2017 at 2:30 PM
-
- Replies
- 6
- Views
- 1.4k
6
-
-
-
-
Adding time to create cell with 2 hyphenated times in it 6
- legin52
August 26, 2017 at 8:55 PM
- legin52
August 27, 2017 at 3:52 AM
-
- Replies
- 6
- Views
- 1k
6
-
-
-
-
Count up number of times a name appears against position and Skill 6
- DezB
September 1, 2017 at 1:37 PM
- DezB
September 1, 2017 at 2:54 PM
-
- Replies
- 6
- Views
- 876
6
-
-
-
-
Extracting Variable Dates with the same ID Number (but variable inputs) 6
- jwatson34
September 7, 2017 at 4:40 PM
- jwatson34
September 8, 2017 at 12:14 AM
-
- Replies
- 6
- Views
- 653
6
-
-
-
-
if value matches value in different sheet then countif 6
- marav08
October 23, 2017 at 12:54 PM
- marav08
October 23, 2017 at 3:07 PM
-
- Replies
- 6
- Views
- 953
6
-
-
-
-
Generating List from Separate Sheet 6
- DugganC
November 14, 2017 at 7:19 PM
- DugganC
November 15, 2017 at 7:10 PM
-
- Replies
- 6
- Views
- 873
6
-
-
-
-
i want to count date occurence 6
- timzy
November 22, 2017 at 6:38 PM
- timzy
November 22, 2017 at 7:44 PM
-
- Replies
- 6
- Views
- 724
6
-
-
-
-
lookup with changing parameter 6
- crombes
December 7, 2017 at 12:29 PM
- crombes
December 8, 2017 at 1:00 PM
-
- Replies
- 6
- Views
- 847
6
-
-
-
-
Conditional Format Max Date 6
- jl2509
January 12, 2018 at 3:05 PM
- jl2509
January 18, 2018 at 9:13 PM
-
- Replies
- 6
- Views
- 682
6
-