sample

  1. Jan Kalop

    perfecting VBA

    This VBA formula is working perfectly, but I would like to be able control, the amount of numbers (in the case of bellow VBA formula is 28) to be random, from designated worksheet cell, for sample A1. The same refers to choosing the Range (which in this sample is 6) to be able to control from...
  2. I

    Making a sign based on critera entered in excel. - Is This Possible

    Hello, We have a form that our buyers use to fill in data that we then save a .csv and import it into indesign and create a sign based off the entered criteria, everything goes to where it should yada yada. I want to know if its possible based on the entered criteria to show a sample sign to...
  3. S

    Random Sample to Pull One Record per User

    Scenario - I have 10 employees, who complete 10 sales per day. My data refreshes each day, so it's just prior day information. I would like to randomly pull 1 transaction per employee to perform an audit. I am comfortable creating a random sample, but not applying a one per user idea.
  4. H

    Best way to show quantities and ratio on same chart?

    Hi! I'm not sure if I can attach a file but here is my sample data: <colgroup><col span="2"><col span="2"><col span="2"><col><col><col><col></colgroup><tbody> Early For Class On Time Late For Class Grand Total % on time Person A 2438 535 546 3519 84% Person B 127 41 17...
  5. N

    Add blank cells

    Good afternoon, I am trying to create a Macro to add a blank cell in-between line. Every month when we do this there is no way to know how many lines we will have. Manually doing these I do the following: Number the cells next to the date and auto fill all the way down. Copy the numbers. Paste...
  6. H

    excel vba : How to replace cell that contains specific text

    Hi, How do I write a code to replace cells that contains "0" in column A with the word at the top row of each 0 group? <tbody> AD 0 XX 0 XX 0 XX 0 XX AC 0 XX 0 XX DE 0 XX </tbody> Above is sample table and below is the output that i wish to obtain. <tbody> AD XX...
  7. H

    excel vba: how to remove the entire row that contains "{"

    Hi, May I know how to write a code to delete the entire row when there is "{" only in column A? <tbody> Column A Column B Row 1 { XX Row 2 {AB} XX Row 3 { XX Row 4 {CD} XX </tbody> From the sample table above, i would like to delete row 1 and 3. I would be so grateful for your help.
  8. A

    To identify the position of the first alphabetic letter in a string and take all values before that letter

    Hello, I am trying to implement within a macro blow how to identify the position of the first alphabetic letter a string and take all values before that letter. This is a part the macro below: If xsplit Like "*,*" Then For I = 1 to 100 'line below where I want to do that Sheets("x").Cells(I,1) =...
  9. S

    Email Notification through VBA

    Hai, still study on this. Is it possible to send multiple email to same user based on cell value in excel through looping process. Pleasure if anyone can share your knowledge with me about it. In one sheets(combination all department listing that need to loop to send email as per department...
  10. R

    SUMIFS across multiple columns and one row

    How can I find the sum of the values in columns 1-3 if column A equals Yes, column B equals FC, column C equals LE? This is just a sample set, the dataset I'm using has many more columns. Thanks. <colgroup><col width="64" style="width:48pt" span="10"> </colgroup><tbody> A B C D E...
  11. C

    Excel can do it! Past Occurrence.

    <tbody> 5 5 2 10608 2 2 2 3 4 5 10607 1 1 1 3 4 5 10606 4 2 4 5 5 2 10605 4 5 3 4 4 3 10604 2 3 5 1 2 1 10603 4 5 4 4 1 2 10602 5 5 3 3 4 5 10601 5 4 2 5 3 4 10600 4 3 4 1 5 5 10599 5 4 1 2 2 5 10598 2 4 5 4 3 2 10597 3 1 3 2 3 1 10596 2 5 1 5 5 1 10595 2 1 5 2 5 2...
  12. J

    Help with wiriting macros

    Hi, I am very new to writing macros and am hoping someone with more knowledge and experience can help me! I want to write something that will essentially replace the find and select function between two worksheets. I have a pivot table with sample numbers in column A on a tab called "Test on...
  13. S

    How to Remove duplicate names within excel cell

    Hi, For now, I am cleaning all list manually and taking long hours to . Here are the sample list and sample results Blackledgedblackledge@riverhillsbank.com Vanderhoffmvanderhoff@franklinloans.com Stanwixastanwix@greenwaldindustries.com Smithjacques.smith@greatwesternbank.com...
  14. J

    Average of columns (iteration)

    Hello everyone, I am very new to VBA so excuse me if my problem appears to be trivial for some of you. Let me explain the situation : I have a table consisting of 96 columns and 160 lines. I have been measuring things in triplicate, so each three columns are concerning the same sample (A B C...
  15. K

    Add Pivot Table Column that Calculates Blank Cell Values

    I'm having trouble adding a column to my pivot table that indicates what % of sub-items are not blank. For example: I would like to get the value in D2 (10%). It's calculated by taking 1-90% (C3). This value indicates that "Sample Item" sold with another item 10% of the time. Data...
  16. P

    Frequency of unique values based on a single criteria

    Hi there, I am trying to find the number of non-repeated (unique/frequency) family names in each grade. I have prepared a sample and uploaded to one drive. I would appreciate it if someone could help? https://1drv.ms/x/s!AgQdYsSdg735fXy_R4rJuVlmcuw
  17. U

    Merging Results in 1 Column

    <tbody> Base FINAL STATUS DATA 1 DATA 2 DATA 3 Apple ok Orange no Mango sample Banana no </tbody> Based on the table above. I would like to know how can I merge the data from columns DATA 1 to DATA 3 into the FINAL STATUS column. Like the TABLE below. <tbody> Base FINAL...
  18. N

    text in cell based on value of another cell

    Hi, I have a scoring system that I would like to display text in a cell base don the score. For example, should the score be between 0 and 1.5 in A1 then this text will display in B1. "This is a sample text". Should the score be between 1.6 and 3 then different text will display in B1. Hope...
  19. B

    VLOOKUP And Return Multiple Corresponding Values

    HI I have a table that looks as follows <tbody> customer # and invoice number note 1 note 2 AA~123 SAMPLE 1 SAMPLE 2 AA~456 SAMPLE 3 SAMPLE 4 AA TOTAL SAMPLE 5 SAMPLE 6 BB~789 SAMPLE 7 SAMPLE 8 BB~111 SAMPLE 9 SAMPLE 10 BB TOTAL SAMPLE 11 SAMPLE 12 </tbody> my goal is to put in...
  20. P

    Create a list of base sku's or product groups

    Please help, Skus are in column A, Color is column B, All I need is if column B =Satin Bronze remove 10 from the end of the sku of column A There are about 15 finishes so I will need to edit for each one but thus is the best wat to get to the base sku's. In the sample row 1 is Satin Bronze and...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top