dynamic

Good day everyone, I've searched several forums but couldn't find an answer to my question. Maybe it's not even possible in Excel but we'll see... So, I've got my table with three columns Region, Shoe Size and Sales. What I want to achieve is to create a Top N list of shoe sizes and their...

Hi all, I found formulas to calculate the fiscal year, but I'm trying to figure out a dynamic formula that will calculate if a date is within the current fiscal year (fiscal year for me starts in August). For example, I would like the result to show the following for these dates...

Hi, I have the following formula which is inserted on sheets through VBA code: =SUMPRODUCT((B3:AF3="AD")*(WEEKDAY(B2:AF2,2)<6)*(ISNA(MATCH(B2:AF2,HolidaySheet!A2:A3,0)))) The A2:A3 range contains two holiday dates which are on a separate worksheet. The holidays change depending on the year...

Hi! I'm looking to create a chart with multiple lines, each one representing a different day's worth of data. As I add more lines, I want the newer data to be shown in a different color as the older one, forming a gradient among the lines that makes it clear which data is more recent. This could...

Hi alll, Just coming up with a difficult problem at the moment. Trying to SUM forecast data in a Range, but using unique variables to decide what that range is. Forecast Sheet is as follows; A2123456 Stock Sheet is as follows; F25 We want to be able to see based on the Date stock goes...

Hi, I have a data table of financial securities, each item(row) corresponding to a certain country/region of issuance. I would like to have that table filtered automatically to show only those securities issued from a specific country and region selected from a dependent drop-down list...

VBA newbie here. I'm starting with a single workbook that has 2 sheets. With this, I'm trying to figure out code that would accomplish the following on execution: Create an Array with n elements, where n is the number of Unique Strings found within the Cells in Column B (excluding B1 and...

Hello, I'm looking for a macro that will dynamically change the comments attached to a range of cells (entering the results from the formula in the cell), triggered by the change in value of another cell. Specifically... I'm looking for a macro that will be triggered by any changes to the...

Hello All, So basically there are several KPI's where the 'Target' Value can vary on a Month by Month basis. I would like to create several Conditional Formatting scenarios that highlights it as Green, Yellow, Red and Blue based on how close the ACTUAL figures are to said Target. At the moment...

Need help to create a macro to extract the following data (highlighted in green) from Multiple Worksheets onto the Summary sheet: Month of Report onto E1 Date of Report onto E2 Carpark ID on column D Carpark ID + Lane ID onto column E Percentages for Hourly, Season Parking and Total on column...

Greetings, I have a dynamic chart in a dashboard that changes based on what year I select. Some of the items have no data for 2021 but has data for 2022. How do I hide the line items by year which currently has no data?

Hi Power Query gurus out there! I'm going to do my best to explain some help that I need it replacing values, conditionally based on another column's values, while dynamically referencing field names. Here's some sample data: Date Greeting Appreciate Patience (if hold was used) Resolution...

Basically, I want autofill to skip reference columns at a static rate. I have the formula "=SUM('FPY Data'!K5:K54)-SUM('FPY Data'!L5:L54)" in column E. When I drag autofill across column F is "=SUM('FPY Data'!L5:L54)-SUM('FPY Data'!M5:M54)" but I want it to be "=SUM('FPY Data'!R5:R54)-SUM('FPY...

ABCDEFGHIJKLMNOPQ1Sheet 1Sheet 2Sheet 32Account No. & Account NameDateCounterpartyTextDebitCreditAccount No.Account NameBalance (Debit)Balance (Credit)DateAccount No. (Debit)Account No. (Credit)AmountText341200...

Hello, I have an exported, filtered list of results (not a table) where one out of two rows (the second one) describes the first one. Now I'd like to select these pairs of rows dynamically in order to format their borders, among other things. I'd like, for instance, to give the impression of...

Hi, I have spent hours and finally got the multiple lists to work dynamically in the ListBox. But for the oddest reason when i click on an "option" the box moves way over almost out of the form. It still works perfectly but it is visually unappealing. See the attached screenshot before i...

Howdy dear Excel specialists, This is my first time on any Excel forums. I've tried to look at other threads before posting this one, yet I don't seem to be able to apply it to my own situation, nor can I understand a thing of that VBA witchcraft. So I have this main table that regroups all...

Hi. Am confused here. I would like to create a data validation drop down list that when one of 4 things are selected, it brings up another list, select an option and bring up a final list. Example: Drop down list one would have Region 1, Region 2, Region 3, Region 4. By selecting Region 2, it...

I'm trying to get better at this and in doing so, I've seen over and over again to stop using .Select and .Copy/.Cut to move things I know I can move my columns with copy and insert no issue, but I'd like to step into the next level. On one ws, i've got columns P to AB and need to move them to...

Hi Everyone, I have attached a spreadsheet and highlighted in yellow the column K I would need to be filled with a formula (spill formula only so that it is completely automated). Column I and J: This is a spill formula using Unique, Filter and Choose function. Column K: I would need a spill...