Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 8 23
Newest
 Yearling
Impact
~465k people reached

15h
comment Excel data validation to whole column
@AllSolutions, what part are you struggling with? Insert a table. Apply the data validation to the table column. It will carry over into new rows.
Apr
24
comment Column of text needs “summed” based on assigned value
Thanks for the feedback. Glad it worked for you.
Apr
24
comment Column of text needs “summed” based on assigned value
You're funny. Let me know if it works or if you need more guidance.
Apr
23
comment Excel data validation to whole column
@AllSolutions, All formats, formulas and data validation that are applied to an Excel table column will be carried over into new rows.
Apr
22
comment Automate spreadsheet (Excel/CSV) workflow
The question asks for a tool or process. Answers may well include code or data management techniques, not just products. As it happens, the Microsoft Power BI stack has a suitable approach. Power Query will not go away any time soon.
Apr
22
comment Add a cell content to another cell if a different cell has a specific content
Please learn how this site works. No, you cannot tack on more questions in comments. Please mark the answer. Then start a new question.
Apr
21
comment How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?
Well, as far as I understand you want to highlight the range BETWEEN which the value falls. 5000 is not between any of the values, so nothing gets highlighted.
Apr
20
comment Powerpivot, Calculate(SUM()) with OR Statement?
Sum the column and use filters in the pivot table, not in the measure.
Apr
20
comment How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?
How do you want this to look? What is the expected result with your data sample? Highlight what? How?
Apr
20
comment Add a cell content to another cell if a different cell has a specific content
I edited my answer. It's really the same formula, just using different columns and a different row for the sum range.
Apr
20
comment I am trying to use the if function to look at cells to the left and leave the cell blank if they are blank or calculate if they are not
I edited my answer with a few more suggestions.
Apr
20
comment Add a cell content to another cell if a different cell has a specific content
@MarkNev, I'm afraid your very wordy explanations are really hard to weed through. Post a screen shot or a link to a sample file. That would help.
Apr
20
comment Hyperlinking or linking in another way to a cell without it being able to change
glad it helped. Please mark the post as the answer.
Apr
19
comment MS Excel - adding line to some series in stacked bar chart
@JonPeltier, this is a gem. You should post this as an answer so it can attract upvotes, which will expose the trick to more folks.
Apr
17
comment Excel, macro move one row down and then delete the row
In a table you can only delete whole rows, not parts of rows. Please step back and explain the bigger picture. Edit your post. Don't use the comments.
Apr
16
comment Excel, macro move one row down and then delete the row
Excel has a command to remove duplicates. It's on the Data ribbon. Why not use that instead of re-inventing the wheel?
Apr
7
comment Getting CHAR function to return multiple characters in Excel 2011
What you want to achieve cannot be done with a formula, because you need to iterate for every letter of the alphabet. You would need a function for that, unless you want to nest 26 Substitute functions.
Feb
15
comment What's the difference between “Edit Links” and “Update Links” in Excel?
Very concise explanation.
Feb
11
comment Excel: How to skip specific rows when importing a CSV
@Yuck can you substantiate that? Based on your perception of Excel's capabilities in a very unlikely scenario you downvote?
Feb
11
comment Excel: How to skip specific rows when importing a CSV
@Yuck Nope what? What if he has? What's 100,000 rows? Excel can handle ten times as many. He can still import all rows and delete the first and last one. Instead of downvoting, offer something better.