566 reputation
37
bio website
location
age 31
visits member for 2 years, 5 months
seen Dec 22 at 21:44

Jul
12
awarded  Yearling
Jan
15
comment Allowing users to unhide (format) only chosen columns
I'd suggest moving those columns you want to hide from everyone to a separate sheet which you protect and hide. You can easily reference cells in a different sheet if necessary.
Jul
12
awarded  Yearling
Jan
1
comment How can I recover data from my physically broken USB flash drive?
Possible Duplicate: superuser.com/q/123606/145677
Dec
18
answered Entering text value representing a sum in Microsoft Excel
Dec
13
comment Add Excel column without breaking equation
Unless your complex spreadsheet is using indirect cell referencing, when you insert the new column your existing formulas should automatically adjust.
Dec
13
answered excel index match do not ignore 0's
Dec
8
comment HLOOKUP Return Greatest Value
@all Thanks for reminding me that there's a 3rd parameter in Match. When I tested it, it seemed to work with just 2 so it simply slipped my mind. I added the 0s to assist future viewers.
Dec
8
revised HLOOKUP Return Greatest Value
Improved answer.
Dec
7
revised HLOOKUP Return Greatest Value
added 90 characters in body
Dec
7
answered HLOOKUP Return Greatest Value
Dec
2
comment Automatically select last row in a set in Excel
Indirect allows you to reference a cell by providing a the text of the reference. So something like Indirect("A" & B1) would end up being Column A and then whatever Row # corresponds to the value of B1. The only reason what I provided is resulting in 0 is that you must have at least 1 skipped row in Column B, as in a blank cell. If you want to keep the blank cells add a minus # of blank cells just before the last closing parenthesis, like so: =INDIRECT("B" &ROWS(A:A)-COUNTBLANK(INDIRECT("B" & ROW()+1 &":B" & ROWS(A:A)))-1)
Dec
2
answered Automatically select last row in a set in Excel
Nov
15
comment EXCEL Use function as a row number
Right, but you still need to use $A:$A instead of A:A or when you "copy across" the first column passed to the index column will keep shifting as well.
Nov
15
comment EXCEL Use function as a row number
You're right. Index is better. Indirect was the first thing that came to mind. :) Though I think you mean =0.5*Index($A:$A,Columns($A5:A5)) if you want to copy the formula across.
Nov
15
comment EXCEL Use function as a row number
@PeterJenkins Indirect lets you provide the reference as a string. So Indirect("A" & Column()) returns the value of A1 within the first column, A2 within the 2nd column etc...
Nov
15
answered EXCEL Use function as a row number
Nov
7
comment How can I run legacy versions of IE (IE7/IE8) on Windows 8?
@avrik, You'd need to actually e-mail the creater, megaperlz provided a link to the quoted page. The e-mail addresss is found from that.
Oct
31
comment Create shortcut key to insert new row using Excel 2010
+1, nice trick with F4!
Oct
26
comment Display vs Value in a Microsoft Access Form's dropdown box
Bound Column is on the Data Tab of the properties of the Combo Box (just confirmed in Access 2010.)