mar

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

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

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

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 = "richard.sabbara@xxx.com" .CC = "" .HTMLBody = MAR_Message_SECURE .Attachments.Add "" .Send End With End...

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

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

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

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

"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

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

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

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

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

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

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

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

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.

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