jan

In this scenario I am trying to track how many calls a staff member made in Jan. The catch is there are some calls that are not eligable for tracking. The ineligable call statuses are in a list. Is there a way to do this? I'm not great with excel, any help is appreciated! Count if the 'month'...

Hi I have a Workbook which has a sheet for each month and a totals sheet. I'm trying to get Year to Date totals based on the month. ie in cell E1 on the Master Doc tab the month is Jan then in C5 it shows the value from C5 on the Jan tab. If E1 is changed to June 19 I want C5 to show the Total...

Hi Every one, I required a macro or Formula to Auto insert the Row after matching of two Spreadsheets Table 1/Spread Sheet 1/Work book 1 <tbody> Name ID Jan Feb Mar Apr May Jun Jul Aug Ravi 42 10 96 14 ravi 14 10 11 fbgsdf 52 246 455 5525 536 </tbody> Table 2/Spread...

Hello all, after hours spent trying to find a solution online, which was unsuccessful, I decided to post a new thread and see if anyone could help me out. I have multiple pivot tables connected to timeline slicer where user can select time period to view data set. I found online how to get...

For some reason my credit card doesnt give excel statements. How would I separate gibberish like this into columns? I'd like 4 columns please. I used LEFT, MID, RIGHT, FIND commands for the first 3 columns, but then I got stuck. Jan 07 Jan 07 GOOGLE *OkCupid g.co/helppay#NS 2.52 Apr 01 Apr 02...

Hello all, I am looking for an excel formula which would pickup from whole data , here with attached data for your reference. Data available in columns like from Jan to Dec and output i dont want to show everything in one go so only selected months need to be shown in output summary. which...

https://1drv.ms/x/s!AvjBsEPEq12ngUHobzEXQ8yvas2e?e=Otrz6s I wish to unpivot the data but how would you convert the row of 2019.01, 2019.02 etc into dates? (Using Power Query)

Hello everyone, I am looking for a Lookup-function in PowerPivot/ Dax to get the nearest date for a specific date. I have the following two tables: TblVal <tbody> Date Value 01.01.2019 100 28.01.2019 101 27.02.2019 102 30.03.2019 103 </tbody> TblCAl <tbody> Date Month Value...

Hi, I have a graphing maxtrix tab that does all my calculations for my dashboard. The tab has the month names as the horizontal header Jan, Feb, March etc.. For each column /Month I have assigned a month number reference as well (not an actual month number) but a number position. ( I use a...

Hi there, I have a sheet in the following format <tbody> Date Key1 Attr1 Key2 Attr2 Key3 Attr3 Key4 Attr4 1 Jan 2019 1 23 3 43 3 25 1 54 2 Jan 2019 2 23 2 23 2 54 2 23 3 Jan 2019 4 25 1 54 4 43 2 34 4 Jan 2019 3 23 4 23 2 32 4 23 5 Jan 2019 1 27 1 24 1 14 2 44 </tbody> which I want...

Hi all, I need to filter extra content in "column A" just show the Month and Year on "column B" I try to use the stupid method to filter out the month first but not work. B2 =MID(A2,FIND("jan","feb","mar","apr","may","jun","jul","aug","sep","oct","nov","dec",A2)+0,3) A...

<tbody> Units Amount Month 100 2300 Jan 100 0.10 Jan 200 1000 Feb -200 -1000 Feb 300 2000 Jan 300 -0.08 Jan </tbody> I want to apply formula in the column A Units and wanted to skip units if Values in column B is between -0.5 to 0.5, please help based on the...

Good Morning, I was hoping someone might be able to help me out with the following question: I have built a spreadsheet that generates data on a monthly basis for 100 distinct "blocks" (January through December, vertically oriented, 100 times; the example below features only 2 months for 1 of...

Hi all I'm an absolute excel newbie, so please forgive me for my lack of knowledge... I have values for 2018 (Jan, Feb and March) and 2019 (Jan, Feb and March). I've created a bar chart but it is displaying Months between March 2018 and 2019 which I don't want. What I'd ideally like is to have...

Have a work book with 12 worksheets - 1 per month called : Jan 19, Feb 19,Mar 19 etc I am trying to get a formula to read the next sheet in the series. I have it working fine when i manually input the next sheet number but would like say, Jan 19 to be able to calculate the next sheet name as...

Bear with me, I hardly use pivots as I get by by using formulae................... I have inherited a spreadsheet with a pivot table that each month gets "wider" as a new month appears. So eg JAN FEB MAR TOTAL this month, JAN FEB MAR APR TOTAL next month etc etc In cell A1 there is a formula...

Hi peeps. I've come for your help and assistance again. I followed this video on youtube regarding creating a dynamic calendar so you can flip from month to month, without having to use multiple tabs. Which i thought would be great. The only issue i'm having is if a i enter data in any...

My spreadsheet has two non adjacent columns:- Col 1-Col 2-Col 3 Dog-blank-12 Jan 19 Cat-blank-13 Mar 19 Cat-blank-04 Jan 19 Cat-blank-08 July 19 Elephant-blank-22 May 19 Dog-blank-25 May 19 I'd like a formula for Col 4 that shows me the latest instance (from the dates in column 3) of each...

Hi All, I am working with a database that needs the rolling total of the last 3 months. For example, let say we are in June. One column will Sum the total of Mar, April, May. Another column for Feb, March, April. And the last one being Jan, Feb, March. I have figured out how to calculate the...

I have data that is material description July Aug Sept. The forecast is below each month. I will like the format to be Mat Des Jan Forecast Mat Des Feb Forecast Essentially, I will like to transpose the months and Forecast. I hve 80 unique material numbers. What is the quickest way of...