Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 10 24
Impact
~640k people reached

Jun
19
answered Excel 2010 Array (CSE) Formula: How to remove a part of contiguous (adjacent) range
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
11
answered How do you construct an IF statement with three conditions in Excel?
Jun
10
answered Writing excel formulae that reference columns by number rather than letter
Jun
8
answered How to keep pivot table from expanding into occupied rows and columns
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
answered Excel formula daily average of weight
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
5
answered Excel formula sum multiple rows/column once on cell has reached it's max number and continue to sum
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
revised Count only rows where two columns both contain one of a specific set of values
added 185 characters in body
Jun
4
revised Replace data validation selection in Excel
deleted 21 characters in body; edited title
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
answered Replace data validation selection in Excel
Jun
4
revised Automate spreadsheet (Excel/CSV) workflow
added system requirements for PQ
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