formual

  1. M

    Searching an array of cells for a value and returning the column headers where a value exists

    Hi, I'm trying to find a way which i can return the column headers where a value exists in the cells F:M for the same row. As you can see from the screenshot for the first row, i would like to search for any value in row 3 and bring back the column heads for the rows. I have shown in Column N...
  2. S

    Macro ActiveSheet.Formula Object doesn't support this property or method error

    I am trying to do the following: ActiveSheet.Formula = "=IF(TEXT(E2,""YYYYMM"")< text(m2,""yyyymm""),b2&""-""&c2&""-""&d2&""-""&""01-""&(text(m2,""mmm""))&""-""&(text(m2,""yy"")),b2&""-""&c2&""-""&d2&""-""&e2)" This works when I put it in an excel formula but when I put it in my macro I...
  3. redspanna

    IF formual based on two criteria with a minus figure

    I have simple table below that will work out return and place into E1 if a W is placed into C1 Back Odds W/L Formula Result 15.00 2.5 W =IF(C1,"W",A1*B1 37.50 how can I change the Formula to also check if a L is placed into C1 and show the result as a minus figure...
  4. U

    Grade compare two non blank cells with alphabets and report trend

    Dear MrExcelites, Greetings, I need a formula to compare the last and the last second cell and report whether it has increased or decreased or stays the same. Grade Table: <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  5. H

    Predict Sales between two dates based on history sales per Quarter

    Hi, If I had two dates from 1/15/2018 to 7/10/2018 and I Had sales per day from historical data : Qtr1 - 20 - per day Qtr2 - 25 - per day Qtr3 - 18 - per day Qtr4 - 32 - per day I wanna know how much I'll sold based on this data per quarter like this : from 1/15 to 3/31 how many working days...
  6. L

    Nested Ifs

    I have sales areas of various stores, I need to classify them in to the following bandings: 2000sqft 2000-3000sqft 3000-5000sqft 5000-8000sqft 8000-20000sqft 20000-30000sqft 30000sqft I've been using the following formual, but it doesn't seem to work. It just returns "30000sqft+"...
  7. H

    For Formula's sake

    Hello, I hope everyone is doing well. I would love some help figuring out why an addition to my formula is not working. The original formula i am working with is =IF(ISNUMBER(SEARCH("GSI",AB1145 )),"GSI",IF(AB1145="NO CAMPAIGN","NO CAMPAIGN","CAMPAIGN")) and it works just fine. However, I need...
  8. P

    help with an "If AND" formula

    I'm running into a challenge with an "if And" formula. What I want to do: If BV4 = .46, then 0 else if BV4<.46 and AT4<5 then vlookup BV4 to the Rate table else 9 Can you help me figure out what's the issue? Its returning "False" =IF(BV4=0.46,0...
  9. N

    formula code to give a score

    Hi All, I was wondering if you could help me. I have a value in cell B2 I would like cell C2 to give a score of either 1,2 or 3 depending on cell B2 So, If B2 score was >4.9, C2 = 3 If B2 was Between 4.8 - 4.4, C2 = 2 If B2 was <4.4, C2 = 1 I'm not very good at this so I was wondering if...
  10. M

    Formula Help for three criterias

    I was hoping someone could help me with a formula based on a certain scenario. <colgroup><col><col span="2"></colgroup><tbody> Organization Product Name Total $ American American o $6,564,132 American American Inc $3,647,234 American American CIB $443,245 American American Wash...
  11. S

    Need help with Dynamic dashboard

    Hi all, Can anyone help me solve this, Attached is the Home sheet of dashboard and is Linked with Each Chart and data with Buttons. Now i want to present the dashboard in such a way where view can select on what type of data should he see (Weekly based , Monthly based , Associate based) Once...
  12. A

    Please help on accumulating large time

    Hi everyone, I got an urgent question about accumulating large time. Please help! Is there any way to sum up 3 time in each row from A3:C6? The data format is General which I copied from other data source. The time in this table means dd:hh:mm:ss. They could not be calculated even if I change...
  13. A

    If = between range than * by this.

    Hi, I am trying to setup a spreadsheet for costings on weights. Users will enter in weight in cell 1 on sheet 1 and cost will appear in cell 2 on sheet 1. But different weight ranges are equal to different value. I have create a separate sheet (2) for the weight prices as these need to be...
  14. P

    Sort descending date VBA

    Hello, Could you kindly assist with the below code, at the moment I use the code to collect data and store it in Sheet Data. The code is linked to a button, i would like to include a sort date which is column C in the Sheet Data. as date can be entered up-hazard.. Many thanks in advance... Sub...
  15. B

    a complex solution to help mindless work

    on a daily basis I have lots of data that needs to be separated into various tabs. Example data below: <tbody> 1 a 3 f FEF 2 a 4 f DFG 3 a 5 f RET 4 a 3 f FGH 5 a 7 f ERT 6 a 3 f DFG 7 a 4 f ERT 8 a 3 f DFG 9 a 6 f DFG 10 a 3 f ERTY </tbody> Based on the contents of the...
  16. paliman

    VBA - Using the value of a string variable as the second argument

    Hello everyone. I have a file with several sheets, each one named after an alphanumeric account code (18D08H, 20J03, and so on) and another one named Sld2000 populated with my data. I want to put some values in each sheet, and at a certain point I need to use the value assigned to a variable...
  17. M

    Issue with copying formulated data from Excel into Notepad.

    MrEXCEL Members, In need of your help, I have a workbook that we created for to produce codes for a unix server for bulk loading. the issue is, when we enter the information in to the cells that need information entered, and copy the populated cell data, paste it into notepad, it puts " on the...
  18. badinvestor

    vlookup w/array in another sheet??

    i've looked all over the other threads and can't quite find what i need. i need to find a value where the lookup_value is on the the same sheet that contains the formula but the array etc. are on sheet 2. e.g. sheet 1 has two cols. col1 contains a ref # and col2 needs to return the value from...
  19. J

    Formula - only SUM based on criteria

    Hi all ex(cel)perts, I am looking for a formula that would sum all cells that meet a specific criterion in a different cell. To Illustrate: I have NAMES of individuals in column C and TOTALs in columns E. I am hoping there is a way were XL automatically finds the name and the appropriate...
  20. N

    forumla that needs more.......

    I am looking for some help on a formula.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> purpose time keeping;<o:p></o:p> User enters hours worked, (column B) program tracks hours worked in the last day, 30 days, 42 days and 90 days.<o:p></o:p>...

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