Reputation
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
6 31 62
Newest
 Necromancer
Impact
~1.1m people reached

1d
comment How do I enable macros on an external harddrive
What OS? What version excel?
Apr
28
comment Is there a limit on the number of rows a sum function can calculate in Excel 2007?
255 arguments per function
Apr
28
comment How do I enable macros on an external harddrive
That or set a junction point for it on C:
Apr
27
comment Counting specific words within a batch of Word documents
What have you tried already?
Apr
27
revised Counting specific words within a batch of Word documents
edited title
Apr
27
revised Finding Clustered/Consecutive Values in Excel
added 148 characters in body
Apr
27
comment Finding Clustered/Consecutive Values in Excel
So are they always separated by one space? Are they all in one cell? One column? Do you need to retain the non-highlighted numbers? If each number is in one column and its own cell, can't you just use some conditional formatting? When you say clustered you mean consecutive? I tried cleaning up the formatting in your question, it was making it very difficult to understand.
Apr
26
revised Web Scraping with Macros in one sheet
added 256 characters in body
Apr
26
comment Excel 2007 Automatic workbook calculation keeps going to manual
Yes, using a template will have excel use those settings.
Apr
25
revised Excel formula to identify and group figures
deleted 12 characters in body; edited title
Apr
25
comment Excel 2007 Automatic workbook calculation keeps going to manual
Yes, whatever your template is can affect this. Also any macros in that workbook or your personal macro workbook.
Apr
24
comment Excel formula to identify and group figures
Look into sumif
Apr
24
revised Excel formula to identify and group figures
added 28 characters in body
Apr
22
comment Taking an indirect reference in excel and making it a direct reference
VBA will be the way to do this. I mean it's possible using a bunch of formulas, but not easy.
Apr
21
comment How can a cell be displayed if another cell is marked?
why not just use a filter?
Apr
21
comment Using IF to compare name of a worksheet with worksheets in workbook
What have you tried? Where are you stuck?
Apr
21
comment Remove timestamp from filename
relavent
Apr
20
comment How to make data shown on excel drop down list appear as numbers (shortcuts)?
What do you have already?
Apr
19
comment Run VirtualBox in background, without a window
Completely agree with @DragonLord - click here to go to the other question and close it as a dupe to this one.
Apr
19
comment Dynamic choice dataset Microsoft Excel
So the choice set should remain constant for, say, one entire day? I'm trying to figure out if there's a discernible pattern that you could use for VBA, or, better yet a table or pivot table. Right now, it really doesn't seem like a job for excel.