trouble

Hello! I have a workbook that is organized by clients' names - one sheet for each letter of the alphabet. Each sheet is identical, and tracks sales dates and amounts. Named range for sheets = "sheets" Dates in column A Amounts in column B I am looking to sum the total sales for each month...

I'm trying to convert the below averageifs formula to median formula and am having trouble. Help? IFERROR(AVERAGEIFS(SA_Comp[Turnaround],SP_Comp[Individual],$B$10,SP_Comp[Request],Stock,SP_Comp[Year],$B$3,SP_Comp[Quarter],$F$7),"-")

Hello All, Would like to see if someone can help me with the following issue: I am comparing the information typed into cells D61, 62, 63, 64, 65 to the static information in cells C61, 62, 63, 64, 65. This is how the static information appears in the C cells: C61 has 2:00 C62 has 3:00 C63...

Hello, I need Excel to detect the last column I have and sort on that column. I have a macro that generates a new column every time it is used so I cannot use a constant. Here's a screenshot of the sheet. I am having trouble with getting it to sort by the last column. Can I define the...

Hello, This is a spreadsheet I've been using for some time now and the embedded file was working. Today I'm having trouble opening the file. When I click on the file it's selected as though I want to copy of move the file to another location. Thanks bell1958

I wrote this formula a long time ago and it seems to work, but I am having trouble understanding what I did.. Can someone help me figure out what is going on here? VIPs (C2:C6) =IF(IFERROR((-2.5*$B2)+(1.5*$A2),"")<=0,"",IFERROR((-2.5*$B2)+(1.5*$A2),"")) How many VIPs do I need to have the...

I'm sure this has been asked a million times so I apologize for the repetitiveness. Having trouble entering multiple formulas in a cell Example what I have so far: In Cell A1 =IF(A2=7, "A") That means if cell A2 value is 7 then it will put an A in cell A1. Got that good so far. How do I...

Good afternoon Folks, I have run into a small issue using Excel. I have created a drop down list, and i'm trying to figure out how to subtract how many times a name were to come up. for example If i have 35 tickets to the movie jumanji, If i select from the drop down list Jumanji could i now...

Hi, having trouble converting the intervals below which are TEXT. I need to convert 00:00 01:00 01:30 02:00 To 12:00 AM 12:30 AM 1:00 AM 1:30 AM 2:00 AM

Hi im in trouble, <tbody> Name Total Adsmi 1 Adsjj 2 Adshh 3 Mahh 4 Makk 57 Maiis 9 you 900 Yopp 6 Yodd 42 </tbody> Hi all, i need to sum up all the amount for the same name in front. For example, first three row same name in front which is "ads****" which total will be 6...

Hello all, I am not new to Excel. However, I have trouble creating V Lookup's. What is the best way to go about learning to creating a V Lookup? Ebony

You guys helped me out last time and now at another sticking point. I'm looking to highlight excel columns for appointments that happen today and anytime in the next 7 days, but having some trouble. I tried: =$A2>=TODAY()+7 and it formatted all of the dates 7 days from today forward, leaving...

Having trouble with a chart. The date is in hours format. So it'll say something like 3:02. However, it is not formatted in excel. If I look at format cells to see how it is formatted it just shows as regular number. Anyway when I go to make a line chart with the data, it does not even...

Hello, I was just wondering if there were some type of short cuts or easy ways to recall or create any specific formulas? I am new to excel and sometimes have trouble creating the formulas. Thanks in advance to anyone who can help:).

Hi Everyone, Thanks for taking the time to look at my conundrum. I'm having trouble with the following formula: =IFERROR(If(and((NETWORKDAYS($C2,$D2,0)>5,networkdays($c2,$d2,0)<=10),1,0),0)) I have a date entered in column C2 as: 8/1/2017 I have a date entered in column D2 as: 7/17/2017...

I am wondering if someone could provide some insight; I am having trouble getting over the concept of ranges - why I am having trouble with Range(Cells(4, 3), Cells(88, 12)).Copy and no trouble with Range ("C4:L88").Copy I thought I may have read somewhere where it has to do with...

I have this equation in cell a1: 15x2 + 13x – 20 I want to pull out the coefficients and the constant in three separate cells. I use =LEFT(a1,FIND("x",a1)-1) to pull out the 15…..I am having trouble pulling Out the 13 and the 20 Help please The function should work with other similar equations...

Hello, I have been trying to pull some data via Index(match. The match function is not working and I'm not sure why. I can see there should be a match and cannot figure out why. I've fiddled with the cells format each individually, then by Text to Columns.. No luck. I asked excel if the two...

Hello All, First time posting and I haven`t been able to find an answer to this on the internet so here it goes: Is it possible to have a cell reference data on a hidden worksheet? I have many reference sheets that I am hiding to clean up the workbook and I am finding it impossible to get the...

Hi all, I am new to VBA and have been facing a lot of trouble with figuring out how to pull data from the website boxofficemojo.com. I am trying to extract weekly data for the years 2010-2015. So i found a code that did something along the same lines and changed it to suit my needs. It is as...