Last 50 Posts on Chandoo.org

Riya on 2021-09-16 13:30:32
This is a fascinating article. This is my first visit to this site. I discovered a lot of fascinating information in your blog.Thank you for sharing article! Check out latest trend- latest boat neck blouse designs 2020

Neel on 2021-09-16 12:12:44
Thanks for sharing. It's very useful.

David on 2021-09-16 07:52:19
Hello, You are learning new things everyday. This is the best part of you. I like reading your blog. Thanks

Jr. H on 2021-09-14 20:38:08
Dear Chandoo, How do we select multiple amount of tables/pages in one PDF and repeat the same for rest of the PDF;s in the same folder and then extract that data only on power query. Thank you

Nicolas Warkotsch on 2021-09-14 11:11:44
Hi Chandoo, thank you very much for this easy-to-understand tutorial. I only face one problem: when I select a folder via data/new query/from file/from folder the navigator window does not open but I am led directly to power query with no possibilities to click combine, transform or load. When using the other data sources (from workbook etc) everything works well. Do you or anybody else have an idea to fix this problem? Best regards

Melvin on 2021-09-13 11:48:07
Hi!! CHandoo Amazing piece of work. It takes lot of courage,Knowledge,humanity and indeed lots of wisdom to come up with some stuff like this. I am sure personally, there is huge room for things to scale beyond but the journey has begun and i feel elated to be a part of this journey. keep up the good work sir.

M.Shiva Kumar on 2021-09-13 06:20:33
Hi Chandoo, I am a 66 year old man and I have a rudimentary knowledge of computers. I was able to follow your tutorial on PQ and now I am trying to do some exercises. I sincerely thank you for this tutorial. M.Shiva Kumar, Mysore, India

Nikhil on 2021-09-13 05:41:30
Hello Sir, I recently downloaded the excel and entered the Funds . I wanted to understand how to update the SIP month on month for all the funds? should it be done manually? Any option where according to the date given, the month on month deposit amount + the no of units add , automatically? am a novice here....so pardon me if i may be asking something out of context

Marton on 2021-09-13 04:54:32
Hey, I need to say that your content is really needed. Keep doing it and I wish you all the best.

Jayme on 2021-09-11 17:43:03
Us the Column formula in place of the 3rd argument will save you time when you want to bring in all data columns!

Emmanuel Jose Vasquez on 2021-09-10 19:59:35
I keep getting this error message in the pivot table: This formula is invalid or incomplete: 'The expression is not valid or appears to be incomplete. Please review and correct the expression. The following syntax error occurred during parsing: Invalid token, Line 1, Offset 14, ‘.

Joshua on 2021-09-07 12:04:46
Big grats on the 100k subs, i love all your classes and they saved me from headaches multiple times :D Keep it up mate !

Syeda on 2021-09-06 22:35:54
Hi Chandoo, Thank you for sharing such a useful information and it really help me to upgrade my skills. I watch your measures and Dax video on your, but unable to access this video. can you please give me access to view it. Apart from this I want to join the course as well.

Chaim Kalish on 2021-09-06 22:08:06
I’m trying to combine folder items which have different page ranges - but the exact same column headers - depending on the file. Any thoughts on how to set that up?

Qudsia on 2021-09-05 17:53:37
Hi Chandoo. Thanks for the solution. But, please clarify in Step#2 to name the two cells outside the range 'selRow' and 'selCol' using Define Name feature in Formula tab. Otherwise it sounds like you are just asking the users to make an assumption instead of taking an action. This is what's giving the 'object not defined' error for people (as it did for me). Unless those cells are named ranges, VBA doesn't have an object to work with to enter row and column numbers of selected cell.

nana on 2021-09-03 15:35:00
hello need help with formula.. we need to incorporate this three formulas to one formula SATURDAY FORMULA =IF($K2=6,($J2+3),$J2) SUNDAY FORMULA =IF($K2=7,($J2+2),$J2) MONDAY FORMULA =IF($K2=1,($J2+1),$J2)

Gaz Hall on 2021-09-02 11:06:57
Thanks for all your help with Excel tips. You've saved my life many times over!

Chandoo on 2021-08-31 18:25:58
Thanks for the detail Steve.

Steve on 2021-08-31 11:13:16
The international standard abbreviation for Million is capital M. NOT mn. You shouldn't make up your own terms. It takes away from any sense we have that you know what you are talking about. BTW, lower case m is milli or 1/1000. Lower case n is nano or 1/10^-9, or one billionth.

Jeffrey on 2021-08-31 03:52:37
Hi Chandoo?I have to process a lot of data every month. Thanks for your blog, I learned a lot of Excel skills. It saves me a lot of time.

ArunKumar Subramanian on 2021-08-30 11:46:23
Awesome Bro..

GraH (XL-in-G) on 2021-08-30 11:10:29
Here is a nice overview of differences in performance of different lookup formulas. Unexpected, but XLOOKUP is not always fastest. https://professor-excel.com/performance-of-xlookup-how-fast-is-the-new-xlookup-vs-vlookup/?amp#What_is_the_8220binary_search_mode8221_of_XLOOKUP

Lebo on 2021-08-28 13:50:39
Hi Chandoo, The risk map is a brilliant tool, and I wanted to the risk map to only show Open risks. How can I do that?

Kits on 2021-08-28 06:09:37
Nice post . Step -> 7. Repeat rows on top when printing, show table headers on every page - will be useful . Thank you.

Chandoo on 2021-08-22 06:53:29
Hi Saravanan... This doesn't work with Excel 2007. I suggest using an online tracker from a personal finance website.

Hui... on 2021-08-21 06:59:20
Thanx Mohemmed I Appreciate the kind words

annon on 2021-08-21 06:49:32
0.56

Gina Rosato on 2021-08-20 14:47:38
I have a combo chart listing four weeks of a month with a column for maximum attendance allowed at five campuses identified by columns. I have data in columns listing the actual attendance at those campuses for each week represented by lines. I am struggling getting the line to go directly related to the campus represented column for each week. Each actual line starts in the middle of each week. When I click on tick marks, I loose two columns on the far left. I am quite frustrated. Any solution or advice you can recommend would be appreciated. Thanks!

jose on 2021-08-20 09:57:27
Great tips guys! thansk for sharing. I have a follow up question on sampling. I have a table with large amount of data from diferent dates . is there a way to firlter the random selection to a timefrmae . for example, select a random sample of 100 entries chosen bettwen January 1st and january 31 of 2021. ? cheers

Saravanan on 2021-08-20 02:50:11
Hi Chandoo I am using Excel 2007 (I know its outdated, but not able to get the latest version). The MF tracker is not working and it says the below " Initialization of the data source failed. Check the database error or contact your database administrator. Make sure the external database is available, and then try the operation again. if you see this message again, create a new data source to connect to the database " Appreciate the help !!!