1. ### Welcome to Chandoo.org Forums. Short message for you

Hi Guest,

Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

Yours,
Chandoo
2. Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...

3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.
Last Activity:
Feb 19, 2017 at 10:17 AM
Joined:
Oct 12, 2011
Messages:
14,255
3,246
Trophy Points:
113

# NARAYANK991

Excel Ninja

NARAYANK991 was last seen:
Feb 19, 2017 at 10:17 AM
1. alexorfa
Hi Narayan,
I posted a question (answered) similar to Formula Challenge 002 (Sajan, 2013) to which you replied:
=IF(SUM(\$B\$2:B2)-SUM(\$A\$3:A3)&#62;=Threshold,SUM(\$B\$2:B2)-SUM(\$A\$3:A3),0)
I cannot make yours to work. 1) What is &#62; ? 2) Row 3 contains the result manually entered. How can it be part of the formula? I am missing something.
Thanks
Alexander
2. abdulncr
3. Kunal_21
HI..
I`m Converting PDF file in Excel format ...Is there any Excel macro for that ,,because daily bases i have to minimum 10 PDF ..Please suggest ..
4. Sanjiya
5. JPBPerth
Hi Narayank
I purchased the premium excel edition from Chandoo and wanted to know if I can order some custom updates? I'm looking to hold around 70 KPI [currently limited to 20]How can this be done please? and at what cost? Regards John
6. nkunni
Hi,
Mr. Narayak991, I always wait for your reply to any of the question asked in the forum. Your reply is always marvelous and descriptive to understand it well.
1. NARAYANK991
Hi ,

Thank you. I appreciate your compliment. Will try my best always.

Narayan
Dec 16, 2016
7. mouaffaq
Great Work Man :=)
8. HanSam
9. Richard_Fisher
Hi, I am hoping you might be able to help. I have a spreadsheet in which 3 of the columns have data validation (lists). Multiple users access this spreadsheet and overide the validation. Assume by pasting data. Is there a way that I can protect the validation while allowing users to enter data from a pick list?
regards, Richard
1. NARAYANK991
Oct 27, 2016
10. Raghava@rock
Hello, I was wondering if there is a way to run a macro whenever any workbook is opened? I know how to code a regular workbook_open event. Specifically, what I'm after is whenever a workbook is opened, to have VBA evaluate if workbook contains a specific sheet and specific value in that sheet in cell B5, and advise the user if the Sheet is available and cell value is not equal to "1234".
11. Chirag R Raval
DEAR SIR,
THRE ARE NEED TO PUT "SITE MAP" TO EXPLORE ALL YOUR WEBSITE'S ALL COVERD SUBJECTS TO QUICK JUMP ON PERTICULAR SECTION

I DEEPLY BELIVE THAT IF YOU PUT WHOLE IDEA OF YOUR SITE IN GRAPHICAL STUCTURE -CLICKABLE & REACHABLE ..LIKE FLOW CHGART....THAT MAKE YOUR SITE UNBELIVABLE SUPPER DUPPER
WHAT CAN YOU DO FOR YOUR SITE MAKE SUPER??

CHIRAG...
1. NARAYANK991
Hi Chirag ,

I am sorry but I am just a contributor to this website ; the owner of this website is Chandoo , and if you want , you can post this suggestion on his profile , which is r1c1.

Narayan
Oct 4, 2016
12. Aamir Islam
Hi, I want to hyperlink excel workbook with my presentation. pls suggest.
I am using MS-Office 2010
1. NARAYANK991
Hi ,

Narayan
Sep 17, 2016
13. Anand Sharma
want a help
14. Anand Sharma
hello sir
15. SSEK
Hi Narayan, Greetings, this is first time on this forum, this seems to be a great place to learn. Also I see you answer the most, so can you help me.
16. suresh kannah
Mr.Narayan

Need your help on a Macro sheet ,
will be a days work,Let me know if i can pay and get your help on the same.

Thanks
Suresh
17. Nabeel
Dear NARAYAN
you have solved my one problem, i need some more combination in numbers kindly help..
18. shaikh imran
This Workbook Is Actually Our Timesheet
i have a two drop down menu Month & Group and some data range inputs linked with month & group items. if i change the month or group the data is remain same for any selection i want to change this data range as along with the drop down list
2) I Want To Highlight Each names in the My Drop List items
Thank You
19. stef
20. stef
1. NARAYANK991
Hi ,

Narayan
Jun 3, 2016
2. stef
ohhh..sorry :) thanks again.
Jun 3, 2016
21. saepul bahari
Hello,

I create progress reports with macros that are used by our school.
.xlsb Original file format and I can not upload it on the forum. I have uploaded below

thanks
22. Pranay Vimal
I am trying to compare 2 inputs of different dates. I am creating a key for each entry on both the worksheets, combining all entries in a row using "&" (each row has about 50+ columns) and then trying to find out whether that key exists in the previous input or not. But the match function gives me incorrect results (possibly due to the length of the string in the key). Is there a better way to do it?
1. NARAYANK991
Hi ,

Please post this in the forum , along with a sample file.

Narayan
May 9, 2016