worth

  1. E

    Office 2019 worth it?

    I'm thinking of upgrading from Office 2010 to 2019. I need to know if I'll still be able to read and edit docx / docm and xlsx / xlsm files created with Office 2010 read/edit in Office 2019 and files created in Office 2019 (Except new funcitons, of course) read/edit in Office 2010, without any...
  2. S

    Save Macro

    Hi I have this code to save a spreadsheet, Sub Save()' ' Save Macro Sheets(Array("Sheet1")).Select Sheets(Array("Sheet1")).Copy ActiveWorkbook.SaveAs Filename:=Range("F21") Range("A1").Select End Sub <colgroup><col><col><col></colgroup><tbody>...
  3. S

    Check if value matches in a range

    Hi, I want to match the column on a range. Suppose as in the example below, for the Sq No 1, if the Address column of first four rows (where Sq No = 1), I want to put a "YES" if matched, in the Match column <tbody> Sq No ID Address Match 1 1500946 <tbody> 3410 WORTH ST </tbody> YES 1...
  4. N

    MOS - worth it?

    Hi, I am curious whether the MS MOS certification is worth exploring. I am an accountant that does a lot of work with Excel and is in particular branching into PowerBI etc. I have not had any formal training per se and was wondering if it would be worth pursuing training in either the MOS and...
  5. M

    Calculate holidays between two dates

    Hi, I use the following formula to calculate how many days off an employee has over a month. Where J Column is a drop down option with DAY OFF, HALF DAY etc & B Column is how much each day is worth. For example a saturday is worth 0.5 and a weekday is worth 1. I need this exact formula but to...
  6. 6

    formula(s) to count points that "carry-over" or build if not won... then drop back to 1 after a win??

    I had a hard time thinking of a good title for this since it is hard to explain. here is what I am hoping to achieve... There are four individual games that are each worth a point. If someone wins the game, then they win 1 point. If nobody wins the game, then that point "carries over" and...
  7. G

    If formula with multiple possible results

    Hi Everyone, I have scenario that I cant seem to find an answer to using formulas in Excel. Looking for a little help. I am making an excel tracker to be used by a member of my team to complete quality monitoring for a client. Most question have a specific weighting if you get it correct or...
  8. T

    Calculate number required to achieve target percentage wiuth multiple inputs

    Hello, Im trying to calculate a way for me and my colleagues to know how many remaining 5s we need to reach our target %. Since the target is 88% the only input that brings it up is the input 5 since input 4 is valued at "75%". Ive tried solving this for a few hours but i just cant wrap my...
  9. P

    help on vlookup

    I have the following formula, but it is not working because column C from Database is also a formula. =VLOOKUP(D4522,'T:\Version 10\[Backlog Template for v.10.0.xlsx]Database'!$C:$S,17,0) For what its worth Column C in Database is formatted as number and needs to be retained that way.
  10. T

    Formula for converting monthly % increase to annual % increase

    So in column A1 I have an average monthly net worth increase of the past 12 months listed as a percent -- 1% In column B1, I'd like to insert a formula that calculates the annual net worth increase rate as a percent based on A1, assuming a net worth constantly grows at 1% each month for 12...
  11. D

    Use VBA to look for consecutive values in a column

    I am still quite new to VBA and am looking for some help writing an "if statement" that will look through a column of data and find consecutive values (say 60 consecutive cells worth of 0's). I would only like the code to progress If the condition is met (60 cells in a row worth of 0's). I...
  12. K

    Searching for Incorrect City Spellings in a Cell

    Hi, This is my first time posting, so please excuse the clumsiness and poor formatting. In my job, I need to validate data before I can start anything. My biggest problem is that cities are often misspelled or entered in the short-hand way and origin/destination pair will appear twice because...
  13. D

    Locating specific dates in a column

    I am trying to write a formula that will reference a column and give me a count of all cells that have the specified year in them. Example column H will various years worth of data in this format 1/01/2017 and I am attempting to get counts of each years total, so month and day are pretty much...

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