complicated

  1. T

    Very Complicated VBA Question

    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...
  2. T

    Complicated Formula - Please Help if you can!!!

    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...
  3. C

    Set Filtered Data Print Area (Include Last 6 Rows As Continued Data)

    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...
  4. A

    Complicated table transpose with two columns to multiple columns

    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...
  5. M

    Complicated sorting and summing if

    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...
  6. A

    Conditional round up

    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...
  7. R

    Complicated Median help

    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...
  8. V

    Need to consolidate data, pulling data from rows that fit criteria

    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...
  9. M

    Calculating time additions excluding non business hours.

    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...
  10. N

    Not simple duplicated values removable

    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...
  11. Q

    Averaging binary values over a continuous, non-uniform domain.

    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...
  12. L

    Vlookup with a scenario

    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...
  13. M

    Calculate Winning Streak in excel

    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...
  14. F

    Complicated "IF" command

    =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...
  15. K

    Complicated Question! Need Help!

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top