Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Search For:

Type: Posts; User: dsrt16

Page 1 of 3 1 2 3

Search For: Search took 0.01 seconds.

  1. Re: VBA code runs in excel 2003, but gives error message in excel 2010

    Your answer seems to be another question unless I am reading it wrong, or I am just cluless, but I don't understand how what you wrote relates to my question. Clarify if you were attempting to...
  2. VBA code runs in excel 2003, but gives error message in excel 2010

    I wrote a line of code to rename worksheets in my excel spreadsheet, and it executes perfectly at home where I have 2003 software, but at work where I need it to run, I get the following message: ...
  3. Replies
    5
    Views
    2,050

    Re: Protect all worksheets except one

    True! Sorry about that. Great code. Thanks. Such a simple solution, but I haven't done vba in so long, I couldn't even remember how to do elseif statements! :D Thanks for the help!
  4. Replies
    5
    Views
    2,050

    Re: Protect all worksheets except one

    So simple! :D However, there now isn't a line of code to unprotect every worksheet. Would I need to embed another if statement. Because I still need the line, if protect contents is true then...
  5. Replies
    5
    Views
    2,050

    Protect all worksheets except one

    I have used the code from ozgrid website to protect all worksheets, but then I have worksheet in the workbook where users need to insert objects, and they will not be able to if that worksheet is...
  6. Re: Lookup Nth Occurence In Range & Limit Rows To Search Based On Cell Value

    Dave-
    I see how that would work. That is awesome that you can just build the arguments of the function like that (but I guess that would make sense seeing how it is a UDF). I never imagined...
  7. Lookup Nth Occurence In Range & Limit Rows To Search Based On Cell Value

    So I have a UDF for a lookup_occurrence formula (thanks to Dave), and I was wondering if it was possible to tweak the range it looks at with if statements.

    I have a formula like this...
  8. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    Yes, thank you I got it to work. It was a layout issue with my table. I am learning :D

    Thanks!
  9. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    It didn't work; it is still just repeating the loop. Right now I have the value "Katie" as the 1st occurrence of high, and the value "Randy" as the 2nd. With my lookup_occurrence formula I went all...
  10. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    Thank you,; it is working fine! The only other thing is it loops clear back to the beginning. So if I am the formula reference the 7th occurrence, and the 7th occurrence does not exit, it returns...
  11. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    I have that custom function; is something different with this one?

    And what attachment; I did not see attachment.
  12. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    I did see that. Your example however is referencing cats, which is only a value in your table.

    My references are formulas that return high, med, low, and the lookup_occurence is not recognizing...
  13. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    Well I figured out why it was returning #value, but I need a way to fix it.

    The lookup_occurence formula is looking for the first occurrence of B8 (which currently says High), and returning the...
  14. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    This the lookup Custom Function.Lookup Occurence


    Function Lookup_Occurence(To_find, Table_array As Range, _
    Look_in_col As Long, Offset_col, Occurrence As Long, _
    Optional...
  15. Replies
    13
    Views
    3,049

    Re: Group Data With Changing Criteria

    Sorry, I am not trying to assume a means to an end at all.

    The teacher puts in the students score (didn't mean imported sorry).

    I thought I have explained what I want. Everything is fine...
  16. Replies
    13
    Views
    3,049

    Re: Group Data With Changing Criteria

    Here is the updated attachment with made up data in the cells.
  17. Replies
    13
    Views
    3,049

    Re: Group Data With Changing Criteria

    Well then I don't know how to do that if I can't have formulas in the data.

    I don't know whether a student will be high, low, or medium....until a score is imported for them. The formula then...
  18. Replies
    13
    Views
    3,049

    Re: Group Data With Changing Criteria

    Okay I have attempted to layout the data as you requested. I put 2 exit cards and 3 periods on the sample sheet. (Keep in mind it will be 8 periods and 10 exit cards per unit with 5 units total on...
  19. Replies
    13
    Views
    3,049

    Re: Group Data With Changing Criteria

    I apologize in advance for my ignorance, but I don't see what you are referring to. I have all related data together.

    I guess I do not understand what you mean by the terms raw data and data used...
  20. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    Sorry, I thought it was clear. The post I made about playing around with some coding was a response to your post.

    So is it impossible to embed the indirect(n5) into the array position of the...
  21. Replies
    13
    Views
    3,049

    Re: Group Data With Changing Criteria

    Bill--- Yes that is the approach I was thinking, with a slight modification. However, it is the coding for the macro that I am at a loss at. Any thoughts?


    FOR DAVE
    Dave-- I read that thread...
  22. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    Dave, I did see your post with the vlookup, and I read it.

    The reason why I changed it to lookup_occurence is because I need it to return a specific occurence. 1st occurence of high, then...
  23. Replies
    13
    Views
    3,049

    Re: Group Data With Changing Criteria

    Okay, I am assuming my original thought may not be possible, so here is what I am thinking now.

    When a teacher selects the class period and the assessment (i.e. conflict or test #2 etc), then it...
  24. Replies
    13
    Views
    3,049

    Group Data With Changing Criteria

    SEE SECOND POST I HAVE CHANGED WHAT I AM LOOKING FOR TO WHAT I THINK IS A BETTER SOLUTION TO MY PROBLEM

    This is in my mind a complicated problem; I will do my best to describe it.

    I have...
  25. Replies
    23
    Views
    28,947

    Re: Lookup Array/Range Based On Cell Value

    While coding the group if statements, I just realized another problem; however, since it deals with asking another question, I have posted it in another thread. If you think you know how to solve...
Results 1 to 25 of 75
Page 1 of 3 1 2 3
porno