Reputation
772
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
1 5 14
Newest
 Organizer
Impact
~83k people reached

Jan
2
comment excel equation to find corresponding value
Good catch @Scott. I've edited to swap them around.
Jan
2
revised excel equation to find corresponding value
Swapped the columns to match OP request.
Dec
31
answered Is it possible to copy a worksheet so that worksheet references are transfered relatively to the new workskeet?
Dec
31
answered Why is that sometimes the excel goal seek doesn't stop exactly at zero
Dec
31
comment Conditional filter in excel
Try recording a macro of you doing this using the filter in E6. Then try modifying the macro to use B1. THEN post here with specific issues you are facing.
Dec
27
comment How to convert two columns into one column of CSV?
Try opening your CSV file in notepad. Does that show the data how you are expecting?
Dec
27
comment How do I tell MS Excel to use the non-standard decimal separator in graphs and charts?
I don't think that custom formatting can change decimal separators.
Dec
27
answered excel equation to find corresponding value
Dec
27
answered Excel Number Formatting - not to be carried into copied cell
Dec
27
answered Grouping Excel graph categories
Dec
18
comment Why Excel doesn't ask(prompt) to Save the file which is modified while closing
I have a feeling it got downvoted because you failed to mention in the question that you had code at all, let alone code that got rid of alerts. Or, that it may be a duplicate as indicated by another comment on your question. Always going to get downvotes if there are other questions out there with answers. Part of the SuperUser experience is that people really like those who have done homework and ask specific questions rather than present very vague issues.
Dec
18
comment Why Excel doesn't ask(prompt) to Save the file which is modified while closing
There is a method to return them to normal. You reverse your original code. There is no return all, because one person's "normal" is not going to be the same as another's idea of normal.
Dec
17
comment Why Excel doesn't ask(prompt) to Save the file which is modified while closing
Excel has a number of defaults built-in, including the display alerts. Once you code something that changes that default, it will not revert unless you tell it to. That is what you want to have happen. If it didn't work like that, programmers would have a difficult time finding out why their code wasn't working. Recap and General rule: if you turn it off, turn it back on (and vice versa). And don't forget to turn things back on, even when there is an error that stops normal execution of your code.
Dec
17
comment Is there a macro to filter table by some list elements?
If you are using excel 2010, you can set up autofilter, and it has a new text box option to look for the text you want (instead of just having the text boxes). So you can now type test1 and filter to all cells that have test1 in them. If you wanted something a little more user friendly you could record yourself doing that then use the resulting macro to create the options you are looking for.
Dec
3
comment How can I edit this macro to loop through the results?
Chip Pearson can explain this better than I Chip Pearson - Find All Function
Dec
3
comment VBA to sequentially number rows in column
Your code worked for me. What is it not doing for you?
Dec
3
answered VBA macro in excel 2010 32 Bit mode
Dec
3
answered Formula to search highest value related to a near match reference
Dec
3
comment Excel Combo box to filter a table column
Or if you are using a filtered table, you could use the built-in drop-down. It expands the list in the drop-down automatically based on what is in the table.
Dec
3
answered Dynamically updated floorplan/asset register in Excel