data

  1. S

    Comparison between two data tables

    Hi I need a vba code which could compare 2 worksheets which has data in different sort order The data tables have no primary key and I need help in identifying how this can be compared to identify differences by reducing manual effort Once the data is compared between 2 worksheets, the code...
  2. G

    Data best fit?

    Hi all, If I have a range of numbers to 2 decimal places in column A, for example from -2.52 to 3.84 with intervals that are not the same -2.52, -2.49, -2.48, -2,42, -2.42, -2.41, -2.38....... 3.65, 3.69, 3.70, 3.80. In column B the number in the cell adjacent to -2.52 is 20 The number is the...
  3. T

    Calculation including two cells if both have data or one

    I need to create a spreadsheet to calculate the total of two or three cells depending on whether just two or all three contain data. A3 contains an amount of money B3 contains a number from 1-12 C3 contains another amount of money (if input) The total in D3 will either be A3*B3 or A3*B3+C3...
  4. N

    Dynamic Reporting Calendar in Excel

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col...
  5. D

    Using IPhreeqc in Excel

    I can't get excel to do what I want after creating this VBA script: Sub sbCopyRangeToAnotherSheet() LastColumn = ActiveSheet.UsedRange.Columns(ActiveSheet.UsedRange.Columns.Count).Columns For n = 63 To 63 For i = n To n Worksheets("Data").Activate...
  6. G

    Data Validation

    Hello all, Trying to add multiple data validations for a cell and having hard time getting conditions to work. Restrictions are numbers between 0 and 100 or just the text value of x. Any suggestions would be great! thanks!
  7. L

    VBA - copy new rows from different sheet, if condition is met

    Hi, I am VBA Excel coder since yesterday and I am stuck. Hopefully you can help me. I am managing sports team and want to follow players training progress. I have made google forms page and linked it's workbook to my computers excel file to update it automatically via Data - New Query - From...
  8. S

    how to get a worksheet to update without opening another workbook and without using vba

    Hi All, I have a workbook that pulls data from another workbook. At present both workbooks have to be open for the data to pull through. What I am wanting is a way to pull the data from 'workbook1' to 'workbook 2' without 'workbook 2' being open. I cannot use vba as I also have another workbook...
  9. J

    Getting an exact match in a search

    Hello, new to VBA, so forgive my ignorance. I created a spreadsheet which I am adding data and assigning a number to the data. I have a search setup to make sure the number I am assigning is not already used. It works great except it cannot differentiate between say 75 and 175 or 1075, which...
  10. S

    Advanced Filter query - What are the rules with editing the extract?

    Previously, I have done an Advanced Filter query, with the Extract in the same Workbook, and: 1.) Sorted the Extract 2.) Made some changes to the Extract Sometimes this had a bad effect: With whatever change I made, it did the same thing to the rows above and below it - unwanted changes Other...
  11. M

    Power Query not loading data - Stalling

    Recently I have had both relatively small power queries (180 rows, 10 lines of M code) and larger (approx. 6000 rows, 25 lines of M code) stall at the load stage. It happened first with the larger query and I thought it had to do with the size of the query. But it has now happened with smaller...
  12. glfiedler

    Userform in add-in must be clicked before it is "active"

    I have created an add-in that functions perfectly except for one annoying thing. The add-in creates a new workbook by copying the add-in's first sheet. This new workbook is then populated with data from an archived workbook that the add-in has opened. This works well and I can watch the data...
  13. D

    Search Sheets Help

    I have an idea for a search sheet that i have no idea how to create, and am looking for help. I would like Sheet 1 to just be a search box and you can type in an address, and below it will be a table that will show the results that match your search. The matched search data will be stored on...
  14. Trevor3007

    find many based on a certain criteria

    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet 2 that contains a specific word ( ie Adobe) This would than display the data on sheet 1. A bit like vlookup, but vlookup as you are aware only picks...
  15. G

    Power Pivot guidance - data structure and avoiding many-many relationships

    Hello, I’m looking for some guidance on how to build my data set, so I can effectively use Power Pivot to present my results. In my attempts so far, I have come up against the challenge of many to many relationships when trying to create relationships between my tables. I have tried to create...
  16. P

    Expiration date formula in large spreadsheet; avoiding Data Model

    Hello all. I have a fairly large data set (30,000 lines -will grow to 50,000) which is a set of employee payroll records. I am hoping to identify a particular type of rule violation - when a worker who has worked both as a "Temp" and as a "Part-Time" has worked hours in violation of the rule...
  17. H

    Insert rows with formulas based on a cell value

    Hey, Please I need help in this case; thank you in advance! I insert data and have the data in Table1 in Sheet1: <tbody> A1 DATA B1 Order =COUNTA(A2;A1000) (result: 2) A2 Car 1 B2 25 A3 Car 2 B3 45 </tbody> Every time I insert new data, new data might add/cut rows to/from this table...
  18. C

    Text Format

    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is always 4 digits, it was a data code. The issue was end-user sometimes forgot to put a "space" before and/or after "/". how can i custom the cell format...
  19. B

    Transfer Data from 1 sheet to another given conditions.

    Sheet 1 and 2 are a Timesheet setup in a table. Table1 Sheet1 and Table2 Sheet2. Sheet 1 is the 1st 2 weeks of the pay period, Sheet 2 is the second 2 weeks. Formulas in the Table autofill in case a new row needs to be added based on spit days. What I need to do is copy data from 1 of...
  20. L

    SUMIF matching 2 cells

    Good afternoon all, I am having a problem as I modified my excel workbook and I am unable to find the sum I'm looking for. I keep getting #Value ! I have dates in cells P1 and P2, start date and end date. This is located on a sheet called Records. I have a datasheet that is full of data from 3...

Some videos you may like

This Week's Hot Topics

Top