Reputation
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
1 11 24
Newest
 Yearling
Impact
~938k people reached

1d
comment Ms excel while entering more than 15 digit no
Did you copy the text from the other question? I can't believe you came up with exactly the same wording of three paragraphs more than four years later. You have seen the other question, so why ask the same thing again?
1d
comment Formatting any cell referenced in a Formula
Well, yeah, you changed the question completely days after my answer. Talking about moving goal posts.....
2d
comment highlight birthday in a referenced cell
That conditional formatting formula cannot be right. B1 contains text, not a date, so the formula will return an error. It should refer to A1 instead of B1. Please check and update your question.
2d
comment highlight birthday in a referenced cell
Not in 2003, you can't. CF in 2003 can only use references on the same sheet or in named ranges.
Feb
4
comment fix for unhiding column in Excel has stopped working
Possible duplicate of What's the keyboard shortcut to Unhide a column in Excel 2010?
Feb
4
answered Excel Index Match - How to use iferror / indexmatch
Feb
4
revised Excel Index Match - How to use iferror / indexmatch
added 68 characters in body
Feb
4
answered EXCEL: Can I get a count of a certain value from columns with certain headings, only from the columns with certain text?
Feb
4
revised EXCEL: Can I get a count of a certain value from columns with certain headings, only from the columns with certain text?
added 60 characters in body
Feb
3
comment Extract multiple substrings from Excel cell
Are the codes always the same format, like xxxx-x-xxxx? Can you post a bigger data sample? Are you open to approaches involving VBA or Power Query?
Feb
3
comment run time error 1004 method open of object workbooks failed
ah, from existing was dropped in 2013. Use Windows Explorer to find the xltm, right-click and select New to create a new file from template. That will prompt the "do you trust this file" blurb and you can hit the button to trust. If that helps resolve the macro problem, let me know and I will post it as a proper answer.
Feb
3
comment run time error 1004 method open of object workbooks failed
What happens if you open a new file based on that template via File > New > from existing? What happens if you add the folder to the trusted locations in Trust Center?
Feb
3
revised Speed difference between ISNUMBER() and COUNT() when searching for substrings within text
added 67 characters in body
Feb
3
comment Speed difference between ISNUMBER() and COUNT() when searching for substrings within text
If you want to meet Charles Williams and learn about optimising spreadsheet performance, hear about lots more interesting Excel topics presented by lots more Excel MVPs and the Microsoft Excel developers, consider attending the Excel Summit South conference in Auckland. There are also sessions in Sydney and Melbourne, but why go there if you can have it in NZ?
Feb
2
answered Formatting any cell referenced in a Formula
Feb
2
comment Conditionally centering text in an Excel formula
What's with the + ?? Why do you use that if you are not adding anything? Excel does not need that. Get rid of old Lotus 123 habits and save thousands of characters.
Feb
2
answered Speed difference between ISNUMBER() and COUNT() when searching for substrings within text
Feb
2
comment Sorting and separating by category in creating a macros
why don't you use a pivot table?
Feb
2
comment Paste as image adding extra padding inside image
I can't repro that. Please post a screenshot of the problem. Think file sharing service and post a link. Edit your question and post the link there.
Feb
1
revised Paste as image adding extra padding inside image
added 108 characters in body