Forum Widgets
Latest Discussions
Cascading Data Validation 3 level dropdown list with reoccurring text
Good day, I want to make a 3 level cascading dropdown list but the 3d level is not working. My idea is to make a budget tracker from 2 banks (Level 1) from which each bank has 3 accounts (Level 2) and each account has a different currency (Level 3). The problem arises when different accounts have the same currency. The system does not seem to be able to read it and returns a blank dropdown. Is there a way around it? attached is the link to the file: Excel questions Feel free to reach out if there are any questions. Thank you in advanced
Is there a formula / function for displaying the "Name" of a reference cell?
I am trying to see if there is an Excel function to display the "Name" of another cell. I looked through all of the options using the =CELL() function (there are many) but none seem to return the "Name" that I have given the cell. I have used reference names in several places within my spreadsheet to simplify formulas and make them more readable, but I would like to have a dictionary of these referenced inputs including what each one is named in a separate tab. Any pointers are appreciated.Keep a number as "General"?
How do we keep a column of numbers as type General? For example, I have column L. I highlight column L. I set type of the entire column L to General. I go into several cells in column L and confirm that they are type General as I had set them to be. So I enter a general number into my cell that I set as a general cell. Excel decides that, no, what I really really want is for that cell to be set to Accounting which means that the cell displays ###### unless I widen it, at which point it becomes a dollar figure. But I'm not dealing with dollars. I'm dealing with general. Which is what I had set the column to be. So I have to go back EVERY TIME I enter data into a cell and switch it back to General which is what I already set it to in the first place. This would make some sense if I had entered 1/17/2025 and it decided to change what I told it (General) to a date, even though I had already told it that I want it to be general and therefore display the '1/17/2025' that I had entered. But if I enter '10230' into a cell that I had specified needed to be General, Excel should not decide that I wanted it to be $10,230.00. I did not. How do we prevent Excel from overriding our settings?Dynamic LINE CHART for data with expanding SERIES AND DATES
Below is a sample of 5 tech stocks quotes for the last 30 days that I pulled via STOCKHISTORY function. From the above data I need to create a TREND (LINE) CHART that starts with 100 so I can compare price performance across stocks under the same baseline. The problem I have is: the above sample covers 5 stocks over 21 market days, but on my real world that stock list may grow/shrink depending on an user's watchlist, and same thing goes with the dates span, which may grow/shrink as per the user's choice (i.e.: 1 week, 1 month, 3 months, 1 year, 5 years, etc.). So we're talking about a 2-dimensional dynamic data array, and we all know that if I plot the chart just by highlighting the table and picking the chart type, Excel will just assume that static data array I had selected. Which means every time this data grows either horizontally (additional series) and/or vertically (larger dates span) the chart will just miss out on those new items. And in case the opposite happens the chart will just show empty series and/or an empty space on the horizontal axis. I already know the work around that prevents that from happening as far as DATES go, by setting up formula names for each data column spilled-range formula and putting them in place of each respective static data array for each series (since Excel chart STILL WON'T WORK WITH HASH REFERENCES - GO FIGURE!!!), as shown on the screenshots sequence that follows: 1D spilled range formula on row 4 for every column: Formula names created for the dates series and each stock trend data series: Chart series getting plotted via named formula: The above approach does work great, but only takes care of growing/shrinking date spans though. So I went ahead and created a 2D spilled range formula array as you may have already noticed at the above screenshots located on the right trend data set and named it "xALL". And then I tried to tweak the chart I had created using the 1D approach, got rid of all data series except one, and then switched its formula name to the 2D xALL named formula: But as I was expecting, line charts work only with single rows/columns, so I keep getting this error message: And then I thought: why not consolidate the entire tabular set (headers + date column + data series columns) with one single 2D spilled range via INDEX (named "xyALL"), highlight it, insert the line chart, and then replace the whole data set with this new named formula? Initially the plan seemed to work fine... But then when I checked whether Excel had converted that dynamic span into a static array, low and behold, after all Excel's smart but not THAT smart! And every time I go to the 'Chart data range' box and try to replace the static array "$N$3:$N$24" with the dynamic named formula "xyALL" Excel will just convert it back to the static range: And when I try to edit the SERIES references directly on the formula bar by replacing with the named formulas, I get the same expected "I can only take single row/column" error: So, now I'm stuck in neutral... Is there actually a way to do that? Would a pivot table/pivot chart approach do the trick here? I'm not that well versed with pivot tables and I guess that would require some advanced knowledge I currently don't have in case it can be done via such path. Thanks in advance for any help on this one! LeonardoExcel Sum
Hello to all the community! Excuse me if I make a question for a so simple problem, but I cannot resolve it by myself. I have a list of cells with values like 10 + 1, 6 + 1, 5 + 2 etc... A B 10 + 1 5 + 1 6 + 1 TOTAL I would like to sum them, but it is like Excel does not recognize them as values, because of the "+". There is some way to do it? Thank you very much!
IFS or anyother function
Dear Experts, I have a data like below:- So, Column "B" - sfn can go from 0 ~ 1023, and Column-"C", can go from 0~19, Column "G" has 3 values(rnti's) - Now, we have only 2 situations like below in Column"E", where I need the formula:- Either all these 3 rnti's can be Multiplexed in the same sfn.slot So, in below snip all 3 rnti's are FDMed in same sfn.slot - 394.6 and should be continuous, so Column "E" should have fdm-3 But in below instance, in 395.2 we have only 2 rnti's multiplexed(so fdm-2 should be populated) Attached is the spreadsheet. Thanks in Advance, Br, AnupamReset form (Check boxes) Excel
Hello, I am looking into an option to reset all check boxes excluding the one already checked as this will always be ticked with the press of a button (Reset Form). I've looked around and it seems possible but I've not been able to implement it correctly. The template of the excel sheet is attached and any help appreciated. Thank you
