1,175 reputation
66
bio website
location
age
visits member for 4 years, 1 month
seen yesterday

Dec
12
revised Comparing the first part of a string in Excel
deleted 2 characters in body
Dec
12
revised Comparing the first part of a string in Excel
added 262 characters in body
Dec
12
answered Comparing the first part of a string in Excel
Dec
11
answered OR Statement for Advanced Filtering
Dec
5
comment How to condense sparse data in a table with redundant rows and columns
I should have mentioned: you can get to the "old" pivot table wizard in newer versions of excel by hitting ALT + D, P. You ought to then be able to use Walkenbach's method.
Dec
5
revised How to condense sparse data in a table with redundant rows and columns
added 206 characters in body
Dec
5
answered How to condense sparse data in a table with redundant rows and columns
Dec
2
answered Identify records with multiple IDs in Excel
Nov
12
awarded  Yearling
Nov
11
revised Excel 2013: I need to go to last row in a table, go up 48 rows, then sum every 12th row
added 101 characters in body
Nov
11
answered Excel 2013: I need to go to last row in a table, go up 48 rows, then sum every 12th row
Oct
20
answered excel: compare 3 column's numbers, decide on the largest number and place the column header in the 4th column
Oct
15
answered Error is using Microsoft Query data in excel in 3rd Person's PC
Oct
14
comment how to create vertical line in excel for multiple charts/multiple y ranges
Try determining the average of the data already plotted on the secondary axis, and use that average in place of the "1" values shown in column C above. Then the technique of using a 100% error bar should still work. Your secondary axis shouldn't need to be changed in this case, if I'm not mistaken.
Oct
14
revised how to create vertical line in excel for multiple charts/multiple y ranges
deleted 17 characters in body
Oct
14
revised how to create vertical line in excel for multiple charts/multiple y ranges
added 17 characters in body
Oct
14
revised how to create vertical line in excel for multiple charts/multiple y ranges
added 34 characters in body
Oct
14
revised how to create vertical line in excel for multiple charts/multiple y ranges
added 34 characters in body
Oct
14
answered how to create vertical line in excel for multiple charts/multiple y ranges
Sep
9
answered Difficulty Graphing Excel Data