Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: RE776
  • Content: Threads
  • Order by date
  1. RE776

    how to write "if include" within index/match lookup

    Anybody may be able to help? I have a table which consist of 5 columns with headings and about 12 rows of data 1.) References 2.) Group 3.) Type 4.) Class 5.) Product I have 6 rows of data which also consists of Group, Type, Class and Reference. I want to find out what product each row...
  2. RE776

    Count unique occurences based on two criteria

    Hi, I have two columns of data, Column A is product serial number e.g. GFRD38402DE Column B is part number e.g.G3324-29 the values of these columns are duplicated in various combinations. What I need to find out is the number of times a unique combination of column A and B of the same row...
  3. RE776

    Calulating the total time of vairous events (dates) happened in various periods (Dates)

    Hi, I really appreciate if I can get some help on this. I have 300 events (list A) with start and stop dates&time in the format of dd/mm/yyyy hh.mm.ss, and they never over lap. I have another list of events (list B)with start and stop times in same format in list B. What I want to find out...
  4. RE776

    sequantial numbering

    Hi all, I have table which consist of 12 columns and over 65000 rows. Except the first three columns, all date are numerical. The unwanted value in the data are blanks, 0 and 1, although I don't want to delete them. At the moment all data are organised in ascending order based on the format of...
  5. RE776

    Need help on VBA, Finding matching dates (YYYYDDMMHHMM) of two excel documents and extra data

    I have two spread sheets, sheet 1 contains a 2 x 4213 table, [column A = time in the format of YYYYDDMM HHMMSS; Column B are numerical data]. Sheet 2 contains 9 x 6560 table [Column A = time in the format of YYYYDDMM HHMMSS; Column B - I are numerical data]. I want to use some sort of array...
  6. RE776

    Plotting line graph - ignoring missing dates (YYYY, MM, DD, HH:MM)

    Hi, I have a large set of senor data collected every minute for 102 days. In which, 1st columen contains dates in the format of YYYY,MM,DD,HH:MM. And 2nd column contains values, whole number from (8 - 20) My problem is that the sensor wasn't 100% reliable hence there were some gaps scattered...

Part and Inventory Search

Back
Top