ideas

I have this formula: X6=SUM($BC$2:$BC$5000)/SUM($BA$2:$BA$5000) When I copy it to Y6 I would like it to read: =SUM($BF$2:$BF$5000)/SUM($BH$2:$BH$5000) So the culumn number should change 5 from BA to BF and BC to BH. I have tried with indirect but can't get that to work. Any ideas?

Hi all, I need some ideas for tracking the historical changing values. Problem Statement: Column H and I will be revised multiple times throughout daily maintenance of this sheet, however I would like to be able to keep historical snapshots of what the previous information was in these columns...

I was given a modest workbook (950 kb), and asked to optimize it. Aside from a few loan amortization tables, there is not a lot of calculation going on. There are well under 5,000 rows total - across all 20-25 worksheets. But the calculation speed is VERY slow. You click "CALCULATE" in the...

Hi Experts, please assist: I need to populate a grid (yellow cells B2:C3) which picks up Grand Totals for Budget and Actuals by Month by finding the correct data from a PIVOT TABLE which can be seen here: https://ibb.co/i0Ow9K Normally, there is a BUDGET column, and an ACTUAL column for each...

Hi, Any ideas how to get around this problem … I have 2 lists ofnames. One list is First Name and Last Name, the other list is Title First NameLast Name. I want to identify who is on both lists as best I can. Any ideas how to do this in excel? I appreciate there maynot be a 100% accurate...

this happens ONLY to excel files. i click once on the file, and it opens! :( any ideas?

Hi guys, I'm trying to include the max statement in formula below, so the last bit is < max of column AC. Any ideas? COUNTIFS(n!AO:AO,1,n!D:D,"<"&W68, n!A:A,"<" max:(AC))

Hi all, I have an issue with a for each loop where I want to limit a set range to processing 100 rows on each run. So the first interaction would be range L2 to L101 then L102 to L203 and so on. The last one would more than likely have less than 100 rows so that would only need to loop as...

I have formulas in ever cell from J3 thru BH3 Worksheets("Master_Week").Range("J3").Select Selection.AutoFill Destination:=Range("J3:BH2560"), Type:=xlFillDefault However the above code fails. Any ideas? Thanks

Hi All Wondering if anyone can help me here. I need to highlight cells where the number is lower than say cell A2 but only if there difference is more than 1%. Any ideas? For example: <tbody> 53 52.6 55 50 47 69 </tbody> Only the cell in purple would be highlighted. 52.6 would not...

https://docs.google.com/spreadsheets/d/1-f4cUjN5BB0jICErbVqpRA5oyumSLjlMS0xRI6U-PgQ/edit?usp=sharing Hi, I know this is not a googlesheets forum but I'm desperate. I used this forum last year for excell with great results .... fingercroseed. I'm trying to copy the data in this sheet from...

Hi all, I have the following formula that works for any number over=IF(C3&I3="","",IFERROR(LOOKUP(9.99999999999999E+307,1/(($BJ$3:$BJ$5002=C3)*($BK$3:$BK$5002=I3)),$BV$3:$BV$5002),"Backorder")) This seems to work fine but not when BV returns 458429 Any ideas why? Thanks

Hello! I'm looking to delete all rows not containing the following in column E. I have the following code, but it's not working. Any ideas? With ActiveSheet.UsedRange .AutoFilter field:=5, Criteria1:=Array("<>PN", "<>RN", "<>DR", "<>TA"), Operator:=xlFilterValues .Offset(1...

I'm writing a macro with a date picker but it won't load on the machine that I'm testing it on. I'm using 2007 on both machines. On the test machine, I noticed there is only the Office12 folder in the installation folder. On the machine I'm working on, there are several folders. I downloaded the...

I am trying to sumproduct if my column has "j" flag and if the sum does not equal to 0. =SUMPRODUCT(($E$9:$E$289="j")*--(M$9:M$289)<>0) this doesnt work as expected. any ideas please? thanks Andrew

Hello all, I'm stuck trying to figure out if this is even possible in excel. Basically what im trying to set up is a chart that will give me a yes or no answer. sounds simple enough but where i'm struggling is this. in cell A1 there will be a drop down list of all 50 states. same goes in cell...

Hello, trying to put together a sparkline using a a non-contiguous range and getting errors, any ideas on how to achieve this?

In an Excel 2013 workbook when attempting to open Name Manager (Formulas > Name Manger) I receive the progress circle for a few seconds than nothing. I have searched the forum and internet with to luck. Anyone have ideas? Thanks Ron

So I found plenty of help online about shading the region between two lines and successfully got it working for my data (specifically using this website: https://peltiertech.com/fill-under-between-series-in-excel-chart/ ) Well - now I need to only have a shaded region if one of the lines is...

Hi, I hope someone can help. I have one tab that contains data with one of the key elements counting the number of days an item becomes available. I have created another tab which I want to act as a summary that pulls through all items that are under 60 days. Any ideas how what I need to do...