Last 50 Posts on Chandoo.org

Chris Brown on 2022-06-29 10:01:31
Thanks so much for this, it's brilliant! I think it's almost there - I've actually followed the steps on the example linked in my post. I just can't get it to filter properly; it just returns 0 when I add a date into Cell O2. Should I be doing it differently?

Richarder on 2022-06-25 14:39:10
everyone, this is such an informative and important pos nice

John Lewis on 2022-06-25 04:42:04
.I am unable to write a macro to run that automatically. My Excel version (I suppose) also does not allow the refresh flag.

M.G on 2022-06-24 21:03:02
Came across this old thread, excellent by the way, my question if can you or how do you chart Cartesian results? Thanks

Marc on 2022-06-22 14:55:50
Update: I used a function instead for the timestamp Function EcritureDeDate(Reference As Range) If Reference.Value "" Then EcritureDeDate = Format(Now, "yyyy-mm-dd") Else EcritureDeDate = "" End If End Function The problem I have is each time I open the excel file, it will not keep the original timestamp; it will update. Any way to fix the situation? Best regard,

Marc on 2022-06-21 15:46:40
Question regarding those function. When I try to enter those function in the cell. Excel indicate I cannot use it since it detect a formula because of the = like it want a 1+1 =2. I don't know why I cannot write in the cell that formula =IF(C2" " ,NOW() ," ")

yuvraj on 2022-06-17 08:58:11
Hi I need a vba code for ALT+J T I D for give a range for pivot table

Ashvin on 2022-06-16 09:33:29
Hello Chandoo, Can you please send me a message in my email. Instead of day, what If i want to do it on a monthly basis. Is there any possibility ? Please let me know. Thanks Ashvin

Manny on 2022-06-12 13:04:05
Hello: This may be more than you asked for, but... I started out using Spyder, tried a couple of other IDE's , including Visual Studio, but have continued with Spyder. I started out with Anaconda, but lately it has been giving me fits, so I installed a stand-alone Spyder with python, until I figure out which way to go. I've also began using Google Colab. I primarily use python to track my stock portfolio (download stock prices and create charts), and to do some analysis on potential stock purchase opportunities. I can't invest like the big guys (I buy Schwab slices). I have also dabbled with AI/Machine learning. To be clear, I am a hobbyist. but I can generally apply to my projects, the techniques, expertise, and the code posted on-line by the professionals, including GitHub. P.S. I've used spreadsheets for my work and personal life for more than 25 years, and even today (I'm mostly retired), I use spreadsheets almost every day, and though I haven't begun to delve into it, I see where LibraOffice is integrating python too.

Hui... on 2022-06-12 03:17:27
@Kaz Glad you like the post Can I please ask that you post a new Thread in the Chandoo,.org Forums: https://chandoo.org/forum/ Please attach a sample file and I will review from there

Piecevcake on 2022-06-12 02:24:55
I've created a macros ribbon, but it is only showing icons for the 36 macros! How do I get the list to show the macro names please?

Kaz Kowalski on 2022-06-09 17:14:31
This is excellent.. although I have got things wrong!! I have a slightly different where I have for ever month actuals and forecasts. Trying to draw the graph with the distribution of both. I can create all the lists and can create the rows, then i can reference the whole series to create the chart. The series ought to be dynamic - ok so if i have 10 columns or 12 columns it should work. But I can not get it to work by using the subset list name, have to select the whole range... Very confused, any ideas?

David on 2022-06-09 14:14:14
Sounds like we are looking for the same. I have a range of 6 digit sequence numbers (start to finish). I am looking for possible encroachments throughout the series of cells. For example: L M 921499 929696 919798 920578 920578 921450 <<In this example, 921499 and 921450 would show up as an encroachment as it does encroach the range of numbers in the top set.

Hamna Javed on 2022-06-08 09:20:27
A deposit of Rs. 6000 in a Bank account earns interest 5% compounded monthly for four years. How much amount is accumulated in the account after 4 years? A 55-inch segment is divided into three parts whose lengths have the ratio 2 : 4 : 5. What is the length of the longest part? Suppose that you establish an IRA (Individual Retirement Account) at age 43 and you will retire after 22 years hence at age 65. You plan to make annual payments of Rs1000 into the IRA at the beginning of each year. If you assume a rate of return of 8.5 percent a year, calculate the future value of your IRA when you will retire at age 65

Karishma on 2022-06-04 13:18:44
=MONTH(A1)&YEAR(A1)=MONTH(A2)&YEAR(A2)

SIVA on 2022-06-04 05:55:27
I am actually working on work progress timer for customer information. whenever i enter customer details on each column in excel the count down timer has to start and it has to be removed from the list once the count down timer stops. please guide me on this. i can able to create in single column i want atleast 15-20 column's at a time.

Jyo on 2022-06-03 14:41:40
I am getting the error of reference isn't valid. What is the reason for that? I have tried using both the functions, Xlookup as well as index-match.

Jyo on 2022-06-03 14:31:49
I have the same doubt. Could you please answer?

Miss Fig on 2022-06-02 22:58:20
More of these please! Fun challenge and enjoyed seeing how you & others solved it.

Nikhil on 2022-06-02 16:16:54
What if i need to have image lookup for set of 10 images across atleast 100 records to show create badges earned bashboard

Craig on 2022-06-01 23:23:09
I have a list of work orders with different line numbers that have individual statuses. I am trying to return a list of all work orders (no line numbers) in which ALL line numbers share the same status. I have tried to use filter and no luck. I have tried to use xlookup to simply return the work order if all work orders have same status. I cannot figure this out. Any help? tried =xlookup(wo#,wo#=@wo#*status="d",wo#,"",0,1) and it is not giving me the result

Jennifer Jeffords on 2022-06-01 17:12:43
Chandoo, I am having trouble with XLookUp. How do I get it to return multiple values such as employees with salary greater than $45,000 or to sum all the sales in the East region? Are these more pivot table inquires? Is XLOOKUP more useful for finding one record than multiple records? Thank you, Jennifer Jeffords

Kavita on 2022-06-01 13:36:17
Thanks for all your help with Excel tips.

K Store on 2022-06-01 11:57:10
Good information was shared, thanks for this.

Chandoo on 2022-06-01 08:08:45
See this... https://chandoo.org/wp/state-migration-dashboard-contest-entries/#option_37

Roger on 2022-05-31 01:02:34
Is there a way to have the points line up on a worldmap, and show instead of people the relationship mapping between countries?

Maggie on 2022-05-30 20:39:34
How many excel files in a folder can power query combine into one dataset.

Josy on 2022-05-30 16:16:05
This is another amazing Excel tutorial! My question is about slicers. How do you add slicers to this matrix? Please advise

huho on 2022-05-27 13:42:11
Hi, I normally use Spyder. It come with Anaconda and is pretty straight forward. Currently I'm coding more and more in Python, building simple workflows and let it run via an ubuntu machine. I have automized already monitoring tasks which alert me if something goes wrong or is anomalic. Python simplifies and enriches my job!

Federico on 2022-05-27 08:05:18
Your first method with the index column already produces duplicates because it evaluates each row independently from all the others. Now is it possible to have a column of random numbers without repetitions?