occurences

Hi... Could anyone help me with a solution to this. i am wondering if there is a function that will help me find... say 1st/2nd etc occurences of a condition in a list ? e.g. I want to pick out the first 3 numbers (say) that are over zero. so if my list is 0.00, 23.45, 45.67, 0.00, 0.00...

Hello guys, I would like to ask you for bit of help...I have table like the one below and What I would like to do is to have in next column all days in year and show how many occurences are at that day...source table is the one below where I have ,,From" critera, "To" which are dates between...

Hello everyone, I have giant file containing various time values. I have to sort those times according to frequency. What I managed to do is to sort them like: 00:00:00 123 occurences between 0 and 1 456 occurences between 1 and 2 789 occurences etc... What I cant do is same...

I wish to remove all the duplicates AND the first occurences of those duplicates, all in one go. Everywhere I look, it explains the process to remove duplicates and retain first occurences, which is pretty standard, but my workflow requires something different. I need to remove both the first...

Hi Friends, I have a huge list of Names which includes first, middle, last names and along with their titles, education etc., for example Tina DeRubeis van Zyl May Wen-Li Rebecca Hodson, CPA, MST David P. Kraus, Jr. Heather Findon, CPA James C. Lawson, JD, CPA, MST Bruce Feinstein, C.P.A...

Hello guys, I have made following code that check several statements.. if the value in column "H" have value"MLY" then check column if value is "I" if the value is "MLY" and if the value is more 0 in column "B" and "AB" same row. For the same row but column "A" make a string of the value...

For example: I have eighty three occurences of 5; ten occurences of 4; and two occurences of 3 In a range the average is 4.85 But I want to use a formula to show within this worksheet: <TABLE style="WIDTH: 700pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=932...

I'm looking for an easy way to take a student's academic plan (for the next 2-4 years) and match the classes that they take with the semester they take it, and then do that for 175 other students and counting. The semesters will change depending on the students, but they all take the same...

Hi there<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm working on a database for a Dutch nursing home, which - if I ever get it to work properly - will eventually contain data on several hundred people. To help users navigate through the...