Last seen: Jun 25, 2026
@kayfesoutlook-com As @alansidman suggested, just keep values. But you don't need a formula firsthand then copy/paste values. Just enter 1 at the t...
@ads Can't tell what's causing the error. Perhaps change origin of the PDFs changed and they indeed got corrupted. Can you still load older PFDs tha...
@kayfesoutlook-com Indeed, serial numbers based on row number or something like "number above +1" will not hold when you sort the table or insert ro...
@retiredit Or use the solution I suggested earlier. Worked for me. Anyway, I can't help you with VBA. Sorry.
@retiredit Ah, yes! you can't use a formula to reference a chart series. What I would do then is use the indirect formula on a separate sheet for Char...
@retiredit Can you upload a file demonstrating what exactly you are trying to achieve?
@retiredit Which Excel language version are you using?
@retiredit Let's say the year 2025 is entered in cell A1, then you could use =INDIRECT(A1 & "!$E$3:$E$14") The other one would be similar. T...
@johavand I'm not saying it can't be solved. Just can't think of it right now. And perhaps you can scale down your problem to a pivot table that only ...
@johavand I see. To do it by material I can understand, but not for all materials together. Can't really think of a DAX solution right now, but if ...
@johavand Not sure I understand what you want to calculate. Your measure for the running total is based in [INVENTORY]-[REQUIREMENT] and that result...
@ralphol07 I carefully looked at your schedule and txt file but do not understand your intentions. Can you please indicate what results you expect a...
@bee The dates in September are all 02/09/2025. Change that to 01/09/2025 and it shall work.
@susanne You could use the formula below to return the 1st of the month after the current quarter end: =DATE(YEAR(D1),((INT((MONTH(D1)-1)/3)+1)*3)...
@bee Difficult to help without seeing the file. Can you replace any confidential info with fake info?