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...
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...
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...
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...
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...
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...
