1. S

    Display values only of the first X Occurences of a condition in a small range .

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

    Count values between two dates (show sum per day)

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

    counting ranges of negative time values

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

    Remove duplicates AND first occurences

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

    Remove symbols, Punctuation marks from list

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

    how to find first and last instance

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

    Hi. Is there a formula to average multiple occurences of the same numbers without using a range?

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

    Counting Number of Students Registered per Semester

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

    search macro retrieving all occurances as well as partial matches

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

Some videos you may like

This Week's Hot Topics