Hello all. Not new to Excel but now in a position where I really have to step up my game. I have attached a screenshot and here is what I am trying to do. The screenshot is of a weekly / monthly expense tracker and I need the data in certain groups of cells to automatically populate another group of cells. Cell E10 and below has a dropdown list and my options are my 3 GL codes. Cell H10 and below has a dropdown list that contains the number of weeks in a month 1-5. On the top of the page the 3 GL codes are listed and each have a weekly and ultimately monthly budget with the actual costs and th ..read more

I feel like there are a hundred simple solutions to my problem but I can not come up with any!! I have a table full of patients and their Primary Care Providers. Some providers have 100 patients, some only have 30. I want to be able to select only the first 30 patients for each provider and make a new table. One solution I thought of was to create a column that numbers the patients from 1 to N and then starts over when it gets to a new provider. For example, if I could go from image one (no index column) to image 2 (index column that starts over when it gets to a new provider), I would be hom ..read more

I think I input all the related cells and set up constraint and a right solving method, but it keeps failing. I want to get max profit using Solver function. Does anyone notice the issue here? Appreciated a lot...:) Attached Images 2024-04-26 17;29;10.JPEG‎ (80.2 KB) Download Attached Files Book1.xlsx‎ (11.0 KB) Download ..read more

How can I solve the SE formula when I don't there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance. Can you solve this problem? Attached Files Pasta1.xlsx‎ (10.7 KB) Download ..read more

Hi All, I recently posted a question that worked using a smaller dataset, but when I applied the formula across a larger dataset, the formula is giving me #calc! empty array error. Original Question here https://www.excelforum.com/excel-for...ml#post5944143 Summary I have an audit table that records the change to an account's information, and records each change as an audit record on the table. I need to look up the most recent datetime and street1 address for the account only when the street1_updated column is True for the cust_id's I am interested in. In the example dataset below, I would ..read more

Hello, I'm having trouble getting a power pivot measure to return 0 if the column is blank. The measure I'm working on is adding three columns together. I've tried playing around with if(isblank(calculate(sum...... Is there something better I can use? Two of my columns will sometimes have nothing in them which is what's currently causing my attempts to error out. I've hard coded zeros in one row for each column and that is enough for it to work but I'd rather not have to do that since I'm not the end user of the file. TIA ..read more

I am not sure why this is not working properly. I would like to mark when players sign up with an X. I would then like to make the teams as even loaded by skill level as possible. TEAMS.xlsx ..read more

Hi All!! I am trying to get Sequence numbers in Col I based on Columns B, D, G. However, I am unable modify my formula: Formula I am using is Formula: =IF((D3=D4)*(G3=G4)*(TEXT(B3, "DD-MM-YYYY")=TEXT(B4, "DD-MM-YYYY")),J3,IFERROR(LOOKUP(2,1/(D$3:D3=D4)/(G$3:G3=G4),J$3:J3)+1,1)) With the above formula I am getting as in Col J. But Column I is what I am desiring to get. Please see the attached sample workbook. Any help would be appreciated. Attached Files Test.xlsx‎ (10.9 KB) Download ..read more

Hi, So basically I want only a certain number of columns and rows to be shown in the workbook. For example, I want no columns beyond Z. I would select column AA and ctrl+shift+--> and hide. NO, I am looking for a more sophisticated solution. I tried "Developer" tab and scroll lock too but that creates other "Document Inspector" issues. I last time did it very easily that my workbook would not show rows beyond a certain row without doing anything super crazy. Just can't find out how in version "365" Any help is appreciated. Thank you. Khurram Khan ..read more

I have been trying to lock out rounded bars that I am drawing on a worksheet in VBA ... I simplistically (and wrongly) thought that the ".locked = True" in the code below might but nope. This might be a simple 'not possible' question but ... is there a way I can lock an inserted rectangle in VBA so that the user cannot manually select it (or at least cant drag it about or resize it)? For context, the bars are drawn based on two cells being populated with times with a worksheet event drawing it when both numbers are not blank. There are multiple bars drawn (named after the rows) but they are n ..read more