sample

Hello everyone, I performed a small research but could not identify a code for my need. I want to create a sampling file in excel, that will have the population size in cell b2, and the required sample size in cell b5. (The required sample is to be up to 40.) I want to create a macro that...

Is it possible to use excel to find if a particular set of coordinates falls within an area (composed of coordinates, like a fence)? In the example below, I have coordinates for all four corners of a made-up home, gym, and work site. I am trying to see if Excel is capable of recognizing what...

Hi all, Every day I generate a text log from a software into a folder on my computer. Folder contains PDFs along with the text logs from each day. The text file name has the date and time stamp on it. The same date and time stamp is also contained within the first line of the file content. I've...

Hi, I have a table of data that looks like below. I need to be able to rank seperately both the TS & TM division sales whilst only looking at certain criteria, in this case 66 and 67 but these numbers just a small sample. My actual worksheet is a dump with over 30 different Area's...

Hopefully someone can help me figure this out. We need to keep the regular file (AP Check Register) from our accounting system to complete account reconciliations. The problem with this is that when there are checks that are cut that have up to 5 or 6 accounts, once you filter on one of the...

hi all I'm trying to build a macro which has some function to eliminate the same value based on column. and here is my sample data <tbody> A 1 one 2 one 3 two 4 two 5 one 6 three 7 three 8 two 9 four </tbody> the result i want to display is like this <tbody> D 1 one...

Hi all I have two different types of data that I need to combine. with the data that I have, in column A I have sample sites (example cell A1 contains PW1) and in the column B I have sample date (example cell B1 contains 01-03-2018). What I need to do in cell C1 have an auto calculation that...

Hi, New to using Power Pivots, however I don't think this is necessarily a beginner problem. I am trying to calculate the variances in my power pivot between two columns which contains forecast values, under the header of Month (when the forecast is applicable) and the subset of Forecast...

I'm working with a rather long list that I'm trying to add to the end of a spreadsheet. I know there are formula's out there that can go to the next empty cell in a row or a column, but I need a vba code that can go to the next empty cell in a row based on the first column's value. For example...

Hi Everyone - This might be explained easiest by the sample table below. I'm looking for a formula that will take my inputs (Month & Year) and return the value from the last available date in that month/year from the table. <tbody> Month: 3 Year: 2013 NEEDED FORMULA: 1563...

hi all friends.... i know how to create a Hyperlink and go to other cell in other sheet. but the problem is the name of the hyper link is static..... my cell have a Quantity... and it change constantly.. i make a Dashboard panel, i want user click (sample) on cell C5 with cell value...

Dear All, I have a data set spread across thousands of row. Below is the sample for the same. I would like to calculate rank based on the Region & Category. The sample data set is spread across A1:D7. <tbody> Region Category Sale Rank A Z 100 3 A Z 140 1 A Z 105 2 B C 170 3 B C 215 2...

I have the below code to bring information over from another spreadsheet, but every time I run the macro, I get a runtime error on the bold section. Can anyone please assist? Private Sub CommandButton1_Click() ChDir "C:\Test Sample Upload" Workbooks.Open Filename:= _ "C:\Test...

plz look into the sample file everything is mentioned in my data go to each row search for highlighted cell if yes then edit row as per given condition in the sample file and if not then simply copy and paste that row don't do anything with that row see the sample file...

Hi everyone, This is my first time posting here, but I have often used the great advice found here! I'm hoping you can help. I have an excel document that has a table at the top and then a section below that is auto filtered. It was working fine until yesterday. Now when I try to copy and paste...

I'm having trouble filtering what's in a pivot table using VBA. I have a large pivot table, but for sake of brevity, the attached sample is essentially the same thing. In this sample, I'm getting kicked back with a 1004 error that it can't find the referenced PivotField. Here's the code...

hi all i have 6000 rows grouped and sumarized. my question is: i need a total of Total: if i sumarize by sample: =SUM(A1:A6000) it duplicate the sum understand me? i add a imagen.... with small sample.... here my small sample: https://imgur.com/J0ixymC Thanks

Hi All. I have a list of product codes , which I would like to turn into product categories in the next column (sample product codes attached). The rules are as follows: If the code contains the letter L and either an L or an E, then the category is LL. If the code contains the letter L and...

Hi, I have a very basic question, please can someone advise if it is possible to repeat the header on all rows for that specific account? sample below in link: https://photos.app.goo.gl/fYOlD51o6b5AumBp2 Where it says sample company 1 i would like that to repeat in say column a until it hits...

I'm new to Access (moving over from Excel because the databases were too big) and I was wondering the best way to duplicate how excel manipulates data. I have two tables that need to interact: Table 1 - Gas Component Percentages in a sample (Methane, Ethane, etc.). Each sample processed is a...