Last 50 Posts on Chandoo.org

Warren Hall on 2021-03-04 01:30:32
A simple way to manage headers and formatting for the new extraction page is; copy the headers to the second page on row one, column B, then, copy the data line two on the data page, mark the COLUMNS from start to end of the header on the extraction page, then paste-format which will correct all columns to the desired format. Very fast and easy.

Curt on 2021-03-03 22:31:51
I noticed 'Currency' as one of the Data Types. Can you tell me how to add that? I only have Stocks & Geo and currency is more useful for me. I checked the excel website and they didn't present currency as an option.

SY on 2021-03-03 14:35:56
HI Chandoo, Is there a way to only display filtered item. Once the list gets big, it's hard to see all risk. Kind regards, SinYen

Scott on 2021-03-03 08:06:45
Have you seen Grid? https://grid.is/ It takes embedding Excel calculations into a website to a whole new level.

Chandoo on 2021-03-02 21:06:28
Hi Samam.. You can use Filter by color option and it will pick up CF colors too.

Best Excel Tutorial on 2021-03-02 11:11:50
@Chandoo I like your point of view. Nowadays people add to many formatting to the sheets. Visibility hurts. Less but focus on more important icons is just enough. I support point of view. Good article though.

Saman on 2021-03-02 06:38:11
Hi, is there a way to filter cell colors based on conditional formatting results?

Saman on 2021-03-02 06:23:11
Many thanks for your perfect dashboards, hope update with new inspiring dashboards.

Roz on 2021-03-01 01:04:16
Jim uses the Monte Carlo Simulation in the Excel to play a game, he wins 56 out of 100 time, what is the probability of winning?

Sanjeev Kumar on 2021-02-28 02:51:12
Hi Chandoo, It is an awesome excel sheet to track my mutual funds investment. It works quite well for me, I have just added a pivot table for the creating report and easily tracking my total investment (SIPs, Lumpsum buy) for a particular fund basis. Thank you for creating such useful excel sheet. In the prsent sheet you have added a column for calculating the CAGR, this gives a return on yearly basis. I request to add the feature to see the overall CAGR (ie. XIRR) for a particular fund bought in SIP or Lumsump. This feature will make the your excel sheet more useful and versatile. Thanks in advance.

Milesh Patel on 2021-02-27 14:34:58
Nice information. Thanks for sharing the information.

Angela Huang on 2021-02-26 14:11:03
How use NUMBERCALUE in VBA? When I use Cost = NUMBERVALUE(...) I got compile error "Function not recognized" Thank you

VIKAS JAIN on 2021-02-26 11:13:45
9.30 PM INDIA??

Chris Fry on 2021-02-25 19:50:02
Thanks. That really saved me a lot of time!

Matt on 2021-02-25 17:22:21
This is great, thank you!

Megan Fairhurst on 2021-02-25 16:36:11
This is great when you only have 1 image to show but I need multiple rows of images and due to the cell referencing I would have to go in and create individual named references which would take just as long as copy & pasting the images in. Is there anyway to do this without locking to just one cell?

Andrew on 2021-02-25 12:26:44
I use the same as Andreas - however, it is always useful to see different ways of doing things. All useful tips and ideas, sometimes the simplest of things can make a big difference. I also looked at your tip for turning on/off the conditional formatting as an option - simple but very effective.

Will on 2021-02-24 06:44:45
9:30 PM IST

Will on 2021-02-24 06:44:14
11 AM EST (US time zone)

Will on 2021-02-24 06:43:26
should be 4 PM GMT (UTC)

Will on 2021-02-24 06:42:31
should be 11am EST

Stephen POWELL on 2021-02-23 23:54:54
Hello Chandoo, Please help me understand if the 11:00 (AM?) YouTube session on Friday is your local time in New Zealand or is it 11:00 AM in another time zone? If it's your local time then that would make it 18 hours earlier at 5pm on Thursday Toronto time for me (which works nicely!!). Thanks, Stephen

Pat on 2021-02-23 18:14:16
Please let me know what time the webinar will start UK time. Thank you.

Kunal Jain on 2021-02-23 08:19:10
What time is it on Friday? where is the button to see the time in my timezone?

Me Myself on 2021-02-22 02:04:26
Thank You!

Chandoo on 2021-02-21 03:39:13
Thanks Karl. Yes, I did watch the live on Youtube for that. Inspiring achievement indeed.

Chandoo on 2021-02-21 03:38:26
That is a good one Andreas. :)

Daniel Paul on 2021-02-20 17:01:28
Hi, How did you get the 'From Folder' function in Excel Power Query? I do not see this as an option. This example looks like Power BI, not Power Query. Right?

Andreas on 2021-02-19 10:59:59
Thanks for the nice tips. The formula for zebra shading in trick #3 can be shortened from =ISODD(QUOTIENT(ROW()-ROW($B$4)-1, 5)) to =MOD(ROW()-ROW($B$5),10)>=5 I use modulo like this =MOD(ROW(), 2)>0 for one-by-one shading since years.

Karl Gregg on 2021-02-18 17:25:01
Thank you for this useful and interesting set of hints for conditional formatting. Chandoo, I hope that you and your beautiful family have a productive and healthy 2021. Watch the NASA attempt to land yet another Rover on Mars today!