gtwebb's user avatar
gtwebb's user avatar
gtwebb's user avatar
gtwebb
  • Member for 10 years, 3 months
  • Last seen more than 2 years ago
  • Canada
26 votes
Accepted

How to have Excel chart connect data points when no value?

23 votes
Accepted

How to convert Excel file with multiple sheets to a set of CSV files?

21 votes

Searching for a value in Excel, returning yes or no

6 votes

How can I record a transition from a 0 to 1 in a column in Excel?

4 votes

Need a formula for Leap Year

4 votes

Creating a formula that analyzes whether or not individual was served between two dates

4 votes
Accepted

EXCEL - How to have a formula output and user input on the same cell?

3 votes
Accepted

=randombetween with a certain percentage between a narrower range

3 votes
Accepted

Compare the value change of data in Excel between two similar sheets without VBA?

3 votes
Accepted

Is there a way to reuse a calculated value in a formula?

3 votes

Remove text from cells that don't contain S, M, L, XL or XXL

3 votes

If/then formula in excel

3 votes

Calculating the average of day/hour/minute/second format in Excel 2010

3 votes

sort numbers and numbers+text together in Excel

2 votes
Accepted

Linear trendline equation incorrect in Excel

2 votes
Accepted

How to flip X and Y axes in Excel scatter chart with more than one series

2 votes
Accepted

INDEX and MATCH in Excel providing results 1 row lower than desired

2 votes

How do you properly align average and standard deviation outputs in a spreadsheet?

2 votes
Accepted

VBA file copy based on list to specific directory issue

2 votes
Accepted

Measuring Noise in Excel

2 votes
Accepted

Lock color scale (convert to fixed)

2 votes

Formula substitution excel

2 votes

Excel, Average for a specific column within table

2 votes

Excel chart: Poor plot of a straight horizontal line, due to settings that use "Major Unit: Fixed" for the vertical axis

2 votes
Accepted

Excel Converting Time to Decimal

2 votes
Accepted

Excel multi table lookup, can you find a more elegant solution?

2 votes

Automatically hyperlink-ify large number cells containing URLs in Excel 2010

2 votes

How do I write a formula in excel that lets me evaluate if each value in a row is TRUE?

2 votes
Accepted

Excel - Include cell in column count if previous cell in row contains certain text

2 votes

How do I replace cells in Column A of Excel if the column I'm pulling from is partially blank?

1
2 3 4 5