var

Hello! I am hoping some brilliant minds can help me out here. I am working on a Excel forecast model that will be constantly updated as we forecast and re-forecast expected company revenue. I can easily do versus static target and versus static LY. However, what I also really want is to somehow...

Hi Guys, I cant get this done and some help would be awesome. I've got 2 measures. 1st measure calculates count of ID's based on certain filters 2nd measure does the same I want to know if there are same ID's in both measures and count the similarities. I already tried to do something...

Hi All - Sort of a conceptual question here but if anyone has thoughts/advice it may save me some time. I'm using the Sumproduct formula below to filter a table for certain rows (base on values from a lookup table), make a calculation, and then sum the results. Typical stuff for Sumproduct...

Hi All I am having a problem with making a script. I am making a script that will delete a row a week after something has been approved. As of right now i have this which when a dropdown is selected as "YES", another cell gets the current date entered: function onEdit() { var ss =...

Hi folks. I am at a loss here and am not sure what i am doing wrong. i am trying to click on this link: "Document Browser " isn't it as simple as... (this is what i started with) Sub clickthebutton() Dim IE As New SHDocVw.InternetExplorer Dim HTMLDoc As MSHTML.HTMLDocument Dim HTMLInput...

Hi, in the code below I am trying to reference the column number within setColumnFilterCriteria from the named range AttendeeStatus so that this piece works no matter where this column is. Any ideas on how to do so? function FilterAttendees() { var spreadsheet = SpreadsheetApp.getActive()...

The goal is to convert any file that can be read by MS Word and convert it directly (and hopefully quickly) into a text file. I swear I had this working at one point but it's certainly not working anymore. I don't recall where I got the text in blue, but I don't know if I have the syntax wrong...

Hi All, I am using a disconnected copy of my Date table as a filter in a measure. The user selects a FinancialPeriod from the disconnected table and the measure is shown in a table with rows of FinancialPeriod from the original Date table. The purpose of the measure is a kind of 'Where are...

Hey, I'm currently struggling trying to get this code working so I was hoping for a helping hand please? 　 the situation is: I have varying products that produce the owner's name as the outcome depending on circumstance. Initially I had it working fine from reading one column of info, but hit a...

Hi Everyone, I have had a scan (search) through the posts but am unable to find something on this, so sorry if I missed it, or searched wrong... I have an Access Database and am trying to pull information out of it into excel based on 2 dates within cells, now I can get it to pull the...

Hi Everyone, I found this great macro from Ben Collins which will pull gmail data based on labels. His macro was more complicated than I needed with removing duplicates. Though his only had the name and email, whereas I need the date and subject as well. The error I am getting is the final...

I have a calculated column to categorize spend types in a 8+ million row table. The existing version posted below works, but I need to add one more variable (potentially doubling the number of categories) and when I try it works in the data model window but Excel goes bye-bye when I go into...

Hi, I'm hoping for a solution to my predicament. I have an external data sheet linked via power query - the table contains names, certifications and identification numbers. My problem is that some of the students names are missing; however, their corresponding ID number has populated in every...

I am looking to create a scatter plot in Excel and looking through the other posts have not seen how to accomplish what I am looking for with the format of my data. I am managing 40+ projects and would like to show the variance by month of forecasted spend versus the actual. The resulting...

Dear Community, I would like assistance to resort a series of logistic regressions tables that include (1) the variable name; (2) the standard error; (3) EXP(B); and (4) a starred version of significance level. I have a series of tables one after the other in a single sheet, which use the...

heyy please help i have a table with 4 columns. the first column is the name and the other, info than belongs to the firs column . i have try to make a macro for this but its not possible becouse the name dosnt appear in the same row. exp: Itay (my name) appear sometimes in row 3/6/7/12, but...

<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier...

Hi there. <tbody> GRADE / LEVEL / XXHRS / FF/RU HRS / - XX / X / 4 / - / - RU / X / - / 4 / - </tbody> I have 3 columns. column "GRADE" is a "DATA VALIDATION" containing inputs XX,RU,FF. I wish to tab or enter over the cell that needs no input (-) when the certain input in...

Hi Guys, Please help. I am trying to count the number of days the adjustment user worked from a data set with multiple records for any given day. <tbody> ADJUSTMENT USER POSTING DATE KXE KXE KXE KXE KXE KXE KXE KXE KXE KXE KXE 1/01/2018 1/01/2018 3/01/2018 3/01/2018 3/01/2018...

Hi Mr. Excel users, I have a simple problem that needs to be corrected. Here is my code: ~~~~~~~~~~~~~~ For Num = 1 To TotalDuplicatePerCase Rows (1) .Find (What: = "New Value"). Select ActiveCell.Offset (Num, 0) .Select On Error GoTo...