greatly

  1. R

    Combining MIN IF

    I am trying to use the MIN formula to return the oldest date from column C if the two IF statements are true. Example of data below. I have tried the following formulas in Excel 2010 but they didn't return the correct information. Any help is greatly appreciated. =MIN(IF(D:D="Yes",AND(E:E="<=...
  2. R

    What formula works for this

    I need to create a formula to solve this question (put in plain english) so I ask Excel: Look for x in the following cells AI89:AM94 and if you find x put an x otherwise put a 1 if you can only find numbers Any help is greatly appreciated.
  3. P

    "How many will I need" Formula

    to try to keep it simple this is the equation I am working with (A+B)/(A+B+C+D+E)=% I am working this toward a goal % as the answer EX (A+B)(A+B+C+D+E)=15% Goal is 10% How many more "E" will I need to get to Goal any help would be greatly appreciated
  4. L

    Only calculate everything under 50k

    Hi, I am using the following formula and would like to only sum everything under 50k, any help greatly appreciated Thanks =SUMPRODUCT(--('04'!$J$2:$J$100=A2),--('04'!$I$2:$I$100))
  5. R

    If statement

    Hi, I am using the If and then statement. =IF((D6+D7-C8)>=C8,0,(D6+D7-C8)). But when the amounts are less than C8 it should be giving me a zero but it gives me a negative #. When I flip the greater, less than sign it gives me the Zero, but then it doesn't calculate correctly if my D6 and D7 are...
  6. M

    VBA to delete sheets that don't end in a certain criteria

    Hi all, Been trying with no luck to write a bit of code to delete all sheet in m workbook that don't end in the word "Trust". I have a report with 50 tabs with 15 of them named xxxx_Trust. These 15 are the only ones I need to keep in my final version. Any help is greatly appreciated.
  7. L

    find last column with data

    Hi good people, please help me with a formula that will look at range E2:BV500, and return the column address of the last column in this range which contains a value. So if column AB has a value in ANY cell, and no other columns to the right of column BA has any values in them, I want "AB"...
  8. W

    Different Types of Formulae in the same cell

    Hi There I'm having trouble trying to incorporate different formula types in the same cell. Does anyone have any suggestions ? My current data is: Cell A1 = 15 A2 = 0.75 A3 = (either "yes" or "no") In cell A4, I need to: =A1/A2 (to return a % value); as well as If A3 = blank or no, then no...
  9. R

    VBA Index Match Array

    I'm getting a compile error "Expected: end of statement" with "Pass" being highlighted. Any help getting this code to work would be greatly appreciated. Range("I2").Select ActiveCell.FormulaArray=...
  10. M

    Stumped... Need Help with formula...

    I'm having a problem getting this formula correct.. =IF(AND(B1="SF",B2:B100=N12),B1,IF(AND(C1="LF",C2:C100=N12),C1,)) The result returned is 0, It should return "LF" Any help would be greatly appreciated... Thanks... Michael
  11. S

    If cell is non-blank then delete row

    Hello, I am using the code below to try to remove rows that contain any value in a certain column (Column AK). Presently, the code is deleting every line. I am probably missing something really obvious, but i have looked on several different sites and I can't seem to sort it out. Any help...
  12. S

    Nested IF? Maybe AND? Both?

    Hi all, I know this is a breeze for some of you, but I'm struggling a little. I have values in G3 and H3. I'm trying to calculate the following If G3 is < H3, make the cell appear blank with "" else If G3 / 2 is < G3 - H3 G3 / 2 else G3 - H3 i.e. G3 H3 14 6 Result of formula would be 7...
  13. A

    Formula errors?

    Hi, Could anyone take a look into the formula for me please? It seems something went wrong, and all the result Returns to be "0"...
  14. E

    Web Scrape Help....

    Good Day!! I am a little lost, and hoping someone can at least point me in the right direction. Every month, I need to review 20 hotels on TripAdvisor.com and see what their rankings are. One example here for Hilton Cleveland is #3 of 38 (as of right now, may change at some point). Here is...
  15. M

    printing PDF'a with vba

    Hello all I have a file with about 100 different sheets. I need to be able to print individual pdf's of each sheet automatically. I currently use the following Dim ws As Worksheet For Each ws In Worksheets ws.Select nm = ws.Name ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _...
  16. T

    Combining MAX and ROUNDUP

    Hi All, Here is what I am trying to accomplish: I have a project in which I need a quantity of 123 'widgets.' These 'widgets' come in cases of 100. Need a formula that will return the value of 200, when comparing 123 and 100. Any and all help is greatly appreciated. /twg
  17. M

    Help need help with a sum, look

    Hello, i have sheet 1 that is the lookup, sheet 2 is the find and return the total of column3. I keep getting ref# or N/A. I need to sum all instances of A17 from sheet 2. My formula is {=sum(vlookup(A17,'Sheet2'!B1:B30,3,false))} Any help is greatly appreciated
  18. A

    Lookup in cells that is filled with colour

    Hi Guys, As the title indicated, I tried the Vlookup formulas in cells which is filled in colour to indicate the Status, but it doesn't look up the value(colour) Could anyone help me to come up with a formula to look up the colour as per items? any help would be greatly appreciated ! Thanks
  19. L

    Increment values only when there is a zero in a cell

    Hello Forum, Hopefully someone has some pointers on this. Normally I can figure out little problems like this but this one has got me stumped. Obviously my Excel skill are not as good as I thought they were !! Here is my challenge... I have a set of numbers which are grouped, sometimes...
  20. R

    Confused

    Hi, newbie here! Im trying to complete my cable calculator tool and wanted to add some automation to it. I have added some parts but stuck with others I would like to use G17 to take the value calculated in G15, apply it to the table in whichever column selected in G2. I have got it working to...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top