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

    offset cell reference

    Hi! Wondering what the best way to sum a number of columns based on a particular cell which is dynamic. <tbody> I can use this formula when E3 is static, but wondering how to get E3 to be dynamic based off a cell value <tbody> =SUM(OFFSET(E3,0,-3,1,3)) </tbody> </tbody> Example below...
  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. D

    Subtract an amount from a cell, then move and subtract from the next available amount

    Dear All, I have tried to subtract the Overdue Invoice Amount, It should go like below table. <tbody> A B C D E F G H I J K L M N O P Q R S T U V W X Y Z AA AB 2 AMT $ TTL DUE JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC PAID OD BAL. TTL JAN...
  5. R

    Formatting a Text String in VBA

    I have the following macros that work: Sub AAA_test_MAR() Set Mail_Object = CreateObject("Outlook.Application") With Mail_Object.CreateItem(o) .Subject = "Monthly Action Report (MAR) " .To = "" .CC = "" .HTMLBody = MAR_Message_SECURE .Attachments.Add "" .Send End With End...
  6. 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 2.52 Apr 01 Apr 02...
  7. T

    Text to Date > Mar 1 2008 12:00AM to 03/2008

    Hi, I'm looking for a formula that will convert this string of text to a date format. This Mar 1 2008 12:00AM To this 03/2008 Thank you, Tracie
  8. C

    Formula to pull up column/row head based on cell in data set

    Hello, I'm looking for 2 formulas to identify: 1. Column header for selected cell. 2. Row header for selected cell. Example: <tbody> Jan Feb Mar Apr Company A 1 2 3 4 Company B 5 6 7 8 Company C 9 10 11 12 Company D 13 14 15 16 </tbody> If the value selected is 10, I want cell F1...
  9. E

    Is what I'd like to do even possible?

    Hi, I've taken plenty of advise from this forum, so much so that I've only needed to register now, so thank you all. I get data from external sources in the form of a table that has every month of a year. I'm looking for a way to automate the transfer of a specific month's sum to another...
  10. N

    Extract data from text string

    "Mon, Mar. 11, 2018ABC, FGHO117 Comments" I want to extract from the above text string, "Mon, Mar. 11, 2018" in one cell, and "ABC, FGH" in another cell. Is it possible without using VBA? Thanks
  11. S

    Figures based on month selection

    Hi Experts - Please give any formula I want to get the figures in row 3 for each month based on selection of month in cell A1 as per the given example below, in Mar and Apr figures are showing zero Suppose if I select Mar in A1 only Apr should show zero rest of the months should take sum from...
  12. R

    Group Cells

    Hello, I am be asking to much but is there a way to group cells based on a date? I have a row with dates (I8:ID8) from Feb 11-Dec 27. Columns B8:H8 are tasks/completion/start dates and columns I:ID are conditionally formatting to fill based on inputs to B:H. My want is this: For today, I want...
  13. I

    Two complex formulas returning incorrect values

    Hi I'm having trouble returning the correct values in the 2 cells shaded red in the below sheet. My objective is to show the ongoing corresponding number of miles cycled up to the same date in the previous year. The correct value for the current YTD total is the sum of cells C64:C93, which is...
  14. J

    VBA solution for selecting a range of months

    The purpose is to select a month from data validation, and other cells populate future months. Then when selecting a different month those same cells change. Is there a way to capture multi months in different cells when a case is selected? Selecting Jan, D2=Feb,D3=Mar,D4=Apr Selecting Feb...
  15. S

    Transposition lookup

    Please help me to bring data from Horizontal array to vertical area. <colgroup><col width="64" style="width: 48pt;" span="8"> <tbody> Horizontal Volume Profit Product Jan Feb Mar Jan Feb Mar A 10 40 70 120...
  16. A

    For each chance in column A, copy column B and fill down in column C

    Hi All, I'm looking for a for a macro or formula that recognises a change in Column A, then at each change, it copies the same row from column B, pastes the value to column C and fills the next months downs until the next change in column A. At the moment I have Column A and B however I want it...
  17. R

    sum with dynamic columns

    I have to do the following If i select Mar , then all the 3 columns should be added , if I choose Fen then the two columns. Meaning the cummulative is dynamic based on month selected Customer Jan Feb Mar ACME 12300 9700 19400 Bluestar 5000 2700 9100 Gentech 18500 23700 31250 Inversys 0 16450...
  18. J

    Repeat a number X amount of times

    Okay so I have two tables: Count Jan Feb Mar April May June July 0 0 1 0 0 0 0 Revenue Jan Feb Mar April May June July 0 0 25 25 25 25 0 How do I make it so it repeats the 25 X amount of times starting from the count? Currently X=4 but this may change.
  19. E

    Power query acumulate sum formula

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

    Creating dynamic chart showing last 90 calendar days entries

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

Some videos you may like

This Week's Hot Topics