jan

  1. S

    Count unless text is in a list

    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'...
  2. M

    Formulas

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

    Required auto insert of Mismatch Data

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

    Help with monthly average

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

    how would i separate these entries from my credit card statement into coherent columns?

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

    Excel formula to update values for specific columns only

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

    SUMIFS and IF formula for this problem?

    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)
  8. J

    find nearest date

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

    Best way to calculate rolling 6 months average

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

    Transpose every 2 columns into new row, moving to new row after last column

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

    Find and show the strings

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

    SUMIFS Units and skip such values

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

    SUMIFS Using 3 Distinct Criteria

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

    How to remove irrelevant months from the X axis in a bar chart?

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

    Generating next worksheet tab name

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

    Linking cells to pivots

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

    Dynamic calendar and locking each month

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

    Max based on different column

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

    Offset Formula - Rolling total

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

    How to transpose

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top