jan

Hi, I have data of employees from Jan 2018 to Dec 2018 and I need to calculate the Average headcount by Jan 2018 and Average headcount by Dec 2018. Is there any formula that you suggest? Thanks

Year Month Salesman Customer Name Category Sales 2018 Target for Jan 2019 2018 Jan Peter A Supermarket Milk 20 22 2018 Jan Peter A Supermarket Cheese 30 33 2018 Jan Peter A Supermarket Juice 15 16.5 2018 Jan Peter B Supermarket Milk 15 16.5 2018 Jan Peter B Supermarket Cheese 17 18.7 2018 Jan...

<tbody> Id location start % Id location start % 1234 US Jan 1 100 1234 US Jan 1 100 1234 US Feb 1 100 1234 CA Feb 1 90 9876 CA Jan 1 100 9876 US Jan 1 100 9876 FR Feb 1 100 9876 FR Feb 1 100 7532 US Jan 1 100 7532 FR Jan 1 100...

Im working in power query, I need to acumulate value per month and account. For january I like to only se value for janauray and then for february summed value for jan and feb and so on. Is there any formula that ca create the coulumn Acum Value below? <tbody> Account Period Value Acum Value...

Hello I have literally rubbed my eyebrows away trying desperately to create a dynamic line chart with columns A, G and H from the below data, so the chart shows only the most recent 90 calendar days entries (NOT the last 90 entries - please let me know if it's necessary to insert a daily entry...

I am trying to import a CSV file into excel via VBA and have it split the text into several columns based on "standard"-delimiters such as "," and also split it at certain words appearing in the text. Below is an (edited) excerpt of the csv file: (The current file is about 700 lines, but will...

How would I use a Sumproduct to calculate V7, W7, X7 &Z7? (For April) I was able to use the Sumproduct for Jan, Feb, March, but am having trouble including April... <tbody> V W X Y Z Jan Feb Mar Q1 Apr 7...

hi, can anyone help me with the following, i need to get a data from a text file and write specific contents to excel if the condition exist on the line. below is the content of my text ---- 2019-01-10 13:59:45 Local2.Info 172.16.66.1 Jan 10 13:59:35 stamgr: tac_del_arp:dev=br0...

<tbody> A B C D E F G H JAN FEB MAR APR ACT FCST BUDGET BUDGET X X </tbody> Hi All, I have question. I have a range of columns above. Each month uses two columns (Jan uses both columns A&B ex) How do I code the above to show only the columns...

I have a list of data from Jan 2014 - Dec 2018. Is there an easy way to use conditional formatting so all the Jan,Mar,May,Jul,Sep,Nov are filled Gray while Feb,Apr,Jun,Aug,Oct,Dec are Blue? Thanks!

Hello, I am have an urgent task for work and have gone through the various threads on this site, but, I could not find anything. I have to be able to quickly sum the total based on multiple criteria and remove the duplicate rows (Tab "Data". Then only certain columns are copied over to a...

Hi, I have a spreadsheet where each row represents a single person. Column headers (row 4) are: "Days", "Fee", "Invoice amount" However, above each column header is a date (row 3), e.g. 1 Jan 2018, 8 Jan 2018 etc Data is updated weekly and then entered onto this sheet. Where 1st of a month...

I have a sheet that is formatted similar to this... Jan Feb Mar Item 1 2 3 5 Item 2 1 4 2 I need it to format like this for an upload... Item 1 Jan 2 Item 1 Feb 3 Item 1 Mar 5 Item 2...

Hi everyone, I am in need of some assistance. I am trying to determine how many working days in a given month within a given year are available. I know we can use the networkdays function, however I have some constraints that i need help working around. I have 2 rows, the first row reads the...

Hi team, I am trying to do the following. I have a cell A1 that has a dropdown of months (jan, feb, mar...) and that has a name of 'date'. In another tab I have a cell that I want the text to change depending on the month selected in the first tab. So if Jan, Feb, Mar, or Apr is selected I...

Hi, I have a data validation list of Months (Jan to Dec in three-letter format) - Jan, Feb, Mar, Apr etc. But I am looking to have a formula which in the next cell fills in the previous month (in the same format) to what I have selected from the drop-down. Is this possible? Cheers, Dougie

I would like to find a formula that will scan a column to return the date the first instance of a number or higher occurs. Here's a sample table: <tbody> Mo-Day 1947 Jan 1 12 Jan 2 26 Jan 3 20 Jan 4 4 Jan 5 8 Jan 6 22 Jan 7 26 Jan 8 26 Jan 9 20 Jan 10 31 Jan 11 33 Jan...

Hi, I've a bunch of school term dates, and each school has their own method of stating what is the first day or last day of the month (some will say the day before is the first day, some will say the day after, some will say the last week day, etc) & to allow me to better compare i want to be...

Hi Can I do multiple column Vlookup. I searched the internet but most of examples are using Match-Index. I want to learn multiple Vlookup first then I will go to match-index. I am thinking of array function but do not know how to start I have the table below. I want to do the following Enter...

Hi I have excel 2013. I want to consolidate date from 3 different sheets using pivot table not data-->consolidate tool. so i created these 3 tables and insert Table1, Table2, and Table3. I was inside Table3, I clicked insert Pivot and checked Allow Data Model. In pivot table, I created...