difficult

  1. C

    Comparable market analysis

    the formula am trying to create will be used over and over with different text so I can see an example of one I should be able to fix to work on others I will use condition as my example I will have 4 choices poor, fair, average, good the value will be compared against the subject property...
  2. S

    Maximize R squared using solver DOCUMENT ATTACHED (may be difficult)

    Hey guys, I'm creating an algorithm for daily fantasy basketball and I have hit a little roadblock. Here is the link to download my spreadsheet: <a href=http://www.filedropper.com/linestsolver><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br...
  3. N

    Complex Search Formula

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

    Search that ignores cells conditionally.

    I need to search down the cars column for separate instances of equal to or greater than 2 that do not occupy the same 60min time frame. As you see below, it would return a no in D2, a Yes in D3 and then must ignore C4, C5 & C6 because they are within 60 minutes of the first instance of 2 cars...
  5. S

    Enter and clear values but retain records somewhere else

    Hi All, I have been putting together a general journal style spreedsheet and I'm not sure if Excel can accommodate for this: I need users to enter values in sheet 1 i.e (A6:R99), then theses values to be automatically be stored in sheet 2 (A6:R99), now here's the issues, from this point the...
  6. D

    Cell reference where to start and stop at 2 different instances (Involved I think)

    I'll start with pictures to better explain what I am trying to accomplish. imgur: the simple image sharer This is a typical chart I work with. imgur: the simple image sharer The Data tab that creates the graph. imgur: the simple image sharer The starting point of data I need. I believe...
  7. T

    Accountant needs Excel help, very difficult formula set up!!!!

    Hey! I am a tax accountant trying really hard to impress my manager...long story short one of our big clients give us a very un organized Excel sheet of there trial balance... and I want to find a quick way to organize it...below is an example of what the excel looks like and what I want to...
  8. J

    4 Linear Interpolations... I think.

    Here are 4 tables of iterated values for bottom hole pressures in CO2 injection wells. I’d like to be able to input a Surface Pressure (Psurf), TD (total depth), average fluid temperature Tavg, and CO2% and have excel go find the best approximation of the bottom hole pressure from the tables...
  9. J

    create a monitoring excel sheet with static data

    Hi, this is James For an IT company I'm working with, I would like to create a monitoring excel sheet for myself with EXCEL 2003 Requirement : Use external data and create alerts I have used web queries (external data) for an INTRAnet website, (only works in the company) to extract data. The...
  10. A

    Need Formula that Calculates Sums of Multiple Cycles Within Column

    Hey everyone. I'm currently a student and my studies have nothing to do with excel, but I have am in the middle of an internship where all I do is work with spreadsheets. Currently, I'm working with a paper company in Alabama, where they asked me to create a spreadsheet that measures efficiency...
  11. S

    Quite a Difficult Problem, any Help Please :-)

    Hello Everybody I am having quite a problem with a spreadsheet I am working on. I basically need to copy a row, and if the value in cell "V" is greater than 1, then that many rows (as specified in cell "V") need to be inserted below, and the copied row needs to be inserted that many times...
  12. E

    Sumproduct 3 - difficuly -been days on it

    BEEN ON IT FOR 2 DAYS NOW VERY CONFUSED I THINK IT CAN BE DONE BY SUMPRODUCT CANNOT SEEM TO FIGURE IT OUT I AM TRYING TO SUM ALL THE COLUMNS THAT HAVE A TITLE OF "GCE" LOOK ACCROSS THE ROW AND THAT HAVE A DATE BETWEEN 16 JUN 11 AND 20 NOV 12 LOOK DOWN THE COLUMN I PUT THIS AND ITS NOT...
  13. G

    SNP Excel tough one

    Here is a challenge, that can probably only be solved by an Excel expert. Can this be organized into rows and columns properly? The below data is from 3 SNPs. I have a text document with just over 148,000 of these. I would like the below data to be turned into 3 rows, with as many columns as is...
  14. D

    difficult formula

    I have a hard formula that i want to construct in excel and i need help... I have made up an equation in one cell (A1) that is the average of 4 other cells. What I need, is this answer (A1) to then equal a "Pass" in another cell dependng on the if the answer in A1 is between values x (cell B1)...
  15. B

    Filter out certain lines before paste (Macro)

    Hey all, I'm having a little trouble with a Macro at the moment, I need to copy 4 columns on one page, (A, B, C and D) and paste them into another sheet on Columns C, D, E and F. That I have achieved... However, I also need to filter out any row where the value of column A begins with a 6...
  16. J

    Tough excel formula; Need help solving for 2003

    I have a formula that works fine in excel 2007, but contains too many levels of nesting to work in 2003. I don’t know if there is a solution or not, but if there is the people here will know it. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p>...
  17. H

    Macro for dynamic named ranges

    Im trying (for 2 days now) to create a macro to create a set of dynamic named ranges. there are column headers in row 5 and 5 rows below that there is the beginning of my data. Heres where the sticky part comes in: i have another table below my data that references the above table (that is...
  18. O

    Is this too difficult or too basic to complete

    Can anyone help I am new to VBA? Below is a basic way to find rows that match 3 criteria, work out the average to each column G to M of all the rows that match the criteria and copy and past to a repot sheet.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...
  19. D

    VB Search Function Problem...Help!

    I am attempting to perform a search on a data sheet containing multiple columns of data. The policy number input into PolicySearch_TB should search for a match on the input criteria, under columns:- ... K (PolicyNumber1_TB) ... AE (PolicyNumber2_TB) ... AY (PolicyNumber3_TB) ... BS...
  20. L

    Probability / Permutation matrix / Difficult

    Hi everyone, I have a list of - say 5 events - all independents. Each event has 2 outcomes: failure or sucess with two gains possible : GainFailure and Gainsuccess I want to get a table giving me the gain for each scenario with the associated probability and then chart it. EXAMPLE: (with...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top