pretty

  1. T

    Index/Match Partial Match

    Hello, I have the formula: =IF(INDEX('4WK MVT'!B:B,MATCH('Worksheet'!C12,'4WK MVT'!D:D,0))="*"&"DC"&"*",True,False) The end goal here is if the returned result has "DC" in it, I want it to the True, if not, False. Pretty sure I am using the wildcard incorrectly or something. Thank you!
  2. U

    Holiday/annual leave tracker

    Hi my fellow excel warriors, I am looking for an excel template to track holidays. I have found trumpexcel. com/excel-leave-tracker which looks pretty good but I need it in hours and not days. Can anyone help? Many Thanks
  3. J

    VBA: Fastest way to determine last non blank row in column

    This is pretty fast, is there any quicker? Thanks. LR = [match(2,1/(l21:l<>""))]
  4. M

    Quick Help Plz

    Hello, I am starting with VBA and I'd like to know if it was possible to use list from a worksheet inside the code. I wouldn't want to create an array as my list is pretty long. I would like to have an if statement that goes like: If Range("A1").Value IN [a liste of value inside the...
  5. G

    Simple number formatting

    Hi, How do I format number to 2 decimals so that "A$" sign comes on left of the cell box and text on the right (like the $ format coming in the last row) Right now the fomratting looks pretty odd. Image attached. Also while we are at it, how do I have "US$" format? Thanks alot
  6. deletedalien

    Vlookup offset? Index? Match? Choose? i honestly have no idea.......

    Hi all... i have a fairly simple problem with what i think is a pretty hard solution (at least to me) so i have a sales comission report and need to pull agent totals to another excel file. Seems pretty straight forward.... Except this report creates a new row per sale... so the totals row...
  7. T

    Lookup customer name on IE and return address using VBA

    Hi, I have a list of business names in Excel starting in cell A2 going down to A3, A4 etc. The record-set is pretty large as it contains over 100,000 rows. What I need to do is to retrieve the address for these business using IE and return the corresponding address in cell B2, B3 etc.. I'm...
  8. M

    Loading an array from a spreadsheet

    I've got approximately 200 records, with each record consisting of 12 string fields. I have a two dimensional array. The question is how to declare it and how to load it from the Excel spreadsheet, then how to rewrite the info back to to spreadsheet after the data is changed/manipulated...
  9. A

    New Access Form Not Showing Up In VBE Collection of Forms

    Hi all, I am adding a new form to a pre-existing split - database. However, when I open up the VBE, I can't find it. I'm certain this is a pretty simple issue, but I can't find anything similar searching online. Any ideas? Thanks,
  10. S

    Formula for if something = text

    I have a formula but I'm not sure how to write "text" into it. For example in cell A1 if text appears I want it to result in the answer in B2. for example" =if(A1=text,1,2) The use of the word "text" clearly is wrong so must be pretty simple to fix?
  11. L

    VBA for 3 OptionButtons

    Hi - this is probably a pretty simple one, I'm trying to write some VBA for 3 Option Buttons. The first two lines work but the third one doesn't. I'm pretty new to writing VBA. Private Sub OptionButton1_Change() If OptionButton1.Value = True Then Sheet36.Range("C2").Value = 10...
  12. K

    cannot view workbook information in locals window

    I put in the code: Dim wb As Workbook, str1 As String Set wb = ActiveWorkbook And when I look at the info for wb in the locals window for wb it just as no variables. I'm pretty sure that it was working a second ago.
  13. E

    Simple Rookie Formula Question

    Hi everyone! Pleasure to have become a member of the community. I hope to become a net contributor to the board in the future. Alas, now I will posting (hopefully) pretty basic stuff. I mostly self-taught myself Excel and became pretty proficient from my former job in benefits (typical basic IF...
  14. B

    IF formulas and partial text

    Hi, I'm pretty sure this is an easy thing but for the life of me I can't figure out how to get this to work... I am trying the following formula in Excel 2010 to find a part of text in a cell and then, depending on whether it finds the text, return the corresponding values...
  15. deletedalien

    VBA code to delete rows based on certain criteria (match case)

    Hi there, so i have a couple of questions but they the end result is basically the same... i need to delete rows... firstly i would need a macro to delete all rows that contain a lowercase Z (usually should be found in column "A") Next i would need to delete all rows that contain an empty...
  16. L

    Formula to Remove Last Alpha Characters

    I have the following 8A, 20C, 110J. I want a formula to remove the letters from the far right, so that it returns 8, 20, 110. Letters can only be from A-Z. I think it's a pretty simple formula but my brain is making me think of something more complicated. Would like to avoid using any helper...
  17. N

    Help with complicated formula

    Hello I have a dataset and I am trying to use a formula. However despite spening ages on it it still not working. I am new to this and am probably missing something pretty obvious, and I was wondering if someone could have a look at it to see if it is written incorrectly. =-1.675 + (0.037*e2)...
  18. N

    calculated result based on cell data? Pretty complicated...

    Hi all, Long time lurker and first time poster. I regret to make my introduction one where I ask (beg) for help but am at a loss achievable results. I'm compiling some football stats (not soccer). For anyone not familiar with football you have 4 downs to get a min. of 10 yards to achieve a...
  19. R

    Creating a new column

    Hi, I need help extracting a value from a column to create a second column. A 1. G17 2. G16 3. G16 4. G17 5 G16 6. G17 I want a coulmn of g17 and a coumn of g16, in the current row. To look like this: A B 1. G17 2. G16 3. G16 4. G17 5. G16 6. G17...
  20. E

    Sumifs formula

    Hi All, I'm working with a pretty simple sumifs formula as follows. =SUMIFS(E4:E77,$A$4:$A$77,">0",$A$4:$A$77,"<=A1") However, it is returning 0 when there is clearly data. In cell A1 I have the following equation to identify the last number listed in a column that i add data to weekly...

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