sample

I have below column hedaers from BK11 to BZ11. These are basically steps in my projects. I have a drop down in AW11 which i basically update once the status changes of a particluar project. I have 10000+ such project with each row as 1 project. I want to basically track dates for each step. So...

I have a named range table "LabData2" with >30000 lines of analyses with multiple sample names and multiple samples per day for a 1 year period. Table column headers ColA ColB ColC ColD...

Hello I want to learn how to import/export cvs to excel. I am looking for a cvs file that I can use to do that. I tried to search the internet for a sample of these files but could not find any. Any idea where to find a sample of these CVS files? Thank you so much.

Guys I need some help. I need a way to do a filter to where I can just type something like this and get the result 82CL10, 182CL21, 82CM10, 282CM29, 82CM32, 992CS12, 82DT152 and filter just these results. Is this at all possible? I have attached the excel file and a pdf of a sample of what I...

Hey all, got a hairy one for ya. not sure if its a Vlookup/If combo or something best solved with Macros (or both!). Kinda stuck on where to start hah. I work in a lab, I'm currently building a spread sheet to perform unit conversions based on a test code for a range of tests. I currently have a...

Hi All: I am new to DAX and written the following formula which analyses the data correctly but the Grand Total on Pivot table does not equal to the sum of the individual rows. Adjusted Sample Find:=if(DIVIDE([Sum of Sample Count Find], [Weight])>=[Rounding Limit], ROUNDUP(DIVIDE([Sum of...

I'm trying to sort and extract data in excel and I'm not sure how/what the best way to do it would be. I will be using VBA for this project. In summary, I'm trying to create a schedule that populates automatically for the instructors in our division so they can then print and post on their...

Hi. I have a table containing 3 columns: Location Sample Date Transmittance % value I've added the table to the Data Model in PowerPivot. I need to summarize each location with the average Transmittance% from the latest "N" sample dates. For example, the average trans% for location "A"...

Hi Every one, I want your help regarding conditional sum. I am using EXCEL 2003, that don't have SUMIFS function. I have data as Column A= number of sample Column B= Status C=complete, P=pending Column C =Date <tbody> A B C 1 No. of sample Status Date 2 10 P 20/12/17 3 11 P...

Hi, I want to take sample data from a huge data for audit purpose. The data has columns "User" and "Category", Unique Users - 45 and Unique Category - 27 (number of unique users and category may slightly vary day by day). I need to take 50 sample records out of 5000+ data. I should cover all...

Hi excel master I need help solving cases looking for and combining and also sum the same data from my sales report. and here is my sample data A B C D E F G 1 apple manggo banana orange apple apple banana 2 orange peach apple peach banana apple 3 apple...

I have a table with data and need to calculate the commission payable based on the units achieved. If for example a person achieves unit sales of say 615, the calculation should be =(615/700)*1000 -see sample data below I need formula that if the unit sales is higher than the amount looked...

How to set in formula waiting time before the command is run. For sample =hold on for 10 sec before IF(SUM(A1:A20)<0,"",SUM(A1:A20))

Hi Everyone. i am trying to scrape li tags that shares the same class name the HTML cods looks like this: <ul class="top-section-list" data-selenium="highlightList"> <li class="top-section-list-item">sample text# 1</li> <li...

Hello people, <tbody> <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>sample sample sample sample sample (sample: 111-1234567-1234567) 111-1234567-1234567 </tbody> I'm looking to create a formula to remove all text and special...

Hi dear friends, i am struggled with copying data from html notepad file. please help for this task. here my sample files www.transfernow.net/21jpp4k2x1fg Thanks in advance!!

<tbody> NAME (A1) EMAIL (B1) SUBJECT (C1) TEXT (D1) ATTACHMENT (E1) Andy (A2) ah@mail.com Auto email Dear (insert name) Andy This is a sample of the body text to be included in the email message. Signature Attach PDF 1 Harry hj@mail.com Auto email Dear (insert name) Harry This...

I need to calculate the standard deviation based on two criteria. Criteria 1: Date Range. The sample must fall between two years. Criteria 2: Sample must be labeled as NV. I have well over 7000 samples so here is just a very small sample. For example, I would like to find the standard...