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...
thanks Greg,
I will need to the number of counts for each unique combinations
i.e. I will want a table produce like this
A B C
GFRD38402DE G3324-29 34
GDYRK3520FD G3324-29 4684
GFRD38402DE E4582-53 56
etc...
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...
Dear all,
Thank you very very much for all the help and suggestions you have listed above.
I am very grateful, and problem is solved!
Many Thanks again!
Dear all Thanks very much for your help!
IDS,
Unfortunately, List B times DO overlap with more than one List A time, hence I have been scratching my head for the past days to calculate the time. Could you suggest any development I could do on your spreadsheet to achieve so?
Many THanks
Felix
Hi Drawoh,
I think you might have misunderstood me.
I need to find the total duration when the events in list A happen at the same time as the events in list B.
Not the duration of the events within the lists.
Felix
Thanks for the Reply IRStuff.
I do have project as well, can you tell me how should I be using in project to calculate the total time I need?
Many Thanks
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 IRstuff,
Thanks for the response.
if there is no blanks or any unwanted values, your method will work.
However, I have some unwanted values that I want to take out.
Hence below
a b c d e f g h i j k
15/01/2014 03:01 15-Jan-2014 03:01:01 Wed 13 12 8 14 12 8 9 58
15/01/2014 03:02...
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...
Thanks for the help.
=A3-MOD(A3,1/(24*60)) worked perfectly. I used Index and match to extra the data at the end. Thanks for your time.
Much appreciated!
Felix
Thanks for the reply, The current dates are defined under the catergory of customer, as "dd/mm/yyyy hh:mm" type, e.g. 15/11/2014 04:49. Although seconds aren't being displayed yet, when I tried to compare two dates, they still look at the seconds as well.
I shall have a go at your formula...
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...
I tried to use plot and scatter, but I still get the a big gap, for my particular case, the bigest gap I have is about 16 days, my senors take samples every minute. I am relatively new to matlab, and I have a feeling I am missing something fundamental here.
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...
