Search results

Love it. You're always awesome. Thanks very much mate.

Hello everyone! I'm looking for an Excel formula to generate a grid with 744 rows and 100 columns, where each cell contains either 0 or 1. The sum of values in each column should always be within a specified range (between floor and ceiling values as input). We can consider floor value as 200...

Thanks folks! I have got the dynamic formula. Just attaching here for reference.

Hello everyone, hope you're having an awesome day. Can you please help me with the dynamic formula that first displays active project names based on the switch (column B) against each project (column A) followed by inactive project names? Thanks very much in advance. Cheers!

Thank you so much. I need that to be dynamic so that it can pick any input data in the light yellow shade.

Hi everyone, Thank you for looking into this. I am struggling to find the dynamic excel formula to deal with capex replacement every 10 years. In the excel file attached, I have created an example where I have added some capital costs in year 1 and it's life is for 10 years. But then, trick...

Hi p45cal, Thank you so much for sorting this out.

Hi, Thanks. I am re-attaching the file with the desired results. In short, all the fixed costs and variable costs should sum up (year wise) in the Column C & D in the table 2 based on the criteria below. Criteria - The cost should start from the "From year?" column in table 1 and based on...

Hello Excel experts, Happy New Year! I need your assistance in solving a logic. Please find attached the file wherein I have two tables, top one is the input and the one below is where the results should populate (dark yellow shaded cells). Table 1: Column B - Cost description Column C - Cost...

Hi, I need your help in calculating the breakeven point for every year i.e., say my timeline is of 5 years from 2023 to 2027 and I have an input variable as revenue growth % rest assumed all the inputs are fixed. Using data table or some other way, I need to find out the exact growth % for a...

Hi Excel folks, I have attached an excel file wherein I need your help in deriving the formula to find the lane for parking the truck as per their respective activity. Row 31-36: I have explained the context Cell F14-F29: The desired result I am looking for Cell E14-E29: This is where I need...

Thanks Alan and vletm. The range is not fixed (no. of rows may increase/decrease) and the data gets updated on a frequent basis. That's why looking for a dynamic option for this.

Hi everyone, I have attached the file wherein I required your help in extracting the specific data as a list in the data validation. Is it possible? Thanks a lot.

Hi all, Can you please guide me on how to add a custom tooltip for excel charts? Is there a way by which one can edit the "Hover text" of a data point of excel charts? Thank you.

I am trying to protect a workbook using a macro. The macro activates the Userform which asks the user to put in the password. As soon as the user puts in the password, the hidden sheets of the workbook gets visible. I have written this macro in "This workbook" using Sub Workbook_open and...

I have a simple line chart but the values/numbers used in the chart in the X axis are not to be displayed instead I need letters (which is mapped against those numbers in X axis) has to be displayed? Is there any way to do this? Thank you.

Thank you @pecoflyer. I had a look into this. The data I am dealing with is very long (many industries and companies) and couldn't able to accommodate this type. That's why I was looking for another option to deal with it. Please let me know if you can suggest some other solution for dealing...

Many thanks @herofox. On the whole, I think dynamic drop-down is possible only when the data is altered/modified.

Hi @herofox thank you once again. Drop-down for Industry works perfectly fine, but the companies list is not appropriate. Example, if 'CEMENT & CEMENT PRODUCTS' is selected under Industry, the list in the company shows ACC and Adani transmission rather than ACC and Ambuja cements.

Hi @herofox, thanks for your quick reply. This is not what I meant. I need a unique list in cell F1 - wherein it should list out all the industries (without duplication) and in cell G1 - it should list the dependent companies. For example, if "POWER" is selected in F1, G1 should list only the...

Hi everyone, I hope everyone is keeping safe from COVID. Please find attached the excel file wherein I need your help in creating drop-down list from a set of data in a conventional method. PS: 1. Since my client is not having Office 365 or recent versions of Excel, so can't use dynamic array...

Yes, you can give conditional formatting along with the data validation.

Hi, It looks like you are calculating Year-To-Date payments, try the below formula and copy it across: = SUMIFS(Detail!$P:$P, Detail!$D:$D, $C$4, Detail!$F:$F, ">=" & $D$3, Detail!$F:$F, "<=" & EOMONTH(D$3, 0)) / 12

Hi all, Can someone help me with the vba code to copy and paste the exact formula in the cell(s) including the borders, format, conditional formatting? Thanks in advance

Paste the below formula in Cell F9 and copy it across till Cell N9 and check if this is the result you expected: = SUMIFS(Detail!$T:$T, Detail!$D:$D, $B$4, Detail!$F:$F, ">=" & C$3, Detail!$F:$F, "<=" & EOMONTH(C$3, 0))