back

  1. S

    Vlookup with Excel 2013

    Dear All, I'm using excel 2013 @ my workplace, and colleague asked me a question regarding VLOOKUP approximate match. Now the way I learned it from Mike Girvin is that it looks through the list and finds the 1st value that is larger, jumps back 1 row and delivers wichever col_index_no you've...
  2. K

    Group/ Un-group in Protected sheet not working Correctly

    Hi, 2nd post of the day :) I am using a macro to allow users to expand and close grouped columns when the sheet is protected, and its works fine UNTIL I save, close it and go back in. When back in the workbook is locked (that's what I want), but when I try to expand the grouped columns it says...
  3. A

    VBA search and update help

    Hi, Wasn't sure how to correctly title this question but here goes; I would like to know how to find the contents of a cell (which I am currently doing with a worksheetfunction.Vlookup method), copy the contents to an integer (or other number) variable, add another integer to it (based on a...
  4. S

    Back arrow (Undo) is greyed out after running any script

    Whenever I test a macro, (with what is normally a non-successful result) I cannot Undo the operation by clicking the Undo arrow to go back, I have to close the file and start over with a fresh copy. Hugely annoying...Anyone know why?
  5. R

    sumifs not equal to; not working for QUERIED (table) data

    I have some excel queries that return 11-digit numbers, but since they are part of a query, they come back as text. In my sumifs command, I want to avoid all of the data that has a certain 11-digit number. Thoughts...
  6. T

    I have a difficult one, Well I think it's difficult PLEASE HELP!!!

    I'm trying to make a commission structure for Excel and it's pretty difficult So we get paid 30% of the front gross + 10% of the back gross = total commission. Example: $2,000 front = $600, and $2000 back =$200 grand total $800 if the front is negative, subtract that to the back gross x...
  7. B

    range

    Hello All, What formula would I use to accomplish the below. If A1 is 1.5 to 1.9 bring back 101 If A1 is 2.0 to 2.4 bring back 111 If A1 is 2.5 to 2.9 bring back 121 This goes on for a while. Can you please help!
  8. T

    Help with simple function please

    I'm trying to add a commission structure. front and back gross. back gross is paid 10% if the front gross is negative, the you subtract that from the back gross, then multiply x 10% if the front gross is positive then no deduction needed. <style type="text/css"><!--td {border: 1px solid...
  9. E

    need to change column headings from figures to Alphabets

    Hello, Suddenly i found my excel column headings changed to figures instead of Alphabets and i need to know how to back to alphabets column headers. Example: instead of A B C D E F of column headers it became 1 2 3 4 5 6 and i need to get back to the alphabet column headings. Thanks
  10. T

    Calculation Option back to Manual?

    I have created spreadsheets to use as timesheets. our supervisors adjust and create new workbooks every week. On occasion the calculation option has defaulted back to Manual. Why is that? It does not happen very often.
  11. kelly mort

    Retrieving data from one workbook to another

    I followed this post : https://www.mrexcel.com/forum/excel-questions/1005007-standard-entry-another-worksheet.html to get my data being able to be uploaded to the database file on a network successfully. Now I want a way i can get the data from the database file back to a macro enabled...
  12. E

    VLOOKUP and SUM

    I am looking for a formula to look up the same name then add up the total numbers next to it. It always brings back just one instance when I write my formula.
  13. J

    Vba to update excel from access

    USING ACCESS ONLY TO GENERATE REPORTS AND QUERIES. I CAN LINK EXCEL TO ACCESS AND MAKE CHANGES, BUT CANNOT MAKE CHANGES IN ACCESS BACK TO EXCEL WITHOUT IMPORTING AND EXPORTING (SIGH ACCESS LOST THE LAWSUIT) sorry caps was on ....... Need VBA to allow editing from either program, escpecially...
  14. D

    Eomonth Formula Help

    Ok I have a column of dates and in cell A9 my formula reads as follows EOMONTH(A8,1). A8 has the date 11/30/2016 and the formula is bringing back 12/31/2016, but the last day of December in 2016 was 12/29/2016. Is there a way to tweak my formula to bring back the correct day end of the month...
  15. N

    Sumifs + this month going backwards????

    Hi, I have put together the following formula: =SUMIFS(POINFO!$E$41:$E$9682,POINFO!$A$41:$A$9682,[@[STOCK CODE]],POINFO!$F$41:$F$9682,"Oct-2017") Is it possible to have a formula like above, but includes Oct-2017 and then goes back through the months to Jan-2017. Then for Nov-2017, it will...
  16. P

    tying to calculate year and months in with datedif

    <colgroup><col><col></colgroup><tbody> E Purchase Date F Today's Date 2/1/06 12/5/2017 </tbody> Formula: =DATEDIF(E148,F148,"y") I want it to be able to return back 11 Years 10 months. Currently it just returns back 11 years. I have tried "my" and "m", "y" but still not working. thanks for...
  17. K

    Why isn't my name box working?

    Why isn't my name box working? For example, I highlight A1:B2, the name box briefly displays "2R X 2C", but as soon as I click on the name box to define the range, it defaults back to A1. If I've created a list of named ranges, when I click the drop down menu of the name box, it displays the...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top