Reputation
1,350
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
6 12
Newest
 Tumbleweed
Impact
~169k people reached

Feb
25
comment Retrieve the array indexes from a range
While there might be a perfect answer to your question, can you give a little more context on what you're trying to do? There's also likely a better way to get what you want without using an array of integers.
Feb
15
comment Excel, How to get last value in second column for a name selected in first column?
Would you mind explaining the 1/($a$1:$a$8=c1) in the lookup formula? I've never seen a slash used like that.
Jan
17
comment Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
Do you mean during the AHK portion or while 7-Zip is compressing?
Dec
1
answered Why doesn't my SUMIF formula work?
Dec
1
comment Why doesn't my SUMIF formula work?
Also, what is stored in E4? Formula? Number? String?
Dec
1
comment Why doesn't my SUMIF formula work?
Does a PivotTable give you correct results?
Dec
1
comment Why doesn't my SUMIF formula work?
My bet is that you have some look-alike or non-printing characters somewhere.
Dec
1
comment Why doesn't my SUMIF formula work?
Are you sure that your categories are 100% identical between your two tables? For example, in the main screen shot, what do you get from this formula? =if(G6=A4,"Same","Different")
Nov
9
comment Combining numeric values that have been converted from text
If you're doing your translation into cells H2:L2, then =AVERAGE(H2:L2) does it. But I'm thinking that you're trying to do something more difficult, right?
Nov
2
answered Why won't Windows 10 let me boot with new RAM?
Nov
2
comment Why won't Windows 10 let me boot with new RAM?
Important trouble-shooting step at this point: use a boot CD (or USB) with Linux on it (Ubuntu Live would be fine) and make sure that Linux boots. That will confirm that it is Windows specifically that is having the problem, and not a hardware incompatibility.
Sep
28
comment Excel 07: Sum Cells of Column B By Date in Column A And Report To Cell C
Given the question, I'm thinking that the desired equation would be =sumif(A:A,A1,B:B)
Sep
28
comment Excel 07: Sum Cells of Column B By Date in Column A And Report To Cell C
Do you know about Pivot Tables and are you sure they don't solve your problem? support.office.com/en-MY/Article/…
Sep
20
awarded  Tumbleweed
Sep
13
answered How to make AutoHotkey automatically close a pop-up dialog?
Sep
13
comment Pin folder to Start
Are you sure? In the file explorer, I opened my C drive, right-clicked on a random folder and on the Windows folder, and both of them included Pin to Start as an option, immediately above the Send to option. Pin to Quick access was not adjacent.
Sep
13
asked Set the Windows 10 default mailto handler to a program not listed
Sep
1
answered Special format of date in excel
Aug
20
revised Batch file to create .7z archive for each file (in folder/subfolder) to a new destination (folder/subfolder structure)
Improved the code solution.
Aug
19
awarded  Organizer