dec

Hello I am in charge of creating the schedule for my department. I have attached a template here. as you can see I use initials and quite often probably just because of my incompetency I tend to forget to put someone down on the schedule. How can I build a check or macro to ensure that...

I watched this video and modified the formulas. This will extract the missing values from between the minimum and maximum in the range (sorted or not) into either a single cell or a range of cells. Function TEXTJOIN requires Excel 2016, I think. Is there a superior method...

I'm trying to use the data from the tab name in some <gs id="135d7cfc-d175-4723-9d7c-8909c9e466ed" ginger_software_uiphraseguid="a0d1d67e-f848-4b36-81a3-82ab5068c488" class="GINGER_SOFTWARE_mark"><gs id="872af9ed-3334-4e82-8706-c06df1a776b6"...

Hello, I am attempting to calculate the YTD, MTD, CYTD and revenue to date for a very large data set which spans the past three years. I have included a small sample below and welcome suggestions on the best way to achieve this. Kind regards, Esther <tbody> Year Month Banker Segment Product...

I am trying to complie a number of spreadsheets containing dates of appointments, unfortunately one of the spreadsheets the person has enter the date as 3rd Dec 2016 instead of 03/12/16. How can i convert it please. thank you in advance.

how to calculate YTD with 2 criterias (i.e. heading is the month from B1 to M1 and Specific Code in the column A2 TO A10) Example A2 – A10 has name of the fruits B1 to M1 has Jan to Dec Each fruit has a value from Jan – Dec entered in B2 – M10 I want to get the YTD total of fruit if I...

I have a table as follow on fees and wanted to use the nested IFs to find the accumulated fees depending on which month it is. <tbody> A B C D E F G H I J K L M Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Fees 640 500 800 500 650 420 410 550 220 440 160 180 </tbody>...