complex

I have a workbook with lots of formulas and sheets. It is updated weekly and the data grows irregularly with every update. As of right now I have my formulas referencing entire columns in order to capture all new data. This is starting to catch up with me, as the processing time is detracting...

Hello all. I've been struggling with re-formatting spreadsheet data I have to make it easier to bring into power bi for analysis and I was wondering if anyone might have any suggestions on how I can perform this action efficiently. I do currently have a working vba module that will re-format...

Hi Everyone, So this is my equation {=IFERROR(SUMPRODUCT(--('1'!$A$5:$A$33='Monthly'!A2), INDEX('1'!$N$5:$N$33,,MATCH('Monthly'!A2, '1'!$A$5:$A$33, 0))),"")} {=IFERROR(SUMPRODUCT(--('1'!$A$5:$A$33='Monthly'!A3), INDEX('1'!$N$5:$N$33,,MATCH('Monthly'!A3, '1'!$A$5:$A$33, 0))),"")} It is taking...

My question is part of a complex formula. What I want to do is find the product of E3*A3 (sheet2). The issue is that E3 contains a complex formula that results in the cell location of the cell to the left of the cell which matches my search reference. This is the equation in E3...

Hi there, I am new to VBA and just used YouTube to create a calculator for work. My colleagues and seniors (who have seen it) love what Excel can do as it will save so much time. In order for the company to want to proceed it requires testing, however I cannot do this due to the following...

When you put in a series of numbers in sequential cells then drag from the corner of the cell, Excel will see the pattern and predict the next few numbers for you. But in more complex cases, Excel completely misses the pattern. For example, this formula: =GETPIVOTDATA("Sum of...

Looking for a master to show me the ways. I can't figure out a formula and its difficult to explain.. I have a large table of data where I have several orders and I want to organize them by most recent..... And here's the complicated part.. There are several orders I don't want at all. Each...

Hi All, I have a list of hundreds of server with multiple applications on them. I want to lookup and list all servers with the same application on them but also want to identify server dependencies which occur through additional applications on the server. Hopefully this example will explain...

I have a set of numbers in column B <tbody> <tbody> 07.01.01.01.01 </tbody> <tbody> 07.01.01.03.01.01 </tbody> <tbody> 07.01.01.04.01 </tbody> <tbody> 07.02.01 </tbody> <tbody> 07.02.04.04 </tbody> </tbody> I would like a fill formula to fill column A and reduce the...

Large project traffic control register. It is quite a frustrating issue due to so many lines per person. Workbook with 2 worksheets. WS1 contains list of items we use to allow input on WS2 which is the daily docket register. The numbers equal lines they correlate to in list as an example 1. is...

I'm not even sure where to start...this is what I'm trying to accomplish: 1. I have Worksheet 1 that has ID numbers in column A 2. I have Worksheet 2 that also has ID numbers in column A...this worksheet will have some case sensitive duplicates 3. Column B on Worksheet 1 is blank 4. Column B...

I want to extract document numbers from a range on regular basis. The document no. consists of 8 digits and starts with17??????,11??????, 12??????, 13??????, 15?????? and 61??????. In future this criteria may increase (e.g., 18.... & 62.... etc.). If the criteria repeats, i want the document...

Hi Everyone, I maintain a contracts database and need to automate the total qty column. Having a really tough time getting it to automatically show those numbers. Summary: This data represents one contract (internally it is contract #18, externally, it is contract #21). It is broken down into...

I need some help with a complex combination of Excel functions. I routinely use SUBTOTAL to sum up values for a filtered list. I also routinely use COUNTIF/SUMIF to look at a full list of data and sum up values that meet certain criteria. I want to combine these two functionalities. Here is...

I am in need of assistance with this one. I have multiple cells that contain different sets of data... A B C D OVC005 FEW030 SCT075 BKN150 BKN020 BKN075 OVC150 BKN015 BKN075...

Hi guys Got a couple of sumproduct formulas, which I now need to ignore hidden values in all columns contained within the formula when another column is filtered. =SUMPRODUCT(((M5:M667="Yes")*(P5:P667="Yes"))+((T5:T667="Yes")*(V5:V667="Yes"))) &...

Dear All, I am looking for an Excel formula that could perform quite a complex calculation. I need a formula that could pick numbers from a random list of numbers. First of all the formula should be able to pick out the number of 9s and 10s in the list and calculate them as a percentage of the...

Hey All, First time posting, as I am just staring at the screen trying to figure out a very complex formula string. If there are any wizards out there that are up for a challenge I would be forever grateful! I'll start off with what I'm trying to do. I have data from an online form in an excel...

So, I have a 40x2 table of non-systematic strings to be converted to other strings - think "LM" needs to become "2P9" and "ATT" needs to be "Y4," all just according to this table. I have long groups of things that need to be convered seperated by dashes (so something like "LM-ATT-etc-etc-etc,"...

Hi everybody, I've got a slightly tricky problem that consists of two parts. The first part is I need a formula that returns not the last day of the month, but the last business day of the month. The second part is - I have a spreadsheet with information about the performance/fees of a fund...