Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 9 23
Newest
 Reviewer
Impact
~551k people reached

2h
comment Copy paste to excel
You mention "production url". So this is what? Not your production environment? You give far too little information except for what you don't want to do.
Jun
22
comment Concatenate with column header but omit blanks with Excel for Mac 2011
I added a screenshot.
Jun
22
comment Concatenate with column header but omit blanks with Excel for Mac 2011
Not if the cell is truly empty. What is in the cell? Post the formula or the exact contents.
Jun
21
comment Concatenate with column header but omit blanks with Excel for Mac 2011
I added an adjusted formula
Jun
21
comment Concatenate with column header but omit blanks with Excel for Mac 2011
It looks like your "Real" sheet has a formula that pushes an empty string into the cell, like =If(true,"value","") -- The "false" value is an empty string and will be counted. I wish you would include details like that in your question. An empty cell is not the same as a cell that contains a formula that returns a "" string.
Jun
19
comment Excel - can you change the line colour of a Freeze panel divider?
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
Jun
16
comment How to auto fill increasing values between existing filled cells
(1) I'm showing that the approach does work for multi-column ranges. It also works for single column ranges, of course. (2) Checking for 0 will make sure that the incrementing numbers are only added below cells with a 0 value, not cells with text.
Jun
11
comment How do you construct an IF statement with three conditions in Excel?
Thanks for the feedback. Please mark my post as the answer, so others can find it more easily.
Jun
6
comment Excel formula daily average of weight
You have changed the formula to something completely different. Even the original formula will not calculate what you describe in your question. It will just return the difference between the current row and the previous row's weight, not the average daily difference. Just stick to B3-B2 instead. It does the same thing. The whole Offset or Index exercise is only for geeks dealing with deleting rows. If you don't delete rows, you don't need either Offset or Index.
Jun
6
comment Excel formula daily average of weight
I see your point. That issue needs to be taken up with Excel in general, though. I've trained myself to avoid Offset wherever possible, because this volatile function will cause workbook slowness. Data samples in forum questions are never the whole picture. Offering volatile functions may be fine for a small data set, but may choke the OP's workbook. Try using Index instead of Offset. In this case it would be =B3-INDEX(B:B,ROW()-1)
Jun
6
comment Excel formula daily average of weight
Offset? Really? Why use a volatile function when you could just use B2 instead? And that does NOT calculate the weight difference per day.
Jun
6
comment Excel formula daily average of weight
Is that the total weight of all cattle in column B? Or do you have the individual weight per animal? If so, how do you identify the animal?
Jun
5
comment Excel formula sum multiple rows/column once on cell has reached it's max number and continue to sum
If this answers your question, please mark the post as the answer so others can find it more easily.
Jun
4
comment Count only rows where two columns both contain one of a specific set of values
I added another formula that calculates that.
Jun
4
comment Automate spreadsheet (Excel/CSV) workflow
@Karan, yes, looks like it. The "Premium" features seem to include stuff that is typically used by enterprises, like Active Directory. But even the home user can now get all the goodness of Power Query for queries from SQL, web, Excel tables, etc. That's a real treat. Try doing an Unpivot, then you'll know how good Power Query is.
Jun
4
comment Automate spreadsheet (Excel/CSV) workflow
@Karan, Power Query is now available for all editions of 2013. Details on the Power Query Download Page
Jun
3
comment How to hyperlink within the current sheet in a copy of the sheet?
Please read all of my post, especially the last sentence. Details matter. You must save the workbook before you can use the formula. If you don't read the details and if you don't follow the instructions, then you will get errors. That is not the fault of the instructor.
Jun
3
comment Excel countif formula that will subtract from another number if cell contains certain values
You've explained it all right, but it would be easier to actually see the workbook or at least a screenshot. Use a file sharing service and post a link.
Jun
3
comment Excel Function: Count the number of Rows that do not have a certain value and are not blank
Using array formulas on whole columns is not a very good idea, unless you like slow spreadsheets.
Jun
3
comment Count only rows where two columns both contain one of a specific set of values
I just said you don't need it, not that it's wrong to use it. It creates typing work.