566 reputation
37
bio website
location
age 31
visits member for 2 years, 8 months
seen Mar 24 at 20:38

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.
Jan
1
comment How can I recover data from my physically broken USB flash drive?
Possible Duplicate: superuser.com/q/123606/145677
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
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
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)
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
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.)
Oct
26
comment Close an excel file automatically
The only way I can think to do this is to keep track of when the workbook was last used by setting a variable for basically any event... and then using Application.Ontime to have a sub that checks the date in the variable to see if it was last updated 5 or more minutes ago. This solution is far too involved for me to be willing to write it for you though...
Oct
22
comment Automation for filling in sets of numbers in each row
If you're going to do it this way, you actually only have to fill in the first 2 cells. :)
Oct
19
comment Is there an Excel “missing value” or “NA” symbol?
I think the closest thing is using an empty string... but perhaps someone will surprise me.
Oct
19
comment 'Subscript out of range' error when selecting a range
I was sure that you would eventually do something else. You just didn't share that part. I hope you get the rest working without problems.
Oct
18
comment 'Subscript out of range' error when selecting a range
FYI: If your question is specifically about code you have written, (like this one) you will get a broader audience willing and able to answer by asking on Stack Overflow instead of Super User.
Oct
16
comment Find a range of cells with a MATCH
If you want to avoid doing things manually, how can you avoid vba? PivotTables are pretty simple.
Oct
2
comment MS Excel: How to work with a column chosen by value in header (row1)
+1 for being a complicated enough that I had to look at it for a few minutes to figure out why it worked.
Oct
2
comment How can I write an excel formula to do row based calculations; where certain conditions need to be met?
It sounds like you want to use SUMIF. Something like SUMIF(B:B,"P3",C:C) would add the columns in column C where the corresponding row in Column B = "P3"
Sep
25
comment run vb6 application (.exe) on windows startup with out login
This may solve your issue: Running Batch File in BackGround when Windows Boots UP