1. D

    Offsetting excel formula

    I have code to where it takes a table and makes exact copies of them one after another. sheet one has a table that is 16 columns and when I run the code it will past the same 16 columns, for example A-P is the 16 then it leaves Q empty then pastes the 16 starting at R and so on Sheet two has 3...
  2. E

    Searching for a formula which preoduce given result

    I have Two sheets name are Sheet1 and Sheet2. Sheet1 has different values in Quarters and Months. Sheet2 have start date and end date which is populate months according to the dates. Sheet1 ColB = Years and ColC = Months. I am looking for a formula which automatically assume it by matching the...
  3. mehidy1437

    Have a list without any blank cell.

    Hi There, I'm re-arranging data from column A:E to G:O. While re-arranging, I'm getting blank cell in soeme rows of column G, H & I, it's because of my current formula at cell g2, h2 & i2. I need help to have the alternative formula for this 3 ( g2, h2 & i2) cell, to have the same result but...
  4. C

    Formula or do I need to break down and use a macro...

    Hello All. I am not the best excel user but definitely not brand new to excel, and if something like this has already been answered just direct me to that thread. I have a very large proforma spreadsheet that I am using to track our company's estimate/cost per job vs overhead spending vs...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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+"...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back