complicated

Hi all! Hope today is finding you well. I have a VBA question for you. I need a macro to do a couple of things: 1) Move all rows with unique values in Column A to their own sheets within the same workbook. (I.e all rows with the value "WE Region" in column A need to be moved to the WE Region...

So for my current work we are getting a new system to keep track of inventory. Everything we have saved in our current inventory is saved into a workbook in Excel. I was wondering if there is a formula that can determine a few things. so the basic formula i would want would be IF A2 through...

Hi guys! I really need your help regarding the print area. I am working on a file that is so complicated. It has header, filtered data and last part (signatory). So here is my problem. If ever I filter the data that I have, the print area of my file still includes all the data - both filtered...

I'm needing some help turning a table with two columns, into a table with multiple columns based on the information in the column. The table I currently have has over 300 rows and I want to turn this: <tbody> 123888 OTHER US 4 KSU 3.92 378288 CHAMPAGNE-URBANA 3.8 999914 PORTLAND...

Hello geniuses, Imagine the table below is longer with more variables. Each color is a company. Number is dollars earned. There are three different businesses: A, B, and C. I'm trying to take the full sum of each company's book of business, but classify them by the more dominant business. So if...

I want to round up a figure in a document. The figure needs to round up to the nearest integer but only if it is greater than or equal to x.2 and round down if less than x.2 and return a whole number only which could be any where between 0 and 500. So 3.14 rounds down and 7.26 rounds up. Any...

I am having problems putting this into words, so bear with me. I am attempting to find the Median which I normally know how to do. The problem is something else. I have 4 columns Sales Person Product # of Products Sold Price I want to find the Median price of products sold for each Sales...

Hey Mr.Excel users, I have been trying all week unsuccessfully trying achieve the following in excel . There is around 1700 unique ID's that I need to do this for so it would ultimately have to be a formula that can be applied to each column. It does not matter which date is populated if...

I need to create a "Calculator", which takes a date/time entered by the user, and adds a certain time (up to 100hours) based on criteria, giving a another date/time. To complicate matters, I need to exclude non business hours and weekends for some criteria, but not others. Example If Criteria...

Hi there, I want to remove duplicated rows from my table. The real spreadsheet is huge, but in order to simplify it, I'm posting here a sample in this picture. It's a spreadsheet with clients, with Names, Ages and Countries. We have full data of most of our clients, but we have duplicated and...

I have a very large dataset (~5000 points in a 2D array) which I need to plot and fit a linear trendline to. There are 90 subjects each of which has a daily binary event checked over its lifespan. eg: Day: 1 2 3 4 5 6 7 8 9 10 subj 1 0 1 0...

Hello again, I need help with a vlook up formula. What i would like from the vlook up is illustrated below. There are two seperate pull sheets, well call them a & b. The user starts by selecting a scenario. The scenario indicates which months would be pulled from where. For example if the...

Hello, I am working in Excel 2010. I am trying to write a formula to calculate a team's current winning/losing streak. I have wins and losses each in their own column, represented by a 1 or a 0. I would like to represent the current streak in a single column where (+) values represent a winning...

=IF($E3=$T$3,IF($F3=$U$3,$V$2:$V$8,IF($F3=$U$4,$V$9:$V$15,IF($F3=$U$5,$V$16:$V$22,IF($F3=$U$6,$V$23:$V$29,IF($E3<>$T$4,"",IF($F3=$U$3,$V$58:$V$64,IF($F3=$U$4,$V$65:$V$71,IF($F3=$U$5,$V$72:$V$78,IF($F3=$U$5,$V$79:$V$85,"")))))))))) The bold one isn't working. I understand why but can't figure...

I need to add 2 additional parameters to the following formula. =IF(ROWS(A$12:A12)<=$A$4,SMALL( IF('Training Database'!$A$2:'Training Database'!$A$4996=$D$5, ROW('Training Database'!$A$2:'Training Database'!$A$4996)-ROW('Training Database'!$A$2)+1),ROWS(A$12:A12)),"") The bolded portion of...