Search results

A simple option is to sort your list on column A (the number) and then use concat for each of the numbers one time. You can even pass an OFFSET range to CONCAT udf so that it would just concatenate all the items with 1 and give output.

@David... Welcome to chandoo.org and thanks for your question. Please take a minute to explore our forums to understand how we help you. You may also join our newsletter to get more. http://chandoo.org/wp/subscribe/ Regarding your question, to set CF use below steps: 1. select A3:G3, goto...

Hi Lili429, Welcome to Chandoo.org forums and thanks for your question. Please take a minute to explore our site and learn more. I also encourage you to join our newsletter so that you can continue to learn. Regarding your question, I suggest checking out these pages...

Welcome to Chandoo.org forums Smurphyatl... Thanks for your question. Take a minute to explore our forums and get to know us. Regarding your question: There are a few reasons why this could be happening. 1. Did you accidentally turn off Automatic formula calculation? If so, go to...

If you just want NOW value to be selected all the time: Then why use drop down box? Just put now in a cell and you are done! If you want NOW to be one of the values for the drop down Then in your source range, replace any one value with =NOW() formula.

@matthew... You can sort by clicking on row labels > More Sort options > Descending order > and picking corresponding measure. See this image. http://img.chandoo.org/pivot/power-pivot-more-sort-options.png The idea is same as how you would custom sort pivot tables...

If I am not wrong, there is a progress bar active x control. You can use that to show progress. And in your main macro you can update it as the progress happens. You can even do the updates asynchronously using timer etc.

Hi watzupmark Welcome to Chandoo.org forums and thanks for your question. As Bob suggested, using a pivot is easy and quick option. If you insist on using formulas then follow below steps. 1. In Sheet 2, in an empty cell (say A1) write =MAX(Sheet1-date-range) This will give you maximum...

Hi SP... I guess Tally will have to wait. We are starting 2 courses - PowerPivot & MS Access in January 2013.

Hi all.. Merry Christmas & holiday wishes to you :)

@Amit... Welcome to Chandoo.org and thanks for posting your question. Please take a look at our forums home page and sticky threads to understand our rules & policies. Regarding your question, If you just want the very first quarter start date (that is for all dates between 2007 and...

@Getco... Welcome to Chandoo.org forums and thanks for your question. You can use LARGE formula for this. try =LARGE(b1:m2,2) to get the second highest value.

Hi Avnsh22... Thanks for your question. Before replying let me suggest you to not use the CAPS LOCK key. IFYOUTYPEEVERYTHINGINCAPS IT IS VERY DIFFICULT TO READ! I tried to come up with a formula solution for this, but found it to be too complicated. So I wrote a small macro. See this file...

@Rory1111... Welcome to Chandoo.org forums and thanks for your question. Please take a minute to explore our forums and see what is already available. You can start by reading the sticky posts on the forum main page - http://chandoo.org/forums/ Coming to your question: You can do this using...

As far as I know, this is not possible in Excel pivot tables. But there is a workaround. First create the pivot table with one row field (in your example, the pivot is already like this) Then in copy the entire pivot, paste it else where as links (ie create references to values in pivot)...

Regarding your Once you are in the edit mode, press F2. This will let you use arrow keys to move around the formula.

Interesting question... I would go with sumifs if index match sumproduct iferror countifs workday edate mid

Hi Mohan... Thanks for your post and welcome to Chandoo.org forums. Please see this page to understand how to split your data. http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/

Hi Rogcoy, You can use Worksheet_SelectionChange event to handle this. First select your entire Year...Finished table and give it a name like myList. Then right click on the sheet, view code. Now select Worksheet from drop down and VBE will create selectionchange event by default. Then...

Now that we have 5 people with 1000+ posts, it may be a good time to open up the data and create some nice excel visualization. If anyone is game for this, I can post a dump online (sanitized and anonymized of course).

Congratulations Faseeh... Wishing you many more thousands of Excel Awesomeness.

Thank you Hui... :) It took me almost 40 months to reach here. At this rate, I can reach your current level, just after I turn 50. Not bad :D Thanks Sreekhosh...

Hi Ahhhmed... In your example file, in K2 write =IF(B2<>"",1,"") and then fill the entire range. This should give the output as you want.

Hi PDS, Welcome to Chandoo.org and thanks for your question. You can use MATCH, INDEX to do this. In A2 write, =INDEX(sheet1!A1:A3,match(A1,Sheet1!B1:B3,0)) This will find the large result in A1 in Sheet1 B1:B3 and return corresponding value from column A. For more on this, refer to...

Vanakkam Chennai readers..., I am going to be in Chennai (India) from this Sunday (25th November, 2012) to Next (2nd December) to conduct some inhouse training with Renault Nissan. Since Narayank is in Chennai, I am planning to meet him anyway. But I thought..., "Why not have a meetup at one...