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

Apr
20
answered 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
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
answered Add a cell content to another cell if a different cell has a specific content
Apr
19
answered Hyperlinking or linking in another way to a cell without it being able to change
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
16
revised Excel, macro move one row down and then delete the row
code tags
Apr
15
answered MS Excel - adding line to some series in stacked bar chart
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.
Mar
23
answered Excel related query for the merging of data
Mar
20
answered How to replicate efficient pasting from delimited text behavior in Excel?
Mar
11
revised Changing Clustered Column Parameters in Excel
added 247 characters in body
Mar
11
answered Changing Clustered Column Parameters in Excel
Feb
16
revised Create Excel chart showing % change (multiple industries) over time
added 277 characters in body
Feb
16
answered Create Excel chart showing % change (multiple industries) over time
Feb
15
comment What's the difference between “Edit Links” and “Update Links” in Excel?
Very concise explanation.
Feb
15
revised How do I keep a value the same in a cell
formatting
Feb
14
answered Excel 2010 - Pasting as picture without gridlines without having to turn off gridlines setting every time