worth

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...

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>...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...