Reputation
1,063
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
5 10
Newest
 Custodian
Impact
~93k people reached

May
15
comment Excel 2010 Advanced Filter issue
Oh, I think I just caught something: you're okay with AAA or with 1A2B, but you don't want to see both.
May
15
comment Excel 2010 Advanced Filter issue
For example, here's the simple mockup I did based on reading your question: dropbox.com/s/6mb3nsbbxm7oa5d/AdvancedFilter.xlsx?dl=0
May
15
comment Excel 2010 Advanced Filter issue
I was just thinking that you might mock up your table in your question. If you use the code formatting option, the font will be monospaced, so you can get your columns to line up. Otherwise, your options are a publicly shared file on something like Dropbox or a screenshot.
May
15
comment How to reload a bak of etc/apache2/httpd.conf in terminal after bad changes made with Vim?
@TD.512 is saying that "/Users/catherinelegna/Desktop/Capture d’écran 2015-05-15 à 15.20.03.png" doesn't do us any good. Please edit your question and replace that line with the image itself. Or upload the image to an image-sharing site and link to it.
May
15
comment Excel 2010 Advanced Filter issue
When I set up an Excel spreadsheet with the example criteria, it behaves as expected. You might be doing something that only becomes clear once we can see what you're doing instead of imagining it.
May
15
comment Excel 2010 Advanced Filter issue
Can you provide the simplest example you can test in Excel that produces this behavior?
Apr
24
comment Properly extracting from an array
Also, if you're using PowerShell to read a CSV file into a PowerShell array, what's wrong with $project = Import-Csv "project.csv" ?
Apr
24
comment Properly extracting from an array
Please clarify what you are attempting. Your tags imply that you are trying to create an Excel file from a CSV file, using PowerShell. That seems the wrong way to import CSV files into Excel.
Feb
25
comment Users and permissions on a Raspi which is both a home and an owncloud server
While SU may well be the best place to get this question answered, it strikes me that the folks on the Raspberry Pi (raspberrypi.stackexchange.com) and Unix/Linux (unix.stackexchange.com) SE sites might be more familiar.
Jan
22
comment Defining Variables in Excel
Would you please provide an example? My first read is that this is a very basic question about writing an equation like =B$1*$A2
Jan
21
comment Notepad++ find procedure/ function declaration
What have you tried?
Jan
12
comment Notepad++ macro for changing a certain part of a string
In the absence of another of these solutions working for you, I would personally write a Python script to do it: sourceforge.net/projects/npppythonscript
Jan
12
comment Notepad++ macro for changing a certain part of a string
How often are you doing this to how many strings? If only a few, I would just use Notepad++'s multi-line editing features without a macro. If a lot, Excel find and concatenation functions can build your strings. If other conditions are met, a regex in Notepad++ could do it.
Oct
7
comment Send Key in AutoHotKey without recursion
Prefixing your hotkey with $ is a less-drastic way of doing the same. ahkscript.org/docs/Hotkeys.htm#prefixdollar
Aug
11
comment Mapping Ctrl+w to Alt+w sends both Ctrl+Alt+w
Nope. I just assumed from the quoted text that I needed to use LCtrl instead of Ctrl.
Aug
7
comment How do I see the current filter being applied in Excel?
@Lupius, in a simple table with filters, all of the filters are in row 1, as seen here: snag.gy/Hr2Id.jpg How does your spreadsheet differ from my image?
Aug
4
comment Move a cell based on date input across row
Are you looking for a tutorial on Excel formulas? Or to hire someone to create an Excel spreadsheet for you? Or do you have a specific problem getting =vlookup() to work for this situation?
Jun
13
comment How can I check to see if a group of cells in an Excel spreadsheet have equivalent relative formulas?
<kbd>Ctrl</kbd>+<kbd>`</kbd> is the shortcut for "Show Formulas." In Excel 2010, "Show Formulas" is on the "Formulas" ribbon in the "Formula Auditing" section.
Jun
2
comment How can I lock images to a cell in excel 2010?
The UI is slightly different in 2010, but the instructions are the same.
May
27
comment How to draw 12W DC output from PC motherboard/PSU/USB?
@SNag I'm definitely interested in seeing your final solution. It would be worthwhile to post your solution as an answer to this question, in case it is useful to others in a similar situation.