complex

Hi Community, I am trying to enhance a formula I created, but I am stuck now. Situation: There is an Input sheet "SellerInput" and there is an Output Sheet called "Seller Side" My formula is searching in SellerInput all rows with a specific "Office" and a specific "Range" and pastes...

Hello world. I'd appreciate some help as I'm really not sure how to solve this complex problem in an efficient manner. I need to find a fast way to price potentially hundreds of items. I know that loops will be the slowest thing in the world because of the sheer number of things that EACH ITEM...

Hello, I have a file which has multiple sheets. The first is my data sheet and the rest are destinations sheets. The data is copied from another system and the destination sheets are required to pull very specific information with multiple factors to consider from the data sheet. Basically...

I have a highly complex spreadsheet that I have to long hand the formula. Once I create the spreadsheet and create the formulas I cannot modify the sheet, only cell values. If I insert a column, the end formula will not count the new column contents (but I can delete columns before the formula...

Good afternoon, I am struggling to understand arrays. I have read many articles in this forum and in others but I can't seem to get a handle on them. What I am trying to do seems simple. I have 3 sheets, sheet 1 has a week column 4 data points columns, sheet 2 and 3 have charts. I need...

We are working on trying to allocate some overtime labor. There are multiple criteria that an item needs to meet in order to sum the overtime premium column, but I have been unable to come up with a good sumifs formula. I have a feeling I may need a more complex formula (to weed out...

As an example, I have the following sets of accounts. Under Account is what I have, and Number and Type are what I need returned. As a disclaimer, none of these are real accounts, but the lengths are all representative. <TBODY> Account Number Type *ZHR|U1234567 U1234567 *ZHR...

I'm trying to conditionally format (Excel 2000) a cell and it's not working, any help or pointers would be appreciated. My formula is AND(B10<l9,or(a9=a10,l9<b9,e9<b9,l9<e9)) I can put each comparison in a separate cell and they all work correctly. I can even put that whole formula in a cell...

Hi, I'm wondering if anyone has some best practice guidelines for keeping a database of their more complex formulas for quick reference and use. I've searched the forum for a similar thread but haven't turned up any leads. Does anyone find this saves them time/increases efficiency? Any tips for...

Hello all I'm quite sorry to introduce myself by asking for help right away, but I am quite stuck with a problem at the moment. I have to analyze some data wich is extractable from a database only by PDF lists (a genius must have been at work when he drew the specs for it). I have three PDF...

I want my formula to look up two values in two different columns. Refer to the attached link http://www.box.net/shared/yed7167g9z The blank columns in sheet 2 with headins in red are the ones needed to be filled by the formula which first looks up the family no. and then the family member...

:confused: Hello everyone - I have a complex lookup formula problem that I hope someone can help me with. I’m working with a complex excel workbook that I’m trying to build out to include more visibility, and I’m stuck with “writer’s block” on an issue because I’m not an advanced user of...

Hello, I have a text report that I get every day. It is a few hundred pages long but I only need 10% of that information. Below is an example of what the text file looks like when I copy/paste it into Excel. Sorry if it looks sloppy, wasnt sure how else to paste the excel dummy info in. So...

Hello everyone, i really hope someone can help me as i have been working on this for 2 nights now with no solution!! I have a data worksheet that contains basic row/column information. The row contains a comprehensive list of components (19) that are required for assembly of more complex items...

I'd like to create a 3D chart, but the values for 3 different charts that i want to create are integrated together in the table. The format of my Table is: Column B contains a Location Name Row 5 Contains Cells that are merged 3 at a time starting at Column C (so C5 is merged with D5 and E5...